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	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	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	ABSTA		char	1		(' ')	Yes		Allow NULL?
8	POSNR		nvarchar	6		('000000')	Yes		Allow NULL?
9	UVALL		char	1		(' ')	Yes		Allow NULL?
10	UVFAK		char	1		(' ')	Yes		Allow NULL?
11	UVPRS		char	1		(' ')	Yes		Allow NULL?
12	UVVLK		char	1		(' ')	Yes		Allow NULL?
13	BMENG		decimal	13		((0))	Yes
14	CMENG		decimal	13		((0))	Yes
15	EDATU		nvarchar	8		('00000000')	Yes		Allow NULL?
16	ETENR		nvarchar	4		('0000')	Yes		Allow NULL?
17	ETTYP		nvarchar	2		(' ')	Yes		Allow NULL?
18	LDDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
19	LIFSP		nvarchar	2		(' ')	Yes		Allow NULL?
20	LMENG		decimal	13		((0))	Yes
21	MBDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
22	MEINS		nvarchar	3		(' ')	Yes		Allow NULL?
23	TDDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
24	VRKME		nvarchar	3		(' ')	Yes		Allow NULL?
25	WADAT		nvarchar	8		('00000000')	Yes		Allow NULL?
26	WLDATBE		nvarchar	8		('00000000')	Yes		Allow NULL?
27	WMENG		decimal	13		((0))	Yes
28	ANGDT		nvarchar	8		('00000000')	Yes		Allow NULL?
29	AUART		nvarchar	4		(' ')	Yes		Allow NULL?
30	AUGRU		nvarchar	3		(' ')	Yes		Allow NULL?
31	BNDDT		nvarchar	8		('00000000')	Yes		Allow NULL?
32	BUKRS		nvarchar	4		(' ')	Yes		Allow NULL?
33	FAKSK		nvarchar	2		(' ')	Yes		Allow NULL?
34	HWAER		nvarchar	5		(' ')	Yes		Allow NULL?
35	KUNNR		nvarchar	10		(' ')	Yes		Allow NULL?
36	KURST		nvarchar	4		(' ')	Yes		Allow NULL?
37	KVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
38	KVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
39	KVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
40	KVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
41	KVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
42	LIFSK		nvarchar	2		(' ')	Yes		Allow NULL?
43	STWAE		nvarchar	5		(' ')	Yes		Allow NULL?
44	VBTYP		char	1		(' ')	Yes		Allow NULL?
45	VKBUR		nvarchar	4		(' ')	Yes		Allow NULL?
46	VKGRP		nvarchar	3		(' ')	Yes		Allow NULL?
47	VKORG		nvarchar	4		(' ')	Yes		Allow NULL?
48	VTWEG		nvarchar	2		(' ')	Yes		Allow NULL?
49	ABGRU		nvarchar	2		(' ')	Yes		Allow NULL?
50	AEDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
51	AWAHR		nvarchar	3		('000')	Yes		Allow NULL?
52	CHARG		nvarchar	10		(' ')	Yes		Allow NULL?
53	CMKUA		decimal	9		((0))	Yes
54	EAN11		nvarchar	18		(' ')	Yes		Allow NULL?
55	ERDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
56	ERNAM		nvarchar	12		(' ')	Yes		Allow NULL?
57	ERZET		nvarchar	6		('000000')	Yes		Allow NULL?
58	FAKSP		nvarchar	2		(' ')	Yes		Allow NULL?
59	GEWEI		nvarchar	3		(' ')	Yes		Allow NULL?
60	KMEIN		nvarchar	3		(' ')	Yes		Allow NULL?
61	KPEIN		decimal	5		((0))	Yes
62	LGORT		nvarchar	4		(' ')	Yes		Allow NULL?
63	MATKL		nvarchar	9		(' ')	Yes		Allow NULL?
64	MATNR		nvarchar	18		(' ')	Yes		Allow NULL?
65	MATWA		nvarchar	18		(' ')	Yes		Allow NULL?
66	MVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
67	MVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
68	MVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
69	MVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
70	MVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
71	NETPR		decimal	11		((0))	Yes
72	PABLA		nvarchar	25		(' ')	Yes		Allow NULL?
73	PKUNRE		nvarchar	10		(' ')	Yes		Allow NULL?
74	PKUNRG		nvarchar	10		(' ')	Yes		Allow NULL?
75	PKUNWE		nvarchar	10		(' ')	Yes		Allow NULL?
76	PRODH		nvarchar	18		(' ')	Yes		Allow NULL?
77	PSPDNR		nvarchar	10		(' ')	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	ROUTE		nvarchar	6		(' ')	Yes		Allow NULL?
82	SPART		nvarchar	2		(' ')	Yes		Allow NULL?
83	STADAT		nvarchar	8		('00000000')	Yes		Allow NULL?
84	STCUR		decimal	9		((0))	Yes
85	SUGRD		nvarchar	4		(' ')	Yes		Allow NULL?
86	UMVKN		decimal	5		((0))	Yes
87	UMVKZ		decimal	5		((0))	Yes
88	UMZIN		decimal	5		((0))	Yes
89	UMZIZ		decimal	5		((0))	Yes
90	VDATU		nvarchar	8		('00000000')	Yes		Allow NULL?
91	VGTYP		char	1		(' ')	Yes		Allow NULL?
92	VOLEH		nvarchar	3		(' ')	Yes		Allow NULL?
93	VSTEL		nvarchar	4		(' ')	Yes		Allow NULL?
94	WAERK		nvarchar	5		(' ')	Yes		Allow NULL?
95	WERKS		nvarchar	4		(' ')	Yes		Allow NULL?
96	ZIEME		nvarchar	3		(' ')	Yes		Allow NULL?
97	BZIRK		nvarchar	6		(' ')	Yes		Allow NULL?
98	FBUDA		nvarchar	8		('00000000')	Yes		Allow NULL?
99	FKDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
100	INCO1		nvarchar	3		(' ')	Yes		Allow NULL?
101	INCO2		nvarchar	28		(' ')	Yes		Allow NULL?
102	KDGRP		nvarchar	2		(' ')	Yes		Allow NULL?
103	KTGRD		nvarchar	2		(' ')	Yes		Allow NULL?
104	KURSK		decimal	9		((0))	Yes
105	KURSK_DAT		nvarchar	8		('00000000')	Yes		Allow NULL?
106	PRSDT		nvarchar	8		('00000000')	Yes		Allow NULL?
107	WAERK_VBAK		nvarchar	5		(' ')	Yes		Allow NULL?
108	SPARA		nvarchar	2		(' ')	Yes		Allow NULL?
109	VGTYP_AK		char	1		(' ')	Yes		Allow NULL?
110	PS_POSID		nvarchar	24		(' ')	Yes		Allow NULL?
111	PERIV		nvarchar	2		(' ')	Yes		Allow NULL?
112	APOPLANNED		char	1		(' ')	Yes		Allow NULL?
113	FACELOC		nvarchar	20		(' ')	Yes		Allow NULL?
114	FLOCTYPE		nvarchar	4		(' ')	Yes		Allow NULL?
115	EXECLOC		nvarchar	20		(' ')	Yes		Allow NULL?
116	ELOCTYPE		nvarchar	4		(' ')	Yes		Allow NULL?
117	LOGSYS		nvarchar	10		(' ')	Yes		Allow NULL?
118	VWPOS		nvarchar	4		(' ')	Yes		Allow NULL?
119	STOCKLOC		nvarchar	20		(' ')	Yes		Allow NULL?
120	SLOCTYPE		nvarchar	4		(' ')	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

120 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000179000 TABLE

TOP ERP 6.0 | /BIC/B0000179000 COLUMNS

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

120 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000179000 TABLE

TOPERP 6.0 | /BIC/B0000179000 COLUMNS

TOPERP 6.0 | /BIC/B0000179000 INDEXES

TOP ERP 6.0 | /BIC/B0000179000 COLUMNS

TOP ERP 6.0 | /BIC/B0000179000 INDEXES