	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

284 COLUMNS | 1 INDEXES | ERP 6.0 | PB0008 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Recruitment
1	ERP EHP7	6.0	PB0008	284	1	Applicant Master Record Infotype (Basic Pay)	Recruitment

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 PB0008

TOP ERP 6.0 | PB0008 COLUMNS

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

TOP ERP 6.0 | PB0008 INDEXES

Name	Primary	Unique	Type	Columns
PB0008~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 | PB0008 TABLE

TOP ERP 6.0 | PB0008 COLUMNS

TOP ERP 6.0 | PB0008 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 | PB0008 TABLE

TOPERP 6.0 | PB0008 COLUMNS

TOPERP 6.0 | PB0008 INDEXES

TOP ERP 6.0 | PB0008 COLUMNS

TOP ERP 6.0 | PB0008 INDEXES