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

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	BUKRS		nvarchar	4		(' ')	Yes		Allow NULL?
10	FAKSK		nvarchar	2		(' ')	Yes		Allow NULL?
11	HWAER		nvarchar	5		(' ')	Yes		Allow NULL?
12	KUNNR		nvarchar	10		(' ')	Yes		Allow NULL?
13	KURST		nvarchar	4		(' ')	Yes		Allow NULL?
14	KVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
15	KVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
16	KVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
17	KVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
18	KVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
19	LIFSK		nvarchar	2		(' ')	Yes		Allow NULL?
20	STWAE		nvarchar	5		(' ')	Yes		Allow NULL?
21	VBTYP		char	1		(' ')	Yes		Allow NULL?
22	VKBUR		nvarchar	4		(' ')	Yes		Allow NULL?
23	VKGRP		nvarchar	3		(' ')	Yes		Allow NULL?
24	VKORG		nvarchar	4		(' ')	Yes		Allow NULL?
25	VTWEG		nvarchar	2		(' ')	Yes		Allow NULL?
26	ABGRU		nvarchar	2		(' ')	Yes		Allow NULL?
27	CHARG		nvarchar	10		(' ')	Yes		Allow NULL?
28	EAN11		nvarchar	18		(' ')	Yes		Allow NULL?
29	ERDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
30	FAKSP		nvarchar	2		(' ')	Yes		Allow NULL?
31	MATKL		nvarchar	9		(' ')	Yes		Allow NULL?
32	MATNR		nvarchar	18		(' ')	Yes		Allow NULL?
33	MATWA		nvarchar	18		(' ')	Yes		Allow NULL?
34	MEINS		nvarchar	3		(' ')	Yes		Allow NULL?
35	MVGR1		nvarchar	3		(' ')	Yes		Allow NULL?
36	MVGR2		nvarchar	3		(' ')	Yes		Allow NULL?
37	MVGR3		nvarchar	3		(' ')	Yes		Allow NULL?
38	MVGR4		nvarchar	3		(' ')	Yes		Allow NULL?
39	MVGR5		nvarchar	3		(' ')	Yes		Allow NULL?
40	OAUME		decimal	15		((0))	Yes
41	OAUWE		decimal	19		((0))	Yes
42	PKUNRE		nvarchar	10		(' ')	Yes		Allow NULL?
43	PKUNRG		nvarchar	10		(' ')	Yes		Allow NULL?
44	PKUNWE		nvarchar	10		(' ')	Yes		Allow NULL?
45	PRODH		nvarchar	18		(' ')	Yes		Allow NULL?
46	PSPDNR		nvarchar	10		(' ')	Yes		Allow NULL?
47	PVRTNR		nvarchar	8		('00000000')	Yes		Allow NULL?
48	PZPERS		nvarchar	8		('00000000')	Yes		Allow NULL?
49	ROUTE		nvarchar	6		(' ')	Yes		Allow NULL?
50	SHKZG		char	1		(' ')	Yes		Allow NULL?
51	SPART		nvarchar	2		(' ')	Yes		Allow NULL?
52	STADAT		nvarchar	8		('00000000')	Yes		Allow NULL?
53	STCUR		decimal	9		((0))	Yes
54	UMVKN		decimal	5		((0))	Yes
55	UMVKZ		decimal	5		((0))	Yes
56	VOLEH		nvarchar	3		(' ')	Yes		Allow NULL?
57	VRKME		nvarchar	3		(' ')	Yes		Allow NULL?
58	VSTEL		nvarchar	4		(' ')	Yes		Allow NULL?
59	WAERK		nvarchar	5		(' ')	Yes		Allow NULL?
60	WERKS		nvarchar	4		(' ')	Yes		Allow NULL?
61	BZIRK		nvarchar	6		(' ')	Yes		Allow NULL?
62	INCO1		nvarchar	3		(' ')	Yes		Allow NULL?
63	INCO2		nvarchar	28		(' ')	Yes		Allow NULL?
64	KDGRP		nvarchar	2		(' ')	Yes		Allow NULL?
65	KURSK		decimal	9		((0))	Yes
66	KURSK_DAT		nvarchar	8		('00000000')	Yes		Allow NULL?
67	WAKTION		nvarchar	10		(' ')	Yes		Allow NULL?
68	SPARA		nvarchar	2		(' ')	Yes		Allow NULL?
69	PS_POSID		nvarchar	24		(' ')	Yes		Allow NULL?
70	ANZOAUPO		decimal	9		((0))	Yes
71	LFIMG_AVME		decimal	13		((0))	Yes
72	MCBW_LFWRT		decimal	19		((0))	Yes
73	MCBW_NETPR_AVKM		decimal	11		((0))	Yes
74	PERIV		nvarchar	2		(' ')	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

74 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000177000 TABLE

TOP ERP 6.0 | /BIC/B0000177000 COLUMNS

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

74 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000177000 TABLE

TOPERP 6.0 | /BIC/B0000177000 COLUMNS

TOPERP 6.0 | /BIC/B0000177000 INDEXES

TOP ERP 6.0 | /BIC/B0000177000 COLUMNS

TOP ERP 6.0 | /BIC/B0000177000 INDEXES