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	BEDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
7	BSART		nvarchar	4		(' ')	Yes		Allow NULL?
8	BSTYP		char	1		(' ')	Yes		Allow NULL?
9	BUDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
10	EBELN		nvarchar	10		(' ')	Yes		Allow NULL?
11	EKGRP		nvarchar	3		(' ')	Yes		Allow NULL?
12	EKORG		nvarchar	4		(' ')	Yes		Allow NULL?
13	HWAER		nvarchar	5		(' ')	Yes		Allow NULL?
14	KDATB		nvarchar	8		('00000000')	Yes		Allow NULL?
15	KDATE		nvarchar	8		('00000000')	Yes		Allow NULL?
16	LBLIF		nvarchar	10		(' ')	Yes		Allow NULL?
17	LIFNR		nvarchar	10		(' ')	Yes		Allow NULL?
18	LIFRE		nvarchar	10		(' ')	Yes		Allow NULL?
19	LLIEF		nvarchar	10		(' ')	Yes		Allow NULL?
20	LOGSY		nvarchar	10		(' ')	Yes		Allow NULL?
21	ORGLOGSY		nvarchar	10		(' ')	Yes		Allow NULL?
22	RESWK		nvarchar	4		(' ')	Yes		Allow NULL?
23	STATU		char	1		(' ')	Yes		Allow NULL?
24	SYDAT		nvarchar	8		('00000000')	Yes		Allow NULL?
25	WAERS		nvarchar	5		(' ')	Yes		Allow NULL?
26	WKURS		decimal	9		((0))	Yes
27	AFNAM		nvarchar	12		(' ')	Yes		Allow NULL?
28	AKTNR		nvarchar	10		(' ')	Yes		Allow NULL?
29	AKTWE		decimal	13		((0))	Yes
30	ALIEF		decimal	9		((0))	Yes
31	BSGRU		nvarchar	3		(' ')	Yes		Allow NULL?
32	BWAPPLNM		nvarchar	30		(' ')	Yes		Allow NULL?
33	BWVORG		nvarchar	3		('000')	Yes		Allow NULL?
34	EBELP		nvarchar	5		('00000')	Yes		Allow NULL?
35	ELIKZ		char	1		(' ')	Yes		Allow NULL?
36	EMATN		nvarchar	18		(' ')	Yes		Allow NULL?
37	EREKZ		char	1		(' ')	Yes		Allow NULL?
38	KONNR		nvarchar	10		(' ')	Yes		Allow NULL?
39	KTMNG		decimal	13		((0))	Yes
40	KTPNR		nvarchar	5		('00000')	Yes		Allow NULL?
41	KZMAB		char	1		(' ')	Yes		Allow NULL?
42	KZPOS		char	1		(' ')	Yes		Allow NULL?
43	KZTAB		char	1		(' ')	Yes		Allow NULL?
44	LAVI		decimal	3		((0))	Yes
45	LFZTA		decimal	13		((0))	Yes
46	LGORT		nvarchar	4		(' ')	Yes		Allow NULL?
47	LMEIN		nvarchar	3		(' ')	Yes		Allow NULL?
48	MABW		decimal	6		((0))	Yes
49	MATKL		nvarchar	9		(' ')	Yes		Allow NULL?
50	MATNR		nvarchar	18		(' ')	Yes		Allow NULL?
51	MEINS		nvarchar	3		(' ')	Yes		Allow NULL?
52	MENGE		decimal	13		((0))	Yes
53	NETPR		decimal	11		((0))	Yes
54	NETWR		decimal	13		((0))	Yes
55	PEINH		decimal	5		((0))	Yes
56	PSTYP		char	1		(' ')	Yes		Allow NULL?
57	PWEV		decimal	3		((0))	Yes
58	PWFR		decimal	3		((0))	Yes
59	PWMT		decimal	3		((0))	Yes
60	PWTT		decimal	3		((0))	Yes
61	PWWE		decimal	3		((0))	Yes
62	REPOS		char	1		(' ')	Yes		Allow NULL?
63	TABW		decimal	3		((0))	Yes
64	TXZ01		nvarchar	40		(' ')	Yes		Allow NULL?
65	UMREN		decimal	5		((0))	Yes
66	UMREZ		decimal	5		((0))	Yes
67	WEBRE		char	1		(' ')	Yes		Allow NULL?
68	WEPOS		char	1		(' ')	Yes		Allow NULL?
69	WERKS		nvarchar	4		(' ')	Yes		Allow NULL?
70	XERSY		char	1		(' ')	Yes		Allow NULL?
71	ZWERT		decimal	13		((0))	Yes
72	PERIV		nvarchar	2		(' ')	Yes		Allow NULL?
73	QUAN_INT		decimal	3		((0))	Yes
74	TIME_INT		decimal	3		((0))	Yes
75	NOTIME		decimal	3		((0))	Yes
76	NOQUAN		decimal	3		((0))	Yes
77	NOPOS		decimal	3		((0))	Yes
78	PWLIF		nvarchar	10		(' ')	Yes		Allow NULL?
79	PREST		nvarchar	10		(' ')	Yes		Allow NULL?
80	PLIWK		nvarchar	10		(' ')	Yes		Allow NULL?
81	PLIEF		nvarchar	10		(' ')	Yes		Allow NULL?
82	PBEST		nvarchar	10		(' ')	Yes		Allow NULL?
83	MGABW		decimal	3		((0))	Yes
84	LFABW		decimal	3		((0))	Yes
85	MAXBW		decimal	3		((0))	Yes
86	VVABW		decimal	3		((0))	Yes
87	UZEIT		nvarchar	6		('000000')	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

87 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000187000 TABLE

TOP ERP 6.0 | /BIC/B0000187000 COLUMNS

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

87 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000187000 TABLE

TOPERP 6.0 | /BIC/B0000187000 COLUMNS

TOPERP 6.0 | /BIC/B0000187000 INDEXES

TOP ERP 6.0 | /BIC/B0000187000 COLUMNS

TOP ERP 6.0 | /BIC/B0000187000 INDEXES