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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
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	SQL Create Statement
1	REQUEST	Request number for the data transfer	nvarchar	30	Allow NULL?
2	DATAPAKID	Data packet number	nvarchar	6	Allow NULL?
3	PARTNO	Partition value for PSA table	int	10	Allow NULL?
4	RECORD	Data record number	int	10	Allow NULL?
5	BUKRS		nvarchar	4	Allow NULL?
6	FISCPER		nvarchar	7	Allow NULL?
7	BELNR		nvarchar	10	Allow NULL?
8	BUZEI		nvarchar	3	Allow NULL?
9	UPOSZ		nvarchar	4	Allow NULL?
10	STATUSPS		char	1	Allow NULL?
11	LIFNR		nvarchar	10	Allow NULL?
12	KKBER		nvarchar	4	Allow NULL?
13	MABER		nvarchar	2	Allow NULL?
14	KOART		char	1	Allow NULL?
15	UMSKZ		char	1	Allow NULL?
16	BLART		nvarchar	2	Allow NULL?
17	BSCHL		nvarchar	2	Allow NULL?
18	FISCVAR		nvarchar	2	Allow NULL?
19	BLDAT		nvarchar	8	Allow NULL?
20	BUDAT		nvarchar	8	Allow NULL?
21	CPUDT		nvarchar	8	Allow NULL?
22	AUGDT		nvarchar	8	Allow NULL?
23	MADAT		nvarchar	8	Allow NULL?
24	NETDT		nvarchar	8	Allow NULL?
25	SK1DT		nvarchar	8	Allow NULL?
26	SK2DT		nvarchar	8	Allow NULL?
27	ZFBDT		nvarchar	8	Allow NULL?
28	ZBD1T		decimal	3
29	ZBD2T		decimal	3
30	ZBD3T		decimal	3
31	ZBD1P		decimal	5
32	ZBD2P		decimal	5
33	LAND1		nvarchar	3	Allow NULL?
34	ZLSCH		char	1	Allow NULL?
35	ZTERM		nvarchar	4	Allow NULL?
36	ZLSPR		char	1	Allow NULL?
37	RSTGR		nvarchar	3	Allow NULL?
38	MANSP		char	1	Allow NULL?
39	MSCHL		char	1	Allow NULL?
40	MANST		char	1	Allow NULL?
41	LCURR		nvarchar	5	Allow NULL?
42	DMSOL		decimal	13
43	DMHAB		decimal	13
44	DMSHB		decimal	13
45	SKNTO		decimal	13
46	WAERS		nvarchar	5	Allow NULL?
47	WRSOL		decimal	13
48	WRHAB		decimal	13
49	WRSHB		decimal	13
50	SKFBT		decimal	13
51	WSKTO		decimal	13
52	KTOPL		nvarchar	4	Allow NULL?
53	HKONT		nvarchar	10	Allow NULL?
54	SAKNR		nvarchar	10	Allow NULL?
55	FILKD		nvarchar	10	Allow NULL?
56	AUGBL		nvarchar	10	Allow NULL?
57	XBLNR		nvarchar	16	Allow NULL?
58	REBZG		nvarchar	10	Allow NULL?
59	REBZJ		nvarchar	4	Allow NULL?
60	REBZZ		nvarchar	3	Allow NULL?
61	VBELN		nvarchar	10	Allow NULL?
62	XREF1		nvarchar	12	Allow NULL?
63	XREF2		nvarchar	12	Allow NULL?
64	XREF3		nvarchar	20	Allow NULL?
65	SGTXT		nvarchar	50	Allow NULL?
66	XARCH		char	1	Allow NULL?
67	UMSKS		char	1	Allow NULL?
68	UPDMOD		char	1	Allow NULL?
69	ZUONR		nvarchar	18	Allow NULL?

Name	Primary	Unique	Type	Columns
/BIC/B0000165000KE	No	No	NONCLUSTERED	PARTNO, UPOSZ, BUZEI, BELNR, FISCPER, BUKRS, REQUEST
/BIC/B0000165000~0	Yes	Yes	CLUSTERED	RECORD, PARTNO, DATAPAKID, REQUEST

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

69 COLUMNS | 2 INDEXES | ERP 6.0 | /BIC/B0000165000 TABLE

TOP ERP 6.0 | /BIC/B0000165000 COLUMNS

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

69 COLUMNS | 2 INDEXES | ERP 6.0 | /BIC/B0000165000 TABLE

TOPERP 6.0 | /BIC/B0000165000 COLUMNS

TOPERP 6.0 | /BIC/B0000165000 INDEXES

TOP ERP 6.0 | /BIC/B0000165000 COLUMNS

TOP ERP 6.0 | /BIC/B0000165000 INDEXES