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

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	Rollname	SQL Create Statement
1	REQUEST	Request number for the data transfer	nvarchar	30	CHAR	(' ')	No	RSREQUNR	Allow NULL?
2	DATAPAKID	Data packet number	nvarchar	6	NUMC	('000000')	No	RSDATAPID	Allow NULL?
3	PARTNO	Partition value for PSA table	int	10	INT4	((0))	No	RSPARTVAL	Allow NULL?
4	RECORD	Data record number	int	10	INT4	((0))	No	RSARECORD	Allow NULL?
5	ROCANCEL		char	1		(' ')	Yes		Allow NULL?
6	VBELN		nvarchar	10		(' ')	Yes		Allow NULL?
7	ABSTA		char	1		(' ')	Yes		Allow NULL?
8	POSNR		nvarchar	6		('000000')	Yes		Allow NULL?
9	RFGSA		char	1		(' ')	Yes		Allow NULL?
10	RFSTA		char	1		(' ')	Yes		Allow NULL?
11	UVALL		char	1		(' ')	Yes		Allow NULL?
12	UVFAK		char	1		(' ')	Yes		Allow NULL?
13	UVPRS		char	1		(' ')	Yes		Allow NULL?
14	UVVLK		char	1		(' ')	Yes		Allow NULL?
15	ANGDT		nvarchar	8		('00000000')	Yes		Allow NULL?
16	AUART		nvarchar	4		(' ')	Yes		Allow NULL?
17	AUGRU		nvarchar	3		(' ')	Yes		Allow NULL?
18	BNDDT		nvarchar	8		('00000000')	Yes		Allow NULL?
19	BUKRS		nvarchar	4		(' ')	Yes		Allow NULL?
20	FAKSK		nvarchar	2		(' ')	Yes		Allow NULL?
21	HWAER		nvarchar	5		(' ')	Yes		Allow NULL?
22	KUNNR		nvarchar	10		(' ')	Yes		Allow NULL?
23	KURST		nvarchar	4		(' ')	Yes		Allow NULL?
24	KVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
25	KVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
26	KVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
27	KVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
28	KVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
29	LIFSK		nvarchar	2		(' ')	Yes		Allow NULL?
30	STWAE		nvarchar	5		(' ')	Yes		Allow NULL?
31	VBTYP		char	1		(' ')	Yes		Allow NULL?
32	VKBUR		nvarchar	4		(' ')	Yes		Allow NULL?
33	VKGRP		nvarchar	3		(' ')	Yes		Allow NULL?
34	VKORG		nvarchar	4		(' ')	Yes		Allow NULL?
35	VTWEG		nvarchar	2		(' ')	Yes		Allow NULL?
36	ABGRU		nvarchar	2		(' ')	Yes		Allow NULL?
37	AEDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
38	AWAHR		nvarchar	3		('000')	Yes		Allow NULL?
39	BRGEW		decimal	15		((0))	Yes
40	BWAPPLNM		nvarchar	30		(' ')	Yes		Allow NULL?
41	BWVORG		nvarchar	3		('000')	Yes		Allow NULL?
42	CHARG		nvarchar	10		(' ')	Yes		Allow NULL?
43	CMKUA		decimal	9		((0))	Yes
44	EAN11		nvarchar	18		(' ')	Yes		Allow NULL?
45	ERDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
46	ERNAM		nvarchar	12		(' ')	Yes		Allow NULL?
47	ERZET		nvarchar	6		('000000')	Yes		Allow NULL?
48	FAKSP		nvarchar	2		(' ')	Yes		Allow NULL?
49	GEWEI		nvarchar	3		(' ')	Yes		Allow NULL?
50	KBMENG		decimal	15		((0))	Yes
51	KLMENG		decimal	15		((0))	Yes
52	KMEIN		nvarchar	3		(' ')	Yes		Allow NULL?
53	KNUMA_AG		nvarchar	10		(' ')	Yes		Allow NULL?
54	KPEIN		decimal	5		((0))	Yes
55	KWMENG		decimal	15		((0))	Yes
56	KZWI1		decimal	13		((0))	Yes
57	KZWI2		decimal	13		((0))	Yes
58	KZWI3		decimal	13		((0))	Yes
59	KZWI4		decimal	13		((0))	Yes
60	KZWI5		decimal	13		((0))	Yes
61	KZWI6		decimal	13		((0))	Yes
62	LFMNG		decimal	13		((0))	Yes
63	LGORT		nvarchar	4		(' ')	Yes		Allow NULL?
64	LSMENG		decimal	15		((0))	Yes
65	MATKL		nvarchar	9		(' ')	Yes		Allow NULL?
66	MATNR		nvarchar	18		(' ')	Yes		Allow NULL?
67	MATWA		nvarchar	18		(' ')	Yes		Allow NULL?
68	MEINS		nvarchar	3		(' ')	Yes		Allow NULL?
69	MVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
70	MVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
71	MVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
72	MVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
73	MVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
74	MWSBP		decimal	13		((0))	Yes
75	NETPR		decimal	11		((0))	Yes
76	NETWR		decimal	15		((0))	Yes
77	NTGEW		decimal	15		((0))	Yes
78	PABLA		nvarchar	25		(' ')	Yes		Allow NULL?
79	PKUNRE		nvarchar	10		(' ')	Yes		Allow NULL?
80	PKUNRG		nvarchar	10		(' ')	Yes		Allow NULL?
81	PKUNWE		nvarchar	10		(' ')	Yes		Allow NULL?
82	PRODH		nvarchar	18		(' ')	Yes		Allow NULL?
83	PSPDNR		nvarchar	10		(' ')	Yes		Allow NULL?
84	PSTYV		nvarchar	4		(' ')	Yes		Allow NULL?
85	PVRTNR		nvarchar	8		('00000000')	Yes		Allow NULL?
86	PZPERS		nvarchar	8		('00000000')	Yes		Allow NULL?
87	ROOT_DATE		nvarchar	8		('00000000')	Yes		Allow NULL?
88	ROOT_HEAD		nvarchar	10		(' ')	Yes		Allow NULL?
89	ROOT_ITEM		nvarchar	6		('000000')	Yes		Allow NULL?
90	ROUTE		nvarchar	6		(' ')	Yes		Allow NULL?
91	SOBKZ		char	1		(' ')	Yes		Allow NULL?
92	SPART		nvarchar	2		(' ')	Yes		Allow NULL?
93	STADAT		nvarchar	8		('00000000')	Yes		Allow NULL?
94	STCUR		decimal	9		((0))	Yes
95	SUGRD		nvarchar	4		(' ')	Yes		Allow NULL?
96	UEBTK		char	1		(' ')	Yes		Allow NULL?
97	UEBTO		decimal	3		((0))	Yes
98	UMVKN		decimal	5		((0))	Yes
99	UMVKZ		decimal	5		((0))	Yes
100	UMZIN		decimal	5		((0))	Yes
101	UMZIZ		decimal	5		((0))	Yes
102	UNTTO		decimal	3		((0))	Yes
103	VDATU		nvarchar	8		('00000000')	Yes		Allow NULL?
104	VGBEL		nvarchar	10		(' ')	Yes		Allow NULL?
105	VGPOS		nvarchar	6		('000000')	Yes		Allow NULL?
106	VGTYP		char	1		(' ')	Yes		Allow NULL?
107	VOLEH		nvarchar	3		(' ')	Yes		Allow NULL?
108	VOLUM		decimal	15		((0))	Yes
109	VRKME		nvarchar	3		(' ')	Yes		Allow NULL?
110	VSTEL		nvarchar	4		(' ')	Yes		Allow NULL?
111	WAERK		nvarchar	5		(' ')	Yes		Allow NULL?
112	WAVWR		decimal	13		((0))	Yes
113	WERKS		nvarchar	4		(' ')	Yes		Allow NULL?
114	ZIEME		nvarchar	3		(' ')	Yes		Allow NULL?
115	ZMENG		decimal	13		((0))	Yes
116	ZWERT		decimal	13		((0))	Yes
117	BZIRK		nvarchar	6		(' ')	Yes		Allow NULL?
118	FBUDA		nvarchar	8		('00000000')	Yes		Allow NULL?
119	FKDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
120	INCO1		nvarchar	3		(' ')	Yes		Allow NULL?
121	INCO2		nvarchar	28		(' ')	Yes		Allow NULL?
122	KDGRP		nvarchar	2		(' ')	Yes		Allow NULL?
123	KTGRD		nvarchar	2		(' ')	Yes		Allow NULL?
124	KURSK		decimal	9		((0))	Yes
125	KURSK_DAT		nvarchar	8		('00000000')	Yes		Allow NULL?
126	PRSDT		nvarchar	8		('00000000')	Yes		Allow NULL?
127	WAKTION		nvarchar	10		(' ')	Yes		Allow NULL?
128	WMINR		nvarchar	10		(' ')	Yes		Allow NULL?
129	WAERK_VBAK		nvarchar	5		(' ')	Yes		Allow NULL?
130	SPARA		nvarchar	2		(' ')	Yes		Allow NULL?
131	VGTYP_AK		char	1		(' ')	Yes		Allow NULL?
132	PS_POSID		nvarchar	24		(' ')	Yes		Allow NULL?
133	ANZAUPO		decimal	9		((0))	Yes
134	PERIV		nvarchar	2		(' ')	Yes		Allow NULL?
135	MCEX_APCAMPAIGN		nvarchar	32		(' ')	Yes		Allow NULL?
136	APOPLANNED		char	1		(' ')	Yes		Allow NULL?
137	MCBW_NETPR_AVKM		decimal	11		((0))	Yes

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

137 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000178000 TABLE

TOP ERP 6.0 | /BIC/B0000178000 COLUMNS

TOP ERP 6.0 | /BIC/B0000178000 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

137 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000178000 TABLE

TOPERP 6.0 | /BIC/B0000178000 COLUMNS

TOPERP 6.0 | /BIC/B0000178000 INDEXES

TOP ERP 6.0 | /BIC/B0000178000 COLUMNS

TOP ERP 6.0 | /BIC/B0000178000 INDEXES