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 :: Germany :: Construction Industry
1	ERP EHP7	6.0	PA0190	106	1	HR Master Data Record Infotype 0190 (BuildingTradePrevERDat)	Construction Industry

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	VORAG	Name of Previous Employer	nvarchar	20	0	Allow NULL?
25	BTRNR	Previous Employer Company Number for Suppl. Pension Fund	nvarchar	8	0	Allow NULL?
26	ZVKAS	Pension Fund: Previous Employer	nvarchar	2	0	Allow NULL?
27	LGA01	Wage Type	nvarchar	4	0	Allow NULL?
28	ANZ01	Number of Days	decimal	5	2
29	BPE01	Number of Additional Days	decimal	5	2
30	BET01	Amount	decimal	9	2
31	LGA02	Wage Type	nvarchar	4	0	Allow NULL?
32	ANZ02	Number of Days	decimal	5	2
33	BPE02	Number of Additional Days	decimal	5	2
34	BET02	Amount	decimal	9	2
35	LGA03	Wage Type	nvarchar	4	0	Allow NULL?
36	ANZ03	Number of Days	decimal	5	2
37	BPE03	Number of Additional Days	decimal	5	2
38	BET03	Amount	decimal	9	2
39	LGA04	Wage Type	nvarchar	4	0	Allow NULL?
40	ANZ04	Number of Days	decimal	5	2
41	BPE04	Number of Additional Days	decimal	5	2
42	BET04	Amount	decimal	9	2
43	LGA05	Wage Type	nvarchar	4	0	Allow NULL?
44	ANZ05	Number of Days	decimal	5	2
45	BPE05	Number of Additional Days	decimal	5	2
46	BET05	Amount	decimal	9	2
47	LGA06	Wage Type	nvarchar	4	0	Allow NULL?
48	ANZ06	Number of Days	decimal	5	2
49	BPE06	Number of Additional Days	decimal	5	2
50	BET06	Amount	decimal	9	2
51	LGA07	Wage Type	nvarchar	4	0	Allow NULL?
52	ANZ07	Number of Days	decimal	5	2
53	BPE07	Number of Additional Days	decimal	5	2
54	BET07	Amount	decimal	9	2
55	LGA08	Wage Type	nvarchar	4	0	Allow NULL?
56	ANZ08	Number of Days	decimal	5	2
57	BPE08	Number of Additional Days	decimal	5	2
58	BET08	Amount	decimal	9	2
59	LGA09	Wage Type	nvarchar	4	0	Allow NULL?
60	ANZ09	Number of Days	decimal	5	2
61	BPE09	Number of Additional Days	decimal	5	2
62	BET09	Amount	decimal	9	2
63	LGA10	Wage Type	nvarchar	4	0	Allow NULL?
64	ANZ10	Number of Days	decimal	5	2
65	BPE10	Number of Additional Days	decimal	5	2
66	BET10	Amount	decimal	9	2
67	LGA11	Wage Type	nvarchar	4	0	Allow NULL?
68	ANZ11	Number of Days	decimal	5	2
69	BPE11	Number of Additional Days	decimal	5	2
70	BET11	Amount	decimal	9	2
71	LGA12	Wage Type	nvarchar	4	0	Allow NULL?
72	ANZ12	Number of Days	decimal	5	2
73	BPE12	Number of Additional Days	decimal	5	2
74	BET12	Amount	decimal	9	2
75	LGA13	Wage Type	nvarchar	4	0	Allow NULL?
76	ANZ13	Number of Days	decimal	5	2
77	BPE13	Number of Additional Days	decimal	5	2
78	BET13	Amount	decimal	9	2
79	LGA14	Wage Type	nvarchar	4	0	Allow NULL?
80	ANZ14	Number of Days	decimal	5	2
81	BPE14	Number of Additional Days	decimal	5	2
82	BET14	Amount	decimal	9	2
83	LGA15	Wage Type	nvarchar	4	0	Allow NULL?
84	ANZ15	Number of Days	decimal	5	2
85	BPE15	Number of Additional Days	decimal	5	2
86	BET15	Amount	decimal	9	2
87	LGA16	Wage Type	nvarchar	4	0	Allow NULL?
88	ANZ16	Number of Days	decimal	5	2
89	BPE16	Number of Additional Days	decimal	5	2
90	BET16	Amount	decimal	9	2
91	LGA17	Wage Type	nvarchar	4	0	Allow NULL?
92	ANZ17	Number of Days	decimal	5	2
93	BPE17	Number of Additional Days	decimal	5	2
94	BET17	Amount	decimal	9	2
95	LGA18	Wage Type	nvarchar	4	0	Allow NULL?
96	ANZ18	Number of Days	decimal	5	2
97	BPE18	Number of Additional Days	decimal	5	2
98	BET18	Amount	decimal	9	2
99	LGA19	Wage Type	nvarchar	4	0	Allow NULL?
100	ANZ19	Number of Days	decimal	5	2
101	BPE19	Number of Additional Days	decimal	5	2
102	BET19	Amount	decimal	9	2
103	LGA20	Wage Type	nvarchar	4	0	Allow NULL?
104	ANZ20	Number of Days	decimal	5	2
105	BPE20	Number of Additional Days	decimal	5	2
106	BET20	Amount	decimal	9	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

106 COLUMNS | 1 INDEXES | ERP 6.0 | PA0190 TABLE

TOP ERP 6.0 | PA0190 COLUMNS

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

106 COLUMNS | 1 INDEXES | ERP 6.0 | PA0190 TABLE

TOPERP 6.0 | PA0190 COLUMNS

TOPERP 6.0 | PA0190 INDEXES

TOP ERP 6.0 | PA0190 COLUMNS

TOP ERP 6.0 | PA0190 INDEXES