	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

284 COLUMNS | 1 INDEXES | ERP 6.0 | PA0008 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0008	284	1	HR Master Record: Infotype 0008 (Basic Pay)	Personnel Administration

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, TRFAR, TRFGB, TRFGR, TRFST, STVOR, ORZST, PARTN, WAERS, VGLTA, VGLGB, VGLGR, VGLST, VGLSV, BSGRD, DIVGV, ANSAL, FALGK, FALGR, LGA01, BET01, ANZ01, EIN01, OPK01, LGA02, BET02, ANZ02, EIN02, OPK02, LGA03, BET03, ANZ03, EIN03, OPK03, LGA04, BET04, ANZ04, EIN04, OPK04, LGA05, BET05, ANZ05, EIN05, OPK05, LGA06, BET06, ANZ06, EIN06, OPK06, LGA07, BET07, ANZ07, EIN07, OPK07, LGA08, BET08, ANZ08, EIN08, OPK08, LGA09, BET09, ANZ09, EIN09, OPK09, LGA10, BET10, ANZ10, EIN10, OPK10, LGA11, BET11, ANZ11, EIN11, OPK11, LGA12, BET12, ANZ12, EIN12, OPK12, LGA13, BET13, ANZ13, EIN13, OPK13, LGA14, BET14, ANZ14, EIN14, OPK14, LGA15, BET15, ANZ15, EIN15, OPK15, LGA16, BET16, ANZ16, EIN16, OPK16, LGA17, BET17, ANZ17, EIN17, OPK17, LGA18, BET18, ANZ18, EIN18, OPK18, LGA19, BET19, ANZ19, EIN19, OPK19, LGA20, BET20, ANZ20, EIN20, OPK20, LGA21, BET21, ANZ21, EIN21, OPK21, LGA22, BET22, ANZ22, EIN22, OPK22, LGA23, BET23, ANZ23, EIN23, OPK23, LGA24, BET24, ANZ24, EIN24, OPK24, LGA25, BET25, ANZ25, EIN25, OPK25, LGA26, BET26, ANZ26, EIN26, OPK26, LGA27, BET27, ANZ27, EIN27, OPK27, LGA28, BET28, ANZ28, EIN28, OPK28, LGA29, BET29, ANZ29, EIN29, OPK29, LGA30, BET30, ANZ30, EIN30, OPK30, LGA31, BET31, ANZ31, EIN31, OPK31, LGA32, BET32, ANZ32, EIN32, OPK32, LGA33, BET33, ANZ33, EIN33, OPK33, LGA34, BET34, ANZ34, EIN34, OPK34, LGA35, BET35, ANZ35, EIN35, OPK35, LGA36, BET36, ANZ36, EIN36, OPK36, LGA37, BET37, ANZ37, EIN37, OPK37, LGA38, BET38, ANZ38, EIN38, OPK38, LGA39, BET39, ANZ39, EIN39, OPK39, LGA40, BET40, ANZ40, EIN40, OPK40, IND01, IND02, IND03, IND04, IND05, IND06, IND07, IND08, IND09, IND10, IND11, IND12, IND13, IND14, IND15, IND16, IND17, IND18, IND19, IND20, IND21, IND22, IND23, IND24, IND25, IND26, IND27, IND28, IND29, IND30, IND31, IND32, IND33, IND34, IND35, IND36, IND37, IND38, IND39, IND40, ANCUR, CPIND, FLAGA FROM PA0008

TOP ERP 6.0 | PA0008 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	TRFAR	Pay scale type	nvarchar	2	0	Allow NULL?
25	TRFGB	Pay Scale Area	nvarchar	2	0	Allow NULL?
26	TRFGR	Pay Scale Group	nvarchar	8	0	Allow NULL?
27	TRFST	Pay Scale Level	nvarchar	2	0	Allow NULL?
28	STVOR	Date of Next Increase	nvarchar	8	0	Allow NULL?
29	ORZST	Cost of Living Allowance Level	nvarchar	2	0	Allow NULL?
30	PARTN	Partnership	nvarchar	2	0	Allow NULL?
31	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
32	VGLTA	Comparison pay scale type	nvarchar	2	0	Allow NULL?
33	VGLGB	Comparison pay scale area	nvarchar	2	0	Allow NULL?
34	VGLGR	Comparison pay scale group	nvarchar	8	0	Allow NULL?
35	VGLST	Comparison pay scale level	nvarchar	2	0	Allow NULL?
36	VGLSV	Date of Next Increase	nvarchar	8	0	Allow NULL?
37	BSGRD	Capacity Utilization Level	decimal	5	2
38	DIVGV	Working Hours per Payroll Period	decimal	5	2
39	ANSAL	Annual salary	decimal	15	2
40	FALGK	Case group catalog	nvarchar	10	0	Allow NULL?
41	FALGR	Case group	nvarchar	6	0	Allow NULL?
42	LGA01	Wage Type	nvarchar	4	0	Allow NULL?
43	BET01	Wage Type Amount for Payments	decimal	13	2
44	ANZ01	Number	decimal	7	2
45	EIN01	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
46	OPK01	Operation Indicator for Wage Types	char	1	0	Allow NULL?
47	LGA02	Wage Type	nvarchar	4	0	Allow NULL?
48	BET02	Wage Type Amount for Payments	decimal	13	2
49	ANZ02	Number	decimal	7	2
50	EIN02	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
51	OPK02	Operation Indicator for Wage Types	char	1	0	Allow NULL?
52	LGA03	Wage Type	nvarchar	4	0	Allow NULL?
53	BET03	Wage Type Amount for Payments	decimal	13	2
54	ANZ03	Number	decimal	7	2
55	EIN03	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
56	OPK03	Operation Indicator for Wage Types	char	1	0	Allow NULL?
57	LGA04	Wage Type	nvarchar	4	0	Allow NULL?
58	BET04	Wage Type Amount for Payments	decimal	13	2
59	ANZ04	Number	decimal	7	2
60	EIN04	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
61	OPK04	Operation Indicator for Wage Types	char	1	0	Allow NULL?
62	LGA05	Wage Type	nvarchar	4	0	Allow NULL?
63	BET05	Wage Type Amount for Payments	decimal	13	2
64	ANZ05	Number	decimal	7	2
65	EIN05	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
66	OPK05	Operation Indicator for Wage Types	char	1	0	Allow NULL?
67	LGA06	Wage Type	nvarchar	4	0	Allow NULL?
68	BET06	Wage Type Amount for Payments	decimal	13	2
69	ANZ06	Number	decimal	7	2
70	EIN06	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
71	OPK06	Operation Indicator for Wage Types	char	1	0	Allow NULL?
72	LGA07	Wage Type	nvarchar	4	0	Allow NULL?
73	BET07	Wage Type Amount for Payments	decimal	13	2
74	ANZ07	Number	decimal	7	2
75	EIN07	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
76	OPK07	Operation Indicator for Wage Types	char	1	0	Allow NULL?
77	LGA08	Wage Type	nvarchar	4	0	Allow NULL?
78	BET08	Wage Type Amount for Payments	decimal	13	2
79	ANZ08	Number	decimal	7	2
80	EIN08	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
81	OPK08	Operation Indicator for Wage Types	char	1	0	Allow NULL?
82	LGA09	Wage Type	nvarchar	4	0	Allow NULL?
83	BET09	Wage Type Amount for Payments	decimal	13	2
84	ANZ09	Number	decimal	7	2
85	EIN09	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
86	OPK09	Operation Indicator for Wage Types	char	1	0	Allow NULL?
87	LGA10	Wage Type	nvarchar	4	0	Allow NULL?
88	BET10	Wage Type Amount for Payments	decimal	13	2
89	ANZ10	Number	decimal	7	2
90	EIN10	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
91	OPK10	Operation Indicator for Wage Types	char	1	0	Allow NULL?
92	LGA11	Wage Type	nvarchar	4	0	Allow NULL?
93	BET11	Wage Type Amount for Payments	decimal	13	2
94	ANZ11	Number	decimal	7	2
95	EIN11	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
96	OPK11	Operation Indicator for Wage Types	char	1	0	Allow NULL?
97	LGA12	Wage Type	nvarchar	4	0	Allow NULL?
98	BET12	Wage Type Amount for Payments	decimal	13	2
99	ANZ12	Number	decimal	7	2
100	EIN12	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
101	OPK12	Operation Indicator for Wage Types	char	1	0	Allow NULL?
102	LGA13	Wage Type	nvarchar	4	0	Allow NULL?
103	BET13	Wage Type Amount for Payments	decimal	13	2
104	ANZ13	Number	decimal	7	2
105	EIN13	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
106	OPK13	Operation Indicator for Wage Types	char	1	0	Allow NULL?
107	LGA14	Wage Type	nvarchar	4	0	Allow NULL?
108	BET14	Wage Type Amount for Payments	decimal	13	2
109	ANZ14	Number	decimal	7	2
110	EIN14	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
111	OPK14	Operation Indicator for Wage Types	char	1	0	Allow NULL?
112	LGA15	Wage Type	nvarchar	4	0	Allow NULL?
113	BET15	Wage Type Amount for Payments	decimal	13	2
114	ANZ15	Number	decimal	7	2
115	EIN15	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
116	OPK15	Operation Indicator for Wage Types	char	1	0	Allow NULL?
117	LGA16	Wage Type	nvarchar	4	0	Allow NULL?
118	BET16	Wage Type Amount for Payments	decimal	13	2
119	ANZ16	Number	decimal	7	2
120	EIN16	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
121	OPK16	Operation Indicator for Wage Types	char	1	0	Allow NULL?
122	LGA17	Wage Type	nvarchar	4	0	Allow NULL?
123	BET17	Wage Type Amount for Payments	decimal	13	2
124	ANZ17	Number	decimal	7	2
125	EIN17	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
126	OPK17	Operation Indicator for Wage Types	char	1	0	Allow NULL?
127	LGA18	Wage Type	nvarchar	4	0	Allow NULL?
128	BET18	Wage Type Amount for Payments	decimal	13	2
129	ANZ18	Number	decimal	7	2
130	EIN18	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
131	OPK18	Operation Indicator for Wage Types	char	1	0	Allow NULL?
132	LGA19	Wage Type	nvarchar	4	0	Allow NULL?
133	BET19	Wage Type Amount for Payments	decimal	13	2
134	ANZ19	Number	decimal	7	2
135	EIN19	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
136	OPK19	Operation Indicator for Wage Types	char	1	0	Allow NULL?
137	LGA20	Wage Type	nvarchar	4	0	Allow NULL?
138	BET20	Wage Type Amount for Payments	decimal	13	2
139	ANZ20	Number	decimal	7	2
140	EIN20	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
141	OPK20	Operation Indicator for Wage Types	char	1	0	Allow NULL?
142	LGA21	Wage Type	nvarchar	4	0	Allow NULL?
143	BET21	Wage Type Amount for Payments	decimal	13	2
144	ANZ21	Number	decimal	7	2
145	EIN21	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
146	OPK21	Operation Indicator for Wage Types	char	1	0	Allow NULL?
147	LGA22	Wage Type	nvarchar	4	0	Allow NULL?
148	BET22	Wage Type Amount for Payments	decimal	13	2
149	ANZ22	Number	decimal	7	2
150	EIN22	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
151	OPK22	Operation Indicator for Wage Types	char	1	0	Allow NULL?
152	LGA23	Wage Type	nvarchar	4	0	Allow NULL?
153	BET23	Wage Type Amount for Payments	decimal	13	2
154	ANZ23	Number	decimal	7	2
155	EIN23	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
156	OPK23	Operation Indicator for Wage Types	char	1	0	Allow NULL?
157	LGA24	Wage Type	nvarchar	4	0	Allow NULL?
158	BET24	Wage Type Amount for Payments	decimal	13	2
159	ANZ24	Number	decimal	7	2
160	EIN24	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
161	OPK24	Operation Indicator for Wage Types	char	1	0	Allow NULL?
162	LGA25	Wage Type	nvarchar	4	0	Allow NULL?
163	BET25	Wage Type Amount for Payments	decimal	13	2
164	ANZ25	Number	decimal	7	2
165	EIN25	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
166	OPK25	Operation Indicator for Wage Types	char	1	0	Allow NULL?
167	LGA26	Wage Type	nvarchar	4	0	Allow NULL?
168	BET26	Wage Type Amount for Payments	decimal	13	2
169	ANZ26	Number	decimal	7	2
170	EIN26	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
171	OPK26	Operation Indicator for Wage Types	char	1	0	Allow NULL?
172	LGA27	Wage Type	nvarchar	4	0	Allow NULL?
173	BET27	Wage Type Amount for Payments	decimal	13	2
174	ANZ27	Number	decimal	7	2
175	EIN27	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
176	OPK27	Operation Indicator for Wage Types	char	1	0	Allow NULL?
177	LGA28	Wage Type	nvarchar	4	0	Allow NULL?
178	BET28	Wage Type Amount for Payments	decimal	13	2
179	ANZ28	Number	decimal	7	2
180	EIN28	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
181	OPK28	Operation Indicator for Wage Types	char	1	0	Allow NULL?
182	LGA29	Wage Type	nvarchar	4	0	Allow NULL?
183	BET29	Wage Type Amount for Payments	decimal	13	2
184	ANZ29	Number	decimal	7	2
185	EIN29	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
186	OPK29	Operation Indicator for Wage Types	char	1	0	Allow NULL?
187	LGA30	Wage Type	nvarchar	4	0	Allow NULL?
188	BET30	Wage Type Amount for Payments	decimal	13	2
189	ANZ30	Number	decimal	7	2
190	EIN30	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
191	OPK30	Operation Indicator for Wage Types	char	1	0	Allow NULL?
192	LGA31	Wage Type	nvarchar	4	0	Allow NULL?
193	BET31	Wage Type Amount for Payments	decimal	13	2
194	ANZ31	Number	decimal	7	2
195	EIN31	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
196	OPK31	Operation Indicator for Wage Types	char	1	0	Allow NULL?
197	LGA32	Wage Type	nvarchar	4	0	Allow NULL?
198	BET32	Wage Type Amount for Payments	decimal	13	2
199	ANZ32	Number	decimal	7	2
200	EIN32	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
201	OPK32	Operation Indicator for Wage Types	char	1	0	Allow NULL?
202	LGA33	Wage Type	nvarchar	4	0	Allow NULL?
203	BET33	Wage Type Amount for Payments	decimal	13	2
204	ANZ33	Number	decimal	7	2
205	EIN33	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
206	OPK33	Operation Indicator for Wage Types	char	1	0	Allow NULL?
207	LGA34	Wage Type	nvarchar	4	0	Allow NULL?
208	BET34	Wage Type Amount for Payments	decimal	13	2
209	ANZ34	Number	decimal	7	2
210	EIN34	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
211	OPK34	Operation Indicator for Wage Types	char	1	0	Allow NULL?
212	LGA35	Wage Type	nvarchar	4	0	Allow NULL?
213	BET35	Wage Type Amount for Payments	decimal	13	2
214	ANZ35	Number	decimal	7	2
215	EIN35	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
216	OPK35	Operation Indicator for Wage Types	char	1	0	Allow NULL?
217	LGA36	Wage Type	nvarchar	4	0	Allow NULL?
218	BET36	Wage Type Amount for Payments	decimal	13	2
219	ANZ36	Number	decimal	7	2
220	EIN36	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
221	OPK36	Operation Indicator for Wage Types	char	1	0	Allow NULL?
222	LGA37	Wage Type	nvarchar	4	0	Allow NULL?
223	BET37	Wage Type Amount for Payments	decimal	13	2
224	ANZ37	Number	decimal	7	2
225	EIN37	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
226	OPK37	Operation Indicator for Wage Types	char	1	0	Allow NULL?
227	LGA38	Wage Type	nvarchar	4	0	Allow NULL?
228	BET38	Wage Type Amount for Payments	decimal	13	2
229	ANZ38	Number	decimal	7	2
230	EIN38	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
231	OPK38	Operation Indicator for Wage Types	char	1	0	Allow NULL?
232	LGA39	Wage Type	nvarchar	4	0	Allow NULL?
233	BET39	Wage Type Amount for Payments	decimal	13	2
234	ANZ39	Number	decimal	7	2
235	EIN39	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
236	OPK39	Operation Indicator for Wage Types	char	1	0	Allow NULL?
237	LGA40	Wage Type	nvarchar	4	0	Allow NULL?
238	BET40	Wage Type Amount for Payments	decimal	13	2
239	ANZ40	Number	decimal	7	2
240	EIN40	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
241	OPK40	Operation Indicator for Wage Types	char	1	0	Allow NULL?
242	IND01	Indicator for indirect valuation	char	1	0	Allow NULL?
243	IND02	Indicator for indirect valuation	char	1	0	Allow NULL?
244	IND03	Indicator for indirect valuation	char	1	0	Allow NULL?
245	IND04	Indicator for indirect valuation	char	1	0	Allow NULL?
246	IND05	Indicator for indirect valuation	char	1	0	Allow NULL?
247	IND06	Indicator for indirect valuation	char	1	0	Allow NULL?
248	IND07	Indicator for indirect valuation	char	1	0	Allow NULL?
249	IND08	Indicator for indirect valuation	char	1	0	Allow NULL?
250	IND09	Indicator for indirect valuation	char	1	0	Allow NULL?
251	IND10	Indicator for indirect valuation	char	1	0	Allow NULL?
252	IND11	Indicator for indirect valuation	char	1	0	Allow NULL?
253	IND12	Indicator for indirect valuation	char	1	0	Allow NULL?
254	IND13	Indicator for indirect valuation	char	1	0	Allow NULL?
255	IND14	Indicator for indirect valuation	char	1	0	Allow NULL?
256	IND15	Indicator for indirect valuation	char	1	0	Allow NULL?
257	IND16	Indicator for indirect valuation	char	1	0	Allow NULL?
258	IND17	Indicator for indirect valuation	char	1	0	Allow NULL?
259	IND18	Indicator for indirect valuation	char	1	0	Allow NULL?
260	IND19	Indicator for indirect valuation	char	1	0	Allow NULL?
261	IND20	Indicator for indirect valuation	char	1	0	Allow NULL?
262	IND21	Indicator for indirect valuation	char	1	0	Allow NULL?
263	IND22	Indicator for indirect valuation	char	1	0	Allow NULL?
264	IND23	Indicator for indirect valuation	char	1	0	Allow NULL?
265	IND24	Indicator for indirect valuation	char	1	0	Allow NULL?
266	IND25	Indicator for indirect valuation	char	1	0	Allow NULL?
267	IND26	Indicator for indirect valuation	char	1	0	Allow NULL?
268	IND27	Indicator for indirect valuation	char	1	0	Allow NULL?
269	IND28	Indicator for indirect valuation	char	1	0	Allow NULL?
270	IND29	Indicator for indirect valuation	char	1	0	Allow NULL?
271	IND30	Indicator for indirect valuation	char	1	0	Allow NULL?
272	IND31	Indicator for indirect valuation	char	1	0	Allow NULL?
273	IND32	Indicator for indirect valuation	char	1	0	Allow NULL?
274	IND33	Indicator for indirect valuation	char	1	0	Allow NULL?
275	IND34	Indicator for indirect valuation	char	1	0	Allow NULL?
276	IND35	Indicator for indirect valuation	char	1	0	Allow NULL?
277	IND36	Indicator for indirect valuation	char	1	0	Allow NULL?
278	IND37	Indicator for indirect valuation	char	1	0	Allow NULL?
279	IND38	Indicator for indirect valuation	char	1	0	Allow NULL?
280	IND39	Indicator for indirect valuation	char	1	0	Allow NULL?
281	IND40	Indicator for indirect valuation	char	1	0	Allow NULL?
282	ANCUR	Currency Key for Annual Salary	nvarchar	5	0	Allow NULL?
283	CPIND	Planned compensation type	char	1	0	Allow NULL?
284	FLAGA	General Flag	char	1	0	Allow NULL?

TOP ERP 6.0 | PA0008 INDEXES

Name	Primary	Unique	Type	Columns
PA0008~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

284 COLUMNS | 1 INDEXES | ERP 6.0 | PA0008 TABLE

TOP ERP 6.0 | PA0008 COLUMNS

TOP ERP 6.0 | PA0008 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

284 COLUMNS | 1 INDEXES | ERP 6.0 | PA0008 TABLE

TOPERP 6.0 | PA0008 COLUMNS

TOPERP 6.0 | PA0008 INDEXES

TOP ERP 6.0 | PA0008 COLUMNS

TOP ERP 6.0 | PA0008 INDEXES