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	/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

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	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

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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

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

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