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