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

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

207 COLUMNS | 1 INDEXES | ERP 6.0 | PA3350 TABLE

TOP ERP 6.0 | PA3350 COLUMNS

TOP ERP 6.0 | PA3350 INDEXES

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	Allow NULL?
6	ENDDA	End Date	nvarchar	8	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
11	HISTO	Historical Record Flag	char	1	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	Allow NULL?
24	PNALT	Previous Personnel Number	nvarchar	12	Allow NULL?
25	WAUSW	Company ID	nvarchar	12	Allow NULL?
26	FCARD		nvarchar	40	Allow NULL?
27	PKWRG	Regulation for Taxation of Company Car	char	1	Allow NULL?
28	PKWWR		decimal	11
29	KFZKZ	License Plate Number	nvarchar	20	Allow NULL?
30	WAERS	Currency Key	nvarchar	5	Allow NULL?
31	ANLNR	Car Asset Number	nvarchar	20	Allow NULL?
32	GEBNR	Building Number	nvarchar	6	Allow NULL?
33	ZIMNR	Room Number	nvarchar	6	Allow NULL?
34	TEL01	In-House Telephone Number	nvarchar	5	Allow NULL?
35	TEL02	In-House Telephone Number	nvarchar	5	Allow NULL?
36	COM01	Communication Type	nvarchar	4	Allow NULL?
37	NUM01	Communication Number	nvarchar	20	Allow NULL?
38	COM02	Communication Type	nvarchar	4	Allow NULL?
39	NUM02	Communication Number	nvarchar	20	Allow NULL?
40	COM03	Communication Type	nvarchar	4	Allow NULL?
41	NUM03	Communication Number	nvarchar	20	Allow NULL?
42	COM04	Communication Type	nvarchar	4	Allow NULL?
43	NUM04	Communication Number	nvarchar	20	Allow NULL?
44	COM05	Communication Type	nvarchar	4	Allow NULL?
45	NUM05	Communication Number	nvarchar	20	Allow NULL?
46	COM06	Communication Type	nvarchar	4	Allow NULL?
47	NUM06	Communication Number	nvarchar	20	Allow NULL?
48	DAT01	Date	nvarchar	8	Allow NULL?
49	TYP01		char	1	Allow NULL?
50	BTG01		decimal	11
51	WRS01	Currency Key	nvarchar	5	Allow NULL?
52	DAT02	Date	nvarchar	8	Allow NULL?
53	TYP02		char	1	Allow NULL?
54	BTG02		decimal	11
55	WRS02	Currency Key	nvarchar	5	Allow NULL?
56	DAT03	Date	nvarchar	8	Allow NULL?
57	TYP03		char	1	Allow NULL?
58	BTG03		decimal	11
59	WRS03	Currency Key	nvarchar	5	Allow NULL?
60	DAT04	Date	nvarchar	8	Allow NULL?
61	TYP04		char	1	Allow NULL?
62	BTG04		decimal	11
63	WRS04	Currency Key	nvarchar	5	Allow NULL?
64	DAT05	Date	nvarchar	8	Allow NULL?
65	TYP05		char	1	Allow NULL?
66	BTG05		decimal	11
67	WRS05	Currency Key	nvarchar	5	Allow NULL?
68	DAT06	Date	nvarchar	8	Allow NULL?
69	TYP06		char	1	Allow NULL?
70	BTG06		decimal	11
71	WRS06	Currency Key	nvarchar	5	Allow NULL?
72	DAT07	Date	nvarchar	8	Allow NULL?
73	TYP07		char	1	Allow NULL?
74	BTG07		decimal	11
75	WRS07	Currency Key	nvarchar	5	Allow NULL?
76	DAT08	Date	nvarchar	8	Allow NULL?
77	TYP08		char	1	Allow NULL?
78	BTG08		decimal	11
79	WRS08	Currency Key	nvarchar	5	Allow NULL?
80	DAT09	Date	nvarchar	8	Allow NULL?
81	TYP09		char	1	Allow NULL?
82	BTG09		decimal	11
83	WRS09	Currency Key	nvarchar	5	Allow NULL?
84	DAT10	Date	nvarchar	8	Allow NULL?
85	TYP10		char	1	Allow NULL?
86	BTG10		decimal	11
87	WRS10	Currency Key	nvarchar	5	Allow NULL?
88	DAT11	Date	nvarchar	8	Allow NULL?
89	TYP11		char	1	Allow NULL?
90	BTG11		decimal	11
91	WRS11	Currency Key	nvarchar	5	Allow NULL?
92	DAT12	Date	nvarchar	8	Allow NULL?
93	TYP12		char	1	Allow NULL?
94	BTG12		decimal	11
95	WRS12	Currency Key	nvarchar	5	Allow NULL?
96	DAT13	Date	nvarchar	8	Allow NULL?
97	TYP13		char	1	Allow NULL?
98	BTG13		decimal	11
99	WRS13	Currency Key	nvarchar	5	Allow NULL?
100	DAT14	Date	nvarchar	8	Allow NULL?
101	TYP14		char	1	Allow NULL?
102	BTG14		decimal	11
103	WRS14	Currency Key	nvarchar	5	Allow NULL?
104	DAT15	Date	nvarchar	8	Allow NULL?
105	TYP15		char	1	Allow NULL?
106	BTG15		decimal	11
107	WRS15	Currency Key	nvarchar	5	Allow NULL?
108	DAT16	Date	nvarchar	8	Allow NULL?
109	TYP16		char	1	Allow NULL?
110	BTG16		decimal	11
111	WRS16	Currency Key	nvarchar	5	Allow NULL?
112	DAT17	Date	nvarchar	8	Allow NULL?
113	TYP17		char	1	Allow NULL?
114	BTG17		decimal	11
115	WRS17	Currency Key	nvarchar	5	Allow NULL?
116	DAT18	Date	nvarchar	8	Allow NULL?
117	TYP18		char	1	Allow NULL?
118	BTG18		decimal	11
119	WRS18	Currency Key	nvarchar	5	Allow NULL?
120	DAT19	Date	nvarchar	8	Allow NULL?
121	TYP19		char	1	Allow NULL?
122	BTG19		decimal	11
123	WRS19	Currency Key	nvarchar	5	Allow NULL?
124	DAT20	Date	nvarchar	8	Allow NULL?
125	TYP20		char	1	Allow NULL?
126	BTG20		decimal	11
127	WRS20	Currency Key	nvarchar	5	Allow NULL?
128	DAT21	Date	nvarchar	8	Allow NULL?
129	TYP21		char	1	Allow NULL?
130	BTG21		decimal	11
131	WRS21	Currency Key	nvarchar	5	Allow NULL?
132	DAT22	Date	nvarchar	8	Allow NULL?
133	TYP22		char	1	Allow NULL?
134	BTG22		decimal	11
135	WRS22	Currency Key	nvarchar	5	Allow NULL?
136	DAT23	Date	nvarchar	8	Allow NULL?
137	TYP23		char	1	Allow NULL?
138	BTG23		decimal	11
139	WRS23	Currency Key	nvarchar	5	Allow NULL?
140	DAT24	Date	nvarchar	8	Allow NULL?
141	TYP24		char	1	Allow NULL?
142	BTG24		decimal	11
143	WRS24	Currency Key	nvarchar	5	Allow NULL?
144	DAT25	Date	nvarchar	8	Allow NULL?
145	TYP25		char	1	Allow NULL?
146	BTG25		decimal	11
147	WRS25	Currency Key	nvarchar	5	Allow NULL?
148	DAT26	Date	nvarchar	8	Allow NULL?
149	TYP26		char	1	Allow NULL?
150	BTG26		decimal	11
151	WRS26	Currency Key	nvarchar	5	Allow NULL?
152	DAT27	Date	nvarchar	8	Allow NULL?
153	TYP27		char	1	Allow NULL?
154	BTG27		decimal	11
155	WRS27	Currency Key	nvarchar	5	Allow NULL?
156	DAT28	Date	nvarchar	8	Allow NULL?
157	TYP28		char	1	Allow NULL?
158	BTG28		decimal	11
159	WRS28	Currency Key	nvarchar	5	Allow NULL?
160	DAT29	Date	nvarchar	8	Allow NULL?
161	TYP29		char	1	Allow NULL?
162	BTG29		decimal	11
163	WRS29	Currency Key	nvarchar	5	Allow NULL?
164	DAT30	Date	nvarchar	8	Allow NULL?
165	TYP30		char	1	Allow NULL?
166	BTG30		decimal	11
167	WRS30	Currency Key	nvarchar	5	Allow NULL?
168	DAT31	Date	nvarchar	8	Allow NULL?
169	TYP31		char	1	Allow NULL?
170	BTG31		decimal	11
171	WRS31	Currency Key	nvarchar	5	Allow NULL?
172	DAT32	Date	nvarchar	8	Allow NULL?
173	TYP32		char	1	Allow NULL?
174	BTG32		decimal	11
175	WRS32	Currency Key	nvarchar	5	Allow NULL?
176	DAT33	Date	nvarchar	8	Allow NULL?
177	TYP33		char	1	Allow NULL?
178	BTG33		decimal	11
179	WRS33	Currency Key	nvarchar	5	Allow NULL?
180	DAT34	Date	nvarchar	8	Allow NULL?
181	TYP34		char	1	Allow NULL?
182	BTG34		decimal	11
183	WRS34	Currency Key	nvarchar	5	Allow NULL?
184	DAT35	Date	nvarchar	8	Allow NULL?
185	TYP35		char	1	Allow NULL?
186	BTG35		decimal	11
187	WRS35	Currency Key	nvarchar	5	Allow NULL?
188	DAT36	Date	nvarchar	8	Allow NULL?
189	TYP36		char	1	Allow NULL?
190	BTG36		decimal	11
191	WRS36	Currency Key	nvarchar	5	Allow NULL?
192	DAT37	Date	nvarchar	8	Allow NULL?
193	TYP37		char	1	Allow NULL?
194	BTG37		decimal	11
195	WRS37	Currency Key	nvarchar	5	Allow NULL?
196	DAT38	Date	nvarchar	8	Allow NULL?
197	TYP38		char	1	Allow NULL?
198	BTG38		decimal	11
199	WRS38	Currency Key	nvarchar	5	Allow NULL?
200	DAT39	Date	nvarchar	8	Allow NULL?
201	TYP39		char	1	Allow NULL?
202	BTG39		decimal	11
203	WRS39	Currency Key	nvarchar	5	Allow NULL?
204	DAT40	Date	nvarchar	8	Allow NULL?
205	TYP40		char	1	Allow NULL?
206	BTG40		decimal	11
207	WRS40	Currency Key	nvarchar	5	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

207 COLUMNS | 1 INDEXES | ERP 6.0 | PA3350 TABLE

TOPERP 6.0 | PA3350 COLUMNS

TOPERP 6.0 | PA3350 INDEXES

TOP ERP 6.0 | PA3350 COLUMNS

TOP ERP 6.0 | PA3350 INDEXES