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

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components :: Document Management System
1	ERP EHP7	6.0	DRAW	41	6	Document Info Record	Document Management System

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	DOKAR	Document Type	nvarchar	3	Allow NULL?
3	DOKNR	Document number	nvarchar	25	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	Allow NULL?
6	DWNAM	Name of person responsible	nvarchar	12	Allow NULL?
7	DOKST	Document Status	nvarchar	2	Allow NULL?
8	LABOR	Laboratory/design office	nvarchar	3	Allow NULL?
9	AENNR	Change Number	nvarchar	12	Allow NULL?
10	WERKA	Plant	nvarchar	4	Allow NULL?
11	LOEDK	Deletion indicator	char	1	Allow NULL?
12	CADKZ	CAD Indicator	char	1	Allow NULL?
13	PRENR	Document number of superior document	nvarchar	25	Allow NULL?
14	PREVR	Document version of superior document	nvarchar	2	Allow NULL?
15	PRETL	Document Part of Superior Document	nvarchar	3	Allow NULL?
16	PREAR	Document type of the superior document	nvarchar	3	Allow NULL?
17	BEGRU	Authorization Group	nvarchar	4	Allow NULL?
18	FILEP	Original of document	nvarchar	255	Allow NULL?
19	DTTRG	Name of Data Carrier	nvarchar	10	Allow NULL?
20	DAPPL	Application	nvarchar	3	Allow NULL?
21	FILEP1	Original of document	nvarchar	255	Allow NULL?
22	DTTRG1	Name of Data Carrier	nvarchar	10	Allow NULL?
23	DAPPL1	Application	nvarchar	3	Allow NULL?
24	VRLDAT	Due Date	nvarchar	8	Allow NULL?
25	VPRIOR	Processing priority	char	1	Allow NULL?
26	RES1	Reserve field DRAW	nvarchar	14	Allow NULL?
27	RES2	Reserve field DRAW	nvarchar	14	Allow NULL?
28	RES3	Reserve field DRAW	nvarchar	14	Allow NULL?
29	RES4	Reserve field DRAW	nvarchar	14	Allow NULL?
30	MRK_FILEP	Original of document	nvarchar	255	Allow NULL?
31	MRK_DTTRG	Name of Data Carrier	nvarchar	10	Allow NULL?
32	MRK_FILEP1	Original of document	nvarchar	255	Allow NULL?
33	MRK_DTTRG1	Name of Data Carrier	nvarchar	10	Allow NULL?
34	ADATUM	Output date for document	nvarchar	8	Allow NULL?
35	DOKNR_VL	Document Number of Source Document	nvarchar	25	Allow NULL?
36	DOKTL_VL	Document part of source document	nvarchar	3	Allow NULL?
37	DOKVR_VL	Document version of source document	nvarchar	2	Allow NULL?
38	FILELEN	File length of original	nvarchar	12	Allow NULL?
39	FILELEN1	File length of original	nvarchar	12	Allow NULL?
40	CM_RELEVANCE	Relevant for Configuration Management	char	1	Allow NULL?
41	CM_FIXED	Document fixed	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
DRAW~0	Yes	Yes	CLUSTERED	DOKTL, DOKVR, DOKNR, DOKAR, MANDT
DRAW~1	No	No	NONCLUSTERED	PRETL, PREAR, PREVR, PRENR, MANDT
DRAW~2	No	No	NONCLUSTERED	BEGRU, MANDT
DRAW~3	No	No	NONCLUSTERED	DWNAM, MANDT
DRAW~4	No	No	NONCLUSTERED	AENNR, MANDT
DRAW~5	No	No	NONCLUSTERED	LABOR, MANDT

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

41 COLUMNS | 6 INDEXES | ERP 6.0 | DRAW TABLE

TOP ERP 6.0 | DRAW COLUMNS

TOP ERP 6.0 | DRAW 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

41 COLUMNS | 6 INDEXES | ERP 6.0 | DRAW TABLE

TOPERP 6.0 | DRAW COLUMNS

TOPERP 6.0 | DRAW INDEXES

TOP ERP 6.0 | DRAW COLUMNS

TOP ERP 6.0 | DRAW INDEXES