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
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA3220	169	1	HR Master Record: Infotype 3220	Personnel Administration

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	KAD	KAD	nvarchar	5	0	Allow NULL?
25	SPIKA	Specialty IKA	nvarchar	12	0	Allow NULL?
26	SPINS	Special Insurance	nvarchar	2	0	Allow NULL?
27	KPK	KPK	nvarchar	4	0	Allow NULL?
28	DEPAR	Department IKA	nvarchar	4	0	Allow NULL?
29	ALLDA	All Working Days	char	1	0	Allow NULL?
30	FSCHD	Full Time Schedule	char	1	0	Allow NULL?
31	AMKA	AMKA	nvarchar	18	0	Allow NULL?
32	TYINS	Type of Insurance	nvarchar	2	0	Allow NULL?
33	RGIKA	Registration Number IKA	nvarchar	18	0	Allow NULL?
34	SIF01	Social Insurance Fund	nvarchar	4	0	Allow NULL?
35	ENT01	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
36	EN201	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
37	DGR01	Date of Degree	nvarchar	8	0	Allow NULL?
38	REG01	Fund Registration Number	nvarchar	18	0	Allow NULL?
39	PRE01	Percentage EE	decimal	6	2
40	AME01	Amount EE	decimal	13	2
41	PRR01	Percentage ER	decimal	6	2
42	AMR01	Amount ER	decimal	13	2
43	SIF02	Social Insurance Fund	nvarchar	4	0	Allow NULL?
44	ENT02	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
45	EN202	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
46	DGR02	Date of Degree	nvarchar	8	0	Allow NULL?
47	REG02	Fund Registration Number	nvarchar	18	0	Allow NULL?
48	PRE02	Percentage EE	decimal	6	2
49	AME02	Amount EE	decimal	13	2
50	PRR02	Percentage ER	decimal	6	2
51	AMR02	Amount ER	decimal	13	2
52	SIF03	Social Insurance Fund	nvarchar	4	0	Allow NULL?
53	ENT03	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
54	EN203	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
55	DGR03	Date of Degree	nvarchar	8	0	Allow NULL?
56	REG03	Fund Registration Number	nvarchar	18	0	Allow NULL?
57	PRE03	Percentage EE	decimal	6	2
58	AME03	Amount EE	decimal	13	2
59	PRR03	Percentage ER	decimal	6	2
60	AMR03	Amount ER	decimal	13	2
61	SIF04	Social Insurance Fund	nvarchar	4	0	Allow NULL?
62	ENT04	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
63	EN204	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
64	DGR04	Date of Degree	nvarchar	8	0	Allow NULL?
65	REG04	Fund Registration Number	nvarchar	18	0	Allow NULL?
66	PRE04	Percentage EE	decimal	6	2
67	AME04	Amount EE	decimal	13	2
68	PRR04	Percentage ER	decimal	6	2
69	AMR04	Amount ER	decimal	13	2
70	SIF05	Social Insurance Fund	nvarchar	4	0	Allow NULL?
71	ENT05	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
72	EN205	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
73	DGR05	Date of Degree	nvarchar	8	0	Allow NULL?
74	REG05	Fund Registration Number	nvarchar	18	0	Allow NULL?
75	PRE05	Percentage EE	decimal	6	2
76	AME05	Amount EE	decimal	13	2
77	PRR05	Percentage ER	decimal	6	2
78	AMR05	Amount ER	decimal	13	2
79	SIF06	Social Insurance Fund	nvarchar	4	0	Allow NULL?
80	ENT06	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
81	EN206	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
82	DGR06	Date of Degree	nvarchar	8	0	Allow NULL?
83	REG06	Fund Registration Number	nvarchar	18	0	Allow NULL?
84	PRE06	Percentage EE	decimal	6	2
85	AME06	Amount EE	decimal	13	2
86	PRR06	Percentage ER	decimal	6	2
87	AMR06	Amount ER	decimal	13	2
88	SIF07	Social Insurance Fund	nvarchar	4	0	Allow NULL?
89	ENT07	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
90	EN207	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
91	DGR07	Date of Degree	nvarchar	8	0	Allow NULL?
92	REG07	Fund Registration Number	nvarchar	18	0	Allow NULL?
93	PRE07	Percentage EE	decimal	6	2
94	AME07	Amount EE	decimal	13	2
95	PRR07	Percentage ER	decimal	6	2
96	AMR07	Amount ER	decimal	13	2
97	SIF08	Social Insurance Fund	nvarchar	4	0	Allow NULL?
98	ENT08	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
99	EN208	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
100	DGR08	Date of Degree	nvarchar	8	0	Allow NULL?
101	REG08	Fund Registration Number	nvarchar	18	0	Allow NULL?
102	PRE08	Percentage EE	decimal	6	2
103	AME08	Amount EE	decimal	13	2
104	PRR08	Percentage ER	decimal	6	2
105	AMR08	Amount ER	decimal	13	2
106	SIF09	Social Insurance Fund	nvarchar	4	0	Allow NULL?
107	ENT09	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
108	EN209	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
109	DGR09	Date of Degree	nvarchar	8	0	Allow NULL?
110	REG09	Fund Registration Number	nvarchar	18	0	Allow NULL?
111	PRE09	Percentage EE	decimal	6	2
112	AME09	Amount EE	decimal	13	2
113	PRR09	Percentage ER	decimal	6	2
114	AMR09	Amount ER	decimal	13	2
115	SIF10	Social Insurance Fund	nvarchar	4	0	Allow NULL?
116	ENT10	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
117	EN210	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
118	DGR10	Date of Degree	nvarchar	8	0	Allow NULL?
119	REG10	Fund Registration Number	nvarchar	18	0	Allow NULL?
120	PRE10	Percentage EE	decimal	6	2
121	AME10	Amount EE	decimal	13	2
122	PRR10	Percentage ER	decimal	6	2
123	AMR10	Amount ER	decimal	13	2
124	SIF11	Social Insurance Fund	nvarchar	4	0	Allow NULL?
125	ENT11	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
126	EN211	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
127	DGR11	Date of Degree	nvarchar	8	0	Allow NULL?
128	REG11	Fund Registration Number	nvarchar	18	0	Allow NULL?
129	PRE11	Percentage EE	decimal	6	2
130	AME11	Amount EE	decimal	13	2
131	PRR11	Percentage ER	decimal	6	2
132	AMR11	Amount ER	decimal	13	2
133	SIF12	Social Insurance Fund	nvarchar	4	0	Allow NULL?
134	ENT12	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
135	EN212	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
136	DGR12	Date of Degree	nvarchar	8	0	Allow NULL?
137	REG12	Fund Registration Number	nvarchar	18	0	Allow NULL?
138	PRE12	Percentage EE	decimal	6	2
139	AME12	Amount EE	decimal	13	2
140	PRR12	Percentage ER	decimal	6	2
141	AMR12	Amount ER	decimal	13	2
142	SIF13	Social Insurance Fund	nvarchar	4	0	Allow NULL?
143	ENT13	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
144	EN213	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
145	DGR13	Date of Degree	nvarchar	8	0	Allow NULL?
146	REG13	Fund Registration Number	nvarchar	18	0	Allow NULL?
147	PRE13	Percentage EE	decimal	6	2
148	AME13	Amount EE	decimal	13	2
149	PRR13	Percentage ER	decimal	6	2
150	AMR13	Amount ER	decimal	13	2
151	SIF14	Social Insurance Fund	nvarchar	4	0	Allow NULL?
152	ENT14	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
153	EN214	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
154	DGR14	Date of Degree	nvarchar	8	0	Allow NULL?
155	REG14	Fund Registration Number	nvarchar	18	0	Allow NULL?
156	PRE14	Percentage EE	decimal	6	2
157	AME14	Amount EE	decimal	13	2
158	PRR14	Percentage ER	decimal	6	2
159	AMR14	Amount ER	decimal	13	2
160	SIF15	Social Insurance Fund	nvarchar	4	0	Allow NULL?
161	ENT15	Entry Date in SI Fund	nvarchar	8	0	Allow NULL?
162	EN215	2nd Entry Date in Fund(TSMEDE)	nvarchar	8	0	Allow NULL?
163	DGR15	Date of Degree	nvarchar	8	0	Allow NULL?
164	REG15	Fund Registration Number	nvarchar	18	0	Allow NULL?
165	PRE15	Percentage EE	decimal	6	2
166	AME15	Amount EE	decimal	13	2
167	PRR15	Percentage ER	decimal	6	2
168	AMR15	Amount ER	decimal	13	2
169	WAERS	Currency Key	nvarchar	5	0	Allow NULL?

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

169 COLUMNS | 1 INDEXES | ERP 6.0 | PA3220 TABLE

TOP ERP 6.0 | PA3220 COLUMNS

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

169 COLUMNS | 1 INDEXES | ERP 6.0 | PA3220 TABLE

TOPERP 6.0 | PA3220 COLUMNS

TOPERP 6.0 | PA3220 INDEXES

TOP ERP 6.0 | PA3220 COLUMNS

TOP ERP 6.0 | PA3220 INDEXES