ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Payroll
1	ERP EHP7	6.0	T5H7O	159	1	Monthly statistical reports	Payroll

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	T000	MANDT	Allow NULL?
2	LFNMR	Serial number	nvarchar	10	0	NUMC	(N'0000000000')	No		P21_LFNMR	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
4	WERKS	Personnel Area	nvarchar	4	0	CHAR	(N' ')	Yes	T500P	PERSA	Allow NULL?
5	BZCOD	County code in Hungary	nvarchar	2	0	CHAR	(N' ')	Yes	T5H7K	P21_BZCOD	Allow NULL?
6	SJAHR	Year	nvarchar	4	0	CHAR	(N' ')	Yes		P21_SJAHR	Allow NULL?
7	MONAT	Month	nvarchar	2	0	CHAR	(N' ')	Yes		P21_MONAT	Allow NULL?
8	ERDAT	Created on	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ERDAT	Allow NULL?
9	ERSTL	Created by	nvarchar	12	0	CHAR	(N' ')	Yes		P21_ERSTL	Allow NULL?
10	LISTG	List generated by	char	1	0	CHAR	(N' ')	Yes		P21_LISTG	Allow NULL?
11	AEDAT	Changed date	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_AEDAT	Allow NULL?
12	GEADT	Changed by	nvarchar	12	0	CHAR	(N' ')	Yes		P21_GEADT	Allow NULL?
13	LISTM	List changed by	char	1	0	CHAR	(N' ')	Yes		P21_LISTM	Allow NULL?
14	AMGSD	Sent to office	char	1	0	CHAR	(N' ')	Yes		P21_AMGSD	Allow NULL?
15	AVPAR	Attendance - full-time manual workers	decimal	12	2	DEC	((0))	Yes		P21_AVPAR
16	AVPAN	Attendance - full-time, female manual worker	decimal	12	2	DEC	((0))	Yes		P21_AVPAN
17	AVGAR	Attendance - full-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_AVGAR
18	AVGAN	Attendance - full-time, female, white collar workers	decimal	12	2	DEC	((0))	Yes		P21_AVGAN
19	ATPAR	Attendance - part-time, manual worker	decimal	12	2	DEC	((0))	Yes		P21_ATPAR
20	ATPAM	Attendance - part-time, manual worker, outworker	decimal	12	2	DEC	((0))	Yes		P21_ATPAM
21	ATGAR	Attendance - part-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_ATGAR
22	ATGAM	Attendance - part-time, white collar worker, outworker	decimal	12	2	DEC	((0))	Yes		P21_ATGAM
23	APPAR	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
24	APGAR	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
25	BVPAR	Attendance - full-time manual workers	decimal	12	2	DEC	((0))	Yes		P21_AVPAR
26	BVPAN	Attendance - full-time, female manual worker	decimal	12	2	DEC	((0))	Yes		P21_AVPAN
27	BVGAR	Attendance - full-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_AVGAR
28	BVGAN	Attendance - full-time, female, white collar workers	decimal	12	2	DEC	((0))	Yes		P21_AVGAN
29	BTPAR	Attendance - part-time, manual worker	decimal	12	2	DEC	((0))	Yes		P21_ATPAR
30	BTPAM	Attendance - part-time, manual worker, outworker	decimal	12	2	DEC	((0))	Yes		P21_ATPAM
31	BTGAR	Attendance - part-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_ATGAR
32	BTGAM	Attendance - part-time, white collar worker, outworker	decimal	12	2	DEC	((0))	Yes		P21_ATGAM
33	BPPAR	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
34	BPGAR	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
35	LVPAR	Wage - full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAR
36	EVPAR	Wage - full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAR
37	LVPAN	Wage - full-time, manual female workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAN
38	EVPAN	Wage - full-time, manual female workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAN
39	LVGAR	Wage - full-time, white collar workers	decimal	12	2	DEC	((0))	Yes		P21_LVGAR
40	EVGAR	Wage - full-time, white collar workers	decimal	12	2	DEC	((0))	Yes		P21_LVGAR
41	LVGAN	Wage - full-time, white collar workers, female	decimal	12	2	DEC	((0))	Yes		P21_LVGAN
42	EVGAN	Wage - full-time, white collar workers, female	decimal	12	2	DEC	((0))	Yes		P21_LVGAN
43	LTPAR	Wage - part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LTPAR
44	ETPAR	Wage - part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LTPAR
45	LTPAM	Wage - part-time, manual workers, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTPAM
46	ETPAM	Wage - part-time, manual workers, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTPAM
47	LTGAR	Wage - part-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_LTGAR
48	ETGAR	Wage - part-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_LTGAR
49	LTGAM	Wage - part-time, white collar persons, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTGAM
50	ETGAM	Wage - part-time, white collar persons, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTGAM
51	LPPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
52	EPPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
53	LPGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
54	EPGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
55	LAABS	Wage - worker being staff off the payroll	decimal	12	2	DEC	((0))	Yes		P21_LAABS
56	EAABS	Wage - worker being staff off the payroll	decimal	12	2	DEC	((0))	Yes		P21_LAABS
57	MVPAR	Wage - full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAR
58	KVPAR	Wage - full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAR
59	MVPAN	Wage - full-time, manual female workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAN
60	KVPAN	Wage - full-time, manual female workers	decimal	12	2	DEC	((0))	Yes		P21_LVPAN
61	MVGAR	Wage - full-time, white collar workers	decimal	12	2	DEC	((0))	Yes		P21_LVGAR
62	KVGAR	Wage - full-time, white collar workers	decimal	12	2	DEC	((0))	Yes		P21_LVGAR
63	MVGAN	Wage - full-time, white collar workers, female	decimal	12	2	DEC	((0))	Yes		P21_LVGAN
64	KVGAN	Wage - full-time, white collar workers, female	decimal	12	2	DEC	((0))	Yes		P21_LVGAN
65	MTPAR	Wage - part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LTPAR
66	KTPAR	Wage - part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_LTPAR
67	MTPAM	Wage - part-time, manual workers, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTPAM
68	KTPAM	Wage - part-time, manual workers, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTPAM
69	MTGAR	Wage - part-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_LTGAR
70	KTGAR	Wage - part-time, white collar worker	decimal	12	2	DEC	((0))	Yes		P21_LTGAR
71	MTGAM	Wage - part-time, white collar persons, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTGAM
72	KTGAM	Wage - part-time, white collar persons, outworkers	decimal	12	2	DEC	((0))	Yes		P21_LTGAM
73	MPPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
74	KPPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
75	MPGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
76	KPGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
77	MAABS	Wage - worker being staff off the payroll	decimal	12	2	DEC	((0))	Yes		P21_LAABS
78	KAABS	Wage - worker being staff off the payroll	decimal	12	2	DEC	((0))	Yes		P21_LAABS
79	AYPAR	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
80	AYGAR	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
81	ATABS	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
82	AFAMI	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
83	BYPAR	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
84	BYGAR	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
85	BTABS	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
86	BFAMI	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
87	LYPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
88	LYGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
89	LTABS	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
90	LPREM	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
91	MYPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
92	MYGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
93	MTABS	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
94	MPREM	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
95	EYPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
96	EYGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
97	ETABS	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
98	EPREM	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
99	KYPAR	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
100	KYGAR	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
101	KTABS	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
102	KPREM	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
103	AMORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
104	ATFMO	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
105	ATORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
106	AYORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
107	ARORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
108	ANORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
109	BMORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
110	BTFMO	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
111	BTORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
112	BYORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
113	BRORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
114	BNORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
115	APPAN	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
116	APGAN	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
117	LPPAN	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
118	LPGAN	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
119	EPPAN	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
120	EPGAN	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
121	BPPAN	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
122	BPGAN	Attendance - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_APGAR
123	MPPAN	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
124	MPGAN	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
125	KPPAN	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
126	KPGAN	Wage - white collar pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPGAR
127	ASZMK	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
128	LSZMK	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
129	ESZMK	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
130	BSZMK	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
131	MSZMK	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
132	KSZMK	Wage - manual worker pensioner	decimal	12	2	DEC	((0))	Yes		P21_LPPAR
133	AKPAR		decimal	12	0		((0))	Yes
134	BKPAR		decimal	12	0		((0))	Yes
135	CKPAR		decimal	12	0		((0))	Yes
136	AKOLC	Attendance - manual pensioner	decimal	12	2	DEC	((0))	Yes		P21_APPAR
137	AKORA	Hours worked	decimal	12	2	DEC	((0))	Yes		P21_AMORA
138	EV255	Attendance -- under the age of 25 and above the age of 55	decimal	12	2	DEC	((0))	Yes		P21_EV255
139	KFTMF	Attendance -- publicly employed, full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KFTMF
140	KTMFB	Wage -- publicly employed, full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KTMFB
141	KTMFE	Other income -- publicly employed, full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KTMFE
142	KTMFP	Premium -- publicly employed, full-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KTMFP
143	KFTSZ	Attendance -- publicly employed, full-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFTSZ
144	KFTSB	Wage -- publicly employed, full-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFTSB
145	KFTSE	Other -- publicly employed, full-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFTSE
146	KFTSP	Premium -- publicly employed, full-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFTSP
147	KFRFF	Attendance -- publicly employed, part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KFRFF
148	KFRFB	Wage -- publicly employed, part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KFRFB
149	KFRFE	Other -- publicly employed, part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KFRFE
150	KFRFP	Premium -- publicly employed, part-time, manual workers	decimal	12	2	DEC	((0))	Yes		P21_KFRFP
151	KFRSZ	Attendance -- publicly employed, part-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFRSZ
152	KFRSB	Wage -- publicly employed, part-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFRSB
153	KFRSE	Other -- publicly employed, part-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFRSE
154	KFRSP	Premium -- publicly employed, part-time, white collars	decimal	12	2	DEC	((0))	Yes		P21_KFRSP
155	KF60L	Attendance -- publ. empl., less than 60 working hours/month	decimal	12	2	DEC	((0))	Yes		P21_KF60L
156	KF60B	Wage -- publicly employed, less than 60 working hours/month	decimal	12	2	DEC	((0))	Yes		P21_KF60B
157	KF60E	Other -- publicly employed, less than 60 working hours/month	decimal	12	2	DEC	((0))	Yes		P21_KF60E
158	KF60P	Premium -- publicly empl., less than 60 working hours/month	decimal	12	2	DEC	((0))	Yes		P21_KF60P
159	KFORA	Working hours performed by publicly employed persons	decimal	12	2	DEC	((0))	Yes		P21_KFORA

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

159 COLUMNS | 1 INDEXES | ERP 6.0 | T5H7O TABLE

TOP ERP 6.0 | T5H7O COLUMNS

TOP ERP 6.0 | T5H7O 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

159 COLUMNS | 1 INDEXES | ERP 6.0 | T5H7O TABLE

TOPERP 6.0 | T5H7O COLUMNS

TOPERP 6.0 | T5H7O INDEXES

TOP ERP 6.0 | T5H7O COLUMNS

TOP ERP 6.0 | T5H7O INDEXES