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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

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	POSNR		nvarchar	6		('000000')	Yes		Allow NULL?
8	AEDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
9	BUKRS		nvarchar	4		(' ')	Yes		Allow NULL?
10	BZIRK		nvarchar	6		(' ')	Yes		Allow NULL?
11	FKART		nvarchar	4		(' ')	Yes		Allow NULL?
12	FKDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
13	FKTYP		char	1		(' ')	Yes		Allow NULL?
14	HWAER		nvarchar	5		(' ')	Yes		Allow NULL?
15	KDGRP		nvarchar	2		(' ')	Yes		Allow NULL?
16	KUNAG		nvarchar	10		(' ')	Yes		Allow NULL?
17	KUNRG		nvarchar	10		(' ')	Yes		Allow NULL?
18	KURRF		decimal	9		((0))	Yes
19	KURST		nvarchar	4		(' ')	Yes		Allow NULL?
20	STWAE		nvarchar	5		(' ')	Yes		Allow NULL?
21	VBTYP		char	1		(' ')	Yes		Allow NULL?
22	VKORG		nvarchar	4		(' ')	Yes		Allow NULL?
23	VTWEG		nvarchar	2		(' ')	Yes		Allow NULL?
24	WAERK		nvarchar	5		(' ')	Yes		Allow NULL?
25	AKTNR		nvarchar	10		(' ')	Yes		Allow NULL?
26	AUBEL		nvarchar	10		(' ')	Yes		Allow NULL?
27	AUPOS		nvarchar	6		('000000')	Yes		Allow NULL?
28	BONBA		decimal	13		((0))	Yes
29	BONUS		nvarchar	2		(' ')	Yes		Allow NULL?
30	BRGEW		decimal	15		((0))	Yes
31	BRTWR		decimal	15		((0))	Yes
32	BWAPPLNM		nvarchar	30		(' ')	Yes		Allow NULL?
33	BWVORG		nvarchar	3		('000')	Yes		Allow NULL?
34	CHARG		nvarchar	10		(' ')	Yes		Allow NULL?
35	EAN11		nvarchar	18		(' ')	Yes		Allow NULL?
36	ERDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
37	FAREG		char	1		(' ')	Yes		Allow NULL?
38	FBUDA		nvarchar	8		('00000000')	Yes		Allow NULL?
39	FKIMG		decimal	13		((0))	Yes
40	FKLMG		decimal	13		((0))	Yes
41	GEWEI		nvarchar	3		(' ')	Yes		Allow NULL?
42	KNUMA_AG		nvarchar	10		(' ')	Yes		Allow NULL?
43	KOKRS		nvarchar	4		(' ')	Yes		Allow NULL?
44	KOSTL		nvarchar	10		(' ')	Yes		Allow NULL?
45	KURSK		decimal	9		((0))	Yes
46	KURSK_DAT		nvarchar	8		('00000000')	Yes		Allow NULL?
47	KVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
48	KVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
49	KVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
50	KVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
51	KVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
52	KZWI1		decimal	13		((0))	Yes
53	KZWI2		decimal	13		((0))	Yes
54	KZWI3		decimal	13		((0))	Yes
55	KZWI4		decimal	13		((0))	Yes
56	KZWI5		decimal	13		((0))	Yes
57	KZWI6		decimal	13		((0))	Yes
58	LGORT		nvarchar	4		(' ')	Yes		Allow NULL?
59	LMENG		decimal	13		((0))	Yes
60	MATKL		nvarchar	9		(' ')	Yes		Allow NULL?
61	MATNR		nvarchar	18		(' ')	Yes		Allow NULL?
62	MATWA		nvarchar	18		(' ')	Yes		Allow NULL?
63	MEINS		nvarchar	3		(' ')	Yes		Allow NULL?
64	MVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
65	MVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
66	MVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
67	MVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
68	MVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
69	MWSBP		decimal	13		((0))	Yes
70	NETWR		decimal	15		((0))	Yes
71	NTGEW		decimal	15		((0))	Yes
72	PKUNRE		nvarchar	10		(' ')	Yes		Allow NULL?
73	PKUNWE		nvarchar	10		(' ')	Yes		Allow NULL?
74	POSAR		char	1		(' ')	Yes		Allow NULL?
75	PRODH		nvarchar	18		(' ')	Yes		Allow NULL?
76	PROVG		nvarchar	2		(' ')	Yes		Allow NULL?
77	PRSDT		nvarchar	8		('00000000')	Yes		Allow NULL?
78	PSTYV		nvarchar	4		(' ')	Yes		Allow NULL?
79	PVRTNR		nvarchar	8		('00000000')	Yes		Allow NULL?
80	PZPERS		nvarchar	8		('00000000')	Yes		Allow NULL?
81	SKFBP		decimal	13		((0))	Yes
82	SMENG		decimal	13		((0))	Yes
83	SPARA		nvarchar	2		(' ')	Yes		Allow NULL?
84	SPART		nvarchar	2		(' ')	Yes		Allow NULL?
85	STADAT		nvarchar	8		('00000000')	Yes		Allow NULL?
86	STCUR		decimal	9		((0))	Yes
87	UMVKN		decimal	5		((0))	Yes
88	UMVKZ		decimal	5		((0))	Yes
89	VDATU		nvarchar	8		('00000000')	Yes		Allow NULL?
90	VGBEL		nvarchar	10		(' ')	Yes		Allow NULL?
91	VGPOS		nvarchar	6		('000000')	Yes		Allow NULL?
92	VKBUR		nvarchar	4		(' ')	Yes		Allow NULL?
93	VKGRP		nvarchar	3		(' ')	Yes		Allow NULL?
94	VOLEH		nvarchar	3		(' ')	Yes		Allow NULL?
95	VOLUM		decimal	15		((0))	Yes
96	VRKME		nvarchar	3		(' ')	Yes		Allow NULL?
97	VSTEL		nvarchar	4		(' ')	Yes		Allow NULL?
98	WAVWR		decimal	13		((0))	Yes
99	WERKS		nvarchar	4		(' ')	Yes		Allow NULL?
100	PS_POSID		nvarchar	24		(' ')	Yes		Allow NULL?
101	ANZFKPOS		decimal	9		((0))	Yes
102	PERIV		nvarchar	2		(' ')	Yes		Allow NULL?
103	MCEX_APCAMPAIGN		nvarchar	32		(' ')	Yes		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

103 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000185000 TABLE

TOP ERP 6.0 | /BIC/B0000185000 COLUMNS

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

103 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000185000 TABLE

TOPERP 6.0 | /BIC/B0000185000 COLUMNS

TOPERP 6.0 | /BIC/B0000185000 INDEXES

TOP ERP 6.0 | /BIC/B0000185000 COLUMNS

TOP ERP 6.0 | /BIC/B0000185000 INDEXES