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	ANLN1		nvarchar	12		(' ')	Yes		Allow NULL?
6	ANLN2		nvarchar	4		(' ')	Yes		Allow NULL?
7	AUFNR		nvarchar	12		(' ')	Yes		Allow NULL?
8	AUGBL		nvarchar	10		(' ')	Yes		Allow NULL?
9	AUGDT		nvarchar	8		('00000000')	Yes		Allow NULL?
10	BELNR		nvarchar	10		(' ')	Yes		Allow NULL?
11	BLART		nvarchar	2		(' ')	Yes		Allow NULL?
12	BLDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
13	BSCHL		nvarchar	2		(' ')	Yes		Allow NULL?
14	BSTAT		char	1		(' ')	Yes		Allow NULL?
15	BUDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
16	BUKRS		nvarchar	4		(' ')	Yes		Allow NULL?
17	BUZEI		nvarchar	3		('000')	Yes		Allow NULL?
18	DMSHB		decimal	15		((0))	Yes
19	HWAER		nvarchar	5		(' ')	Yes		Allow NULL?
20	HWAE2		nvarchar	5		(' ')	Yes		Allow NULL?
21	HWAE3		nvarchar	5		(' ')	Yes		Allow NULL?
22	EBELN		nvarchar	10		(' ')	Yes		Allow NULL?
23	EBELP		nvarchar	5		('00000')	Yes		Allow NULL?
24	ETEN2		nvarchar	4		('0000')	Yes		Allow NULL?
25	FAEDT		nvarchar	8		('00000000')	Yes		Allow NULL?
26	FILKD		nvarchar	10		(' ')	Yes		Allow NULL?
27	GJAHR		nvarchar	4		('0000')	Yes		Allow NULL?
28	GSBER		nvarchar	4		(' ')	Yes		Allow NULL?
29	KOART		char	1		(' ')	Yes		Allow NULL?
30	KONTO		nvarchar	10		(' ')	Yes		Allow NULL?
31	KOSTL		nvarchar	10		(' ')	Yes		Allow NULL?
32	MABER		nvarchar	2		(' ')	Yes		Allow NULL?
33	MADAT		nvarchar	8		('00000000')	Yes		Allow NULL?
34	MANSP		char	1		(' ')	Yes		Allow NULL?
35	MANST		char	1		('0')	Yes		Allow NULL?
36	MONAT		nvarchar	2		('00')	Yes		Allow NULL?
37	MSCHL		char	1		(' ')	Yes		Allow NULL?
38	MWSKZ		nvarchar	2		(' ')	Yes		Allow NULL?
39	POSN2		nvarchar	6		('000000')	Yes		Allow NULL?
40	PRCTR		nvarchar	10		(' ')	Yes		Allow NULL?
41	QBSHB		decimal	15		((0))	Yes
42	QSFBT		decimal	15		((0))	Yes
43	QSSHB		decimal	15		((0))	Yes
44	REBZG		nvarchar	10		(' ')	Yes		Allow NULL?
45	SGTXT		nvarchar	50		(' ')	Yes		Allow NULL?
46	SKFBT		decimal	15		((0))	Yes
47	WSKTO		decimal	15		((0))	Yes
48	SKNTO		decimal	15		((0))	Yes
49	STAKZ		char	1		(' ')	Yes		Allow NULL?
50	UMSKS		char	1		(' ')	Yes		Allow NULL?
51	UMSKZ		char	1		(' ')	Yes		Allow NULL?
52	UZAWE		nvarchar	2		(' ')	Yes		Allow NULL?
53	VALUT		nvarchar	8		('00000000')	Yes		Allow NULL?
54	VBEL2		nvarchar	10		(' ')	Yes		Allow NULL?
55	VBELN		nvarchar	10		(' ')	Yes		Allow NULL?
56	VBEWA		nvarchar	4		(' ')	Yes		Allow NULL?
57	VBUND		nvarchar	6		(' ')	Yes		Allow NULL?
58	VERTN		nvarchar	13		(' ')	Yes		Allow NULL?
59	VERTT		char	1		(' ')	Yes		Allow NULL?
60	WERKS		nvarchar	4		(' ')	Yes		Allow NULL?
61	WRSHB		decimal	15		((0))	Yes
62	WAERS		nvarchar	5		(' ')	Yes		Allow NULL?
63	WVERW		char	1		(' ')	Yes		Allow NULL?
64	XBLNR		nvarchar	16		(' ')	Yes		Allow NULL?
65	ZALDT		nvarchar	8		('00000000')	Yes		Allow NULL?
66	ZBD1P		decimal	5		((0))	Yes
67	ZBD1T		decimal	3		((0))	Yes
68	ZBD2P		decimal	5		((0))	Yes
69	ZBD2T		decimal	3		((0))	Yes
70	ZBD3T		decimal	3		((0))	Yes
71	ZFBDT		nvarchar	8		('00000000')	Yes		Allow NULL?
72	ZLSCH		char	1		(' ')	Yes		Allow NULL?
73	ZLSPR		char	1		(' ')	Yes		Allow NULL?
74	ZTERM		nvarchar	4		(' ')	Yes		Allow NULL?
75	ZUONR		nvarchar	18		(' ')	Yes		Allow NULL?
76	XREF1		nvarchar	12		(' ')	Yes		Allow NULL?
77	XREF2		nvarchar	12		(' ')	Yes		Allow NULL?
78	RSTGR		nvarchar	3		(' ')	Yes		Allow NULL?
79	ASKTO		decimal	15		((0))	Yes
80	HKONT		nvarchar	10		(' ')	Yes		Allow NULL?
81	XNEGP		char	1		(' ')	Yes		Allow NULL?
82	KKBER		nvarchar	4		(' ')	Yes		Allow NULL?
83	XREF3		nvarchar	20		(' ')	Yes		Allow NULL?
84	PROJK		nvarchar	24		(' ')	Yes		Allow NULL?
85	KIDNO		nvarchar	30		(' ')	Yes		Allow NULL?
86	BUPLA		nvarchar	4		(' ')	Yes		Allow NULL?
87	XRAGL		char	1		(' ')	Yes		Allow NULL?
88	CESSION_KZ		nvarchar	2		(' ')	Yes		Allow NULL?
89	BUZID		char	1		(' ')	Yes		Allow NULL?
90	AUGGJ		nvarchar	4		('0000')	Yes		Allow NULL?
91	AWSYS		nvarchar	10		(' ')	Yes		Allow NULL?
92	AWTYP		nvarchar	5		(' ')	Yes		Allow NULL?
93	BEWAR		nvarchar	3		(' ')	Yes		Allow NULL?
94	DMBTR		decimal	15		((0))	Yes
95	DOCNR		nvarchar	10		(' ')	Yes		Allow NULL?
96	DOCLN		nvarchar	6		(' ')	Yes		Allow NULL?
97	FKBER_LONG		nvarchar	16		(' ')	Yes		Allow NULL?
98	GLVOR		nvarchar	4		(' ')	Yes		Allow NULL?
99	KOKRS		nvarchar	4		(' ')	Yes		Allow NULL?
100	KSTAR		nvarchar	10		(' ')	Yes		Allow NULL?
101	KUNNR		nvarchar	10		(' ')	Yes		Allow NULL?
102	LIFNR		nvarchar	10		(' ')	Yes		Allow NULL?
103	MEINS		nvarchar	3		(' ')	Yes		Allow NULL?
104	MENGE		decimal	13		((0))	Yes
105	PARGB		nvarchar	4		(' ')	Yes		Allow NULL?
106	PFKBER		nvarchar	16		(' ')	Yes		Allow NULL?
107	PKOSTL		nvarchar	10		(' ')	Yes		Allow NULL?
108	POPER		nvarchar	3		('000')	Yes		Allow NULL?
109	PPRCT		nvarchar	10		(' ')	Yes		Allow NULL?
110	PSEGMENT		nvarchar	10		(' ')	Yes		Allow NULL?
111	RLDNR		nvarchar	2		(' ')	Yes		Allow NULL?
112	RYEAR		nvarchar	4		('0000')	Yes		Allow NULL?
113	SAKNR		nvarchar	10		(' ')	Yes		Allow NULL?
114	SEGMENT		nvarchar	10		(' ')	Yes		Allow NULL?
115	LDGRP		nvarchar	4		(' ')	Yes		Allow NULL?
116	XLGCLR		char	1		(' ')	Yes		Allow NULL?
117	AWKEY		nvarchar	20		(' ')	Yes		Allow NULL?
118	CPUDT		nvarchar	8		('00000000')	Yes		Allow NULL?
119	UPMOD		char	1		(' ')	Yes		Allow NULL?
120	FISCVAR		nvarchar	2		(' ')	Yes		Allow NULL?
121	RFISCVAR		nvarchar	2		(' ')	Yes		Allow NULL?
122	RFISCPER		nvarchar	7		('0000000')	Yes		Allow NULL?
123	KTOPL		nvarchar	4		(' ')	Yes		Allow NULL?
124	PS_POSID		nvarchar	24		(' ')	Yes		Allow NULL?
125	CURT2		nvarchar	2		(' ')	Yes		Allow NULL?
126	CURT3		nvarchar	2		(' ')	Yes		Allow NULL?
127	DMHAB		decimal	13		((0))	Yes
128	DMHA2		decimal	13		((0))	Yes
129	DMHA3		decimal	13		((0))	Yes
130	DMSOL		decimal	13		((0))	Yes
131	DMSO2		decimal	13		((0))	Yes
132	DMSO3		decimal	13		((0))	Yes
133	DMSH2		decimal	13		((0))	Yes
134	DMSH3		decimal	13		((0))	Yes
135	WRHAB		decimal	13		((0))	Yes
136	WRSOL		decimal	13		((0))	Yes
137	AUGST		char	1		(' ')	Yes		Allow NULL?
138	BSTAT_S		char	1		(' ')	Yes		Allow NULL?
139	BWSHB		decimal	13		((0))	Yes
140	BWSH2		decimal	13		((0))	Yes
141	BWSH3		decimal	13		((0))	Yes
142	USNAM		nvarchar	12		(' ')	Yes		Allow NULL?
143	STBLG		nvarchar	10		(' ')	Yes		Allow NULL?
144	STJAH		nvarchar	4		('0000')	Yes		Allow NULL?
145	BKTXT		nvarchar	25		(' ')	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

145 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000168000 TABLE

TOP ERP 6.0 | /BIC/B0000168000 COLUMNS

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

145 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000168000 TABLE

TOPERP 6.0 | /BIC/B0000168000 COLUMNS

TOPERP 6.0 | /BIC/B0000168000 INDEXES

TOP ERP 6.0 | /BIC/B0000168000 COLUMNS

TOP ERP 6.0 | /BIC/B0000168000 INDEXES