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	ROCANCEL		char	1	Allow NULL?
6	BEDAT		nvarchar	8	Allow NULL?
7	BSART		nvarchar	4	Allow NULL?
8	BSTYP		char	1	Allow NULL?
9	BUDAT		nvarchar	8	Allow NULL?
10	EBELN		nvarchar	10	Allow NULL?
11	EKGRP		nvarchar	3	Allow NULL?
12	EKORG		nvarchar	4	Allow NULL?
13	HWAER		nvarchar	5	Allow NULL?
14	KDATB		nvarchar	8	Allow NULL?
15	KDATE		nvarchar	8	Allow NULL?
16	LBLIF		nvarchar	10	Allow NULL?
17	LIFNR		nvarchar	10	Allow NULL?
18	LIFRE		nvarchar	10	Allow NULL?
19	LLIEF		nvarchar	10	Allow NULL?
20	LOGSY		nvarchar	10	Allow NULL?
21	ORGLOGSY		nvarchar	10	Allow NULL?
22	RESWK		nvarchar	4	Allow NULL?
23	STATU		char	1	Allow NULL?
24	SYDAT		nvarchar	8	Allow NULL?
25	WAERS		nvarchar	5	Allow NULL?
26	WKURS		decimal	9
27	AFNAM		nvarchar	12	Allow NULL?
28	AKTNR		nvarchar	10	Allow NULL?
29	BSGRU		nvarchar	3	Allow NULL?
30	BWAPPLNM		nvarchar	30	Allow NULL?
31	BWVORG		nvarchar	3	Allow NULL?
32	EBELP		nvarchar	5	Allow NULL?
33	ELIKZ		char	1	Allow NULL?
34	EMATN		nvarchar	18	Allow NULL?
35	EREKZ		char	1	Allow NULL?
36	KONNR		nvarchar	10	Allow NULL?
37	KTPNR		nvarchar	5	Allow NULL?
38	LGORT		nvarchar	4	Allow NULL?
39	LMEIN		nvarchar	3	Allow NULL?
40	MATKL		nvarchar	9	Allow NULL?
41	MATNR		nvarchar	18	Allow NULL?
42	MEINS		nvarchar	3	Allow NULL?
43	NETPR		decimal	11
44	PEINH		decimal	5
45	PSTYP		char	1	Allow NULL?
46	RESLO		nvarchar	4	Allow NULL?
47	TXZ01		nvarchar	40	Allow NULL?
48	UMREN		decimal	5
49	UMREZ		decimal	5
50	WEBRE		char	1	Allow NULL?
51	WEPOS		char	1	Allow NULL?
52	WERKS		nvarchar	4	Allow NULL?
53	XERSY		char	1	Allow NULL?
54	BANFN		nvarchar	10	Allow NULL?
55	BNFPO		nvarchar	5	Allow NULL?
56	BWBRTWR		decimal	13
57	BWEFFWR		decimal	15
58	BWGEO		decimal	19
59	BWGEOO		decimal	19
60	BWGVO		decimal	19
61	BWGVP		decimal	19
62	BWKZWI1		decimal	13
63	BWKZWI2		decimal	13
64	BWKZWI3		decimal	13
65	BWKZWI4		decimal	13
66	BWKZWI5		decimal	13
67	BWKZWI6		decimal	13
68	BWMNG		decimal	15
69	BZGWR		decimal	13
70	CHARG		nvarchar	10	Allow NULL?
71	DBWGEO		decimal	19
72	DBWMNG		decimal	15
73	EINDT		nvarchar	8	Allow NULL?
74	ETENR		nvarchar	4	Allow NULL?
75	MAHNZ		decimal	3
76	SLFDT		nvarchar	8	Allow NULL?
77	UZEIT		nvarchar	6	Allow NULL?
78	KEY_ID		nvarchar	16	Allow NULL?
79	OTB_VALUE		decimal	17
80	OTB_CURR		nvarchar	5	Allow NULL?
81	OTB_RES_VALUE		decimal	17
82	OTB_SPEC_VALUE		decimal	17
83	SPR_RSN_PROFILE		nvarchar	4	Allow NULL?
84	BUDG_TYPE		nvarchar	2	Allow NULL?
85	OTB_STATUS		char	1	Allow NULL?
86	OTB_REASON		nvarchar	3	Allow NULL?
87	CHECK_TYPE		char	1	Allow NULL?
88	DL_ID		nvarchar	22	Allow NULL?
89	HANDOVER_DATE		nvarchar	8	Allow NULL?
90	NO_SCEM		char	1	Allow NULL?
91	DNG_DATE		nvarchar	8	Allow NULL?
92	DNG_TIME		nvarchar	6	Allow NULL?
93	CNCL_ANCMNT_DONE		char	1	Allow NULL?
94	ITEM_CAT		nvarchar	2	Allow NULL?
95	REC_TYPE		char	1	Allow NULL?
96	ATTYP		nvarchar	2	Allow NULL?
97	VLFKZ		char	1	Allow NULL?
98	PERIV		nvarchar	2	Allow NULL?
99	SCL_BEDAT		nvarchar	8	Allow NULL?
100	NOSCL		decimal	3
101	PWLIF		nvarchar	10	Allow NULL?
102	PREST		nvarchar	10	Allow NULL?
103	PLIWK		nvarchar	10	Allow NULL?
104	PLIEF		nvarchar	10	Allow NULL?
105	PBEST		nvarchar	10	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

105 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000189000 TABLE

TOP ERP 6.0 | /BIC/B0000189000 COLUMNS

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

105 COLUMNS | 1 INDEXES | ERP 6.0 | /BIC/B0000189000 TABLE

TOPERP 6.0 | /BIC/B0000189000 COLUMNS

TOPERP 6.0 | /BIC/B0000189000 INDEXES

TOP ERP 6.0 | /BIC/B0000189000 COLUMNS

TOP ERP 6.0 | /BIC/B0000189000 INDEXES