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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Sales and Distribution :: Basic Functions
1	ERP EHP7	6.0	VBUK	83	2	Sales Document: Header Status and Administrative Data	Basic Functions

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	VBELN	Sales and Distribution Document Number	nvarchar	10	Allow NULL?
3	RFSTK	Reference document header status	char	1	Allow NULL?
4	RFGSK	Total reference status of all items	char	1	Allow NULL?
5	BESTK	Confirmation status	char	1	Allow NULL?
6	LFSTK	Delivery status	char	1	Allow NULL?
7	LFGSK	Overall delivery status for all items	char	1	Allow NULL?
8	WBSTK	Total goods movement status	char	1	Allow NULL?
9	FKSTK	Billing status	char	1	Allow NULL?
10	FKSAK	Billing status (order-related billing document)	char	1	Allow NULL?
11	BUCHK	Posting Status of Billing Document	char	1	Allow NULL?
12	ABSTK	Overall rejection status of all document items	char	1	Allow NULL?
13	GBSTK	Overall processing status of document	char	1	Allow NULL?
14	KOSTK	Overall picking / putaway status	char	1	Allow NULL?
15	LVSTK	Overall status of warehouse management activities	char	1	Allow NULL?
16	UVALS	Total incompletion status of all items in general	char	1	Allow NULL?
17	UVVLS	Total incompletion status of all items: Delivery	char	1	Allow NULL?
18	UVFAS	Total incompletion status of all items: Billing	char	1	Allow NULL?
19	UVALL	General incompletion status of the header	char	1	Allow NULL?
20	UVVLK	Header incompletion status concerning delivery	char	1	Allow NULL?
21	UVFAK	Header incompletion status with respect to billing	char	1	Allow NULL?
22	UVPRS	Document is incomplete with respect to pricing	char	1	Allow NULL?
23	VBTYP	SD document category	char	1	Allow NULL?
24	VBOBJ	SD document object	char	1	Allow NULL?
25	AEDAT	Changed On	nvarchar	8	Allow NULL?
26	FKIVK	Billing totals status for intercompany billing	char	1	Allow NULL?
27	RELIK	Invoice list status of billing document	char	1	Allow NULL?
28	UVK01	Customer reserves 1: Header status	char	1	Allow NULL?
29	UVK02	Customer reserves 2: Header status	char	1	Allow NULL?
30	UVK03	Customer reserves 3: Header status	char	1	Allow NULL?
31	UVK04	Custmer reserves 4: Header status	char	1	Allow NULL?
32	UVK05	Customer reserves 5: Header status	char	1	Allow NULL?
33	UVS01	Customer reserves 1: Sum of all items	char	1	Allow NULL?
34	UVS02	Customer reserves 2: Sum of all items	char	1	Allow NULL?
35	UVS03	Customer reserves 3: Sum of all items	char	1	Allow NULL?
36	UVS04	Customer reserves 4: Sum of all items	char	1	Allow NULL?
37	UVS05	Customer reserves 5: Sum of all items	char	1	Allow NULL?
38	PKSTK	Overall packing status of all items	char	1	Allow NULL?
39	CMPSA	Status of static credit limit check	char	1	Allow NULL?
40	CMPSB	Status of dynamic credit limit check in the credit horizon	char	1	Allow NULL?
41	CMPSC	Status of credit check against maximum document value	char	1	Allow NULL?
42	CMPSD	Status of credit check against terms of payment	char	1	Allow NULL?
43	CMPSE	Status of credit check against customer review date	char	1	Allow NULL?
44	CMPSF	Status of credit check against open items due	char	1	Allow NULL?
45	CMPSG	Status of credit check against oldest open items	char	1	Allow NULL?
46	CMPSH	Status of credit check against highest dunning level	char	1	Allow NULL?
47	CMPSI	Status of credit check against financial document	char	1	Allow NULL?
48	CMPSJ	Status of credit check against export credit insurance	char	1	Allow NULL?
49	CMPSK	Status of credit check against payment card authorization	char	1	Allow NULL?
50	CMPSL	Status of credit check of reserves 4	char	1	Allow NULL?
51	CMPS0	Status of credit check for customer reserve 1	char	1	Allow NULL?
52	CMPS1	Status of credit check for customer reserve 2	char	1	Allow NULL?
53	CMPS2	Status of credit check for customer reserve 3	char	1	Allow NULL?
54	CMGST	Overall status of credit checks	char	1	Allow NULL?
55	TRSTA	Transportation planning status	char	1	Allow NULL?
56	KOQUK	Status of pick confirmation	char	1	Allow NULL?
57	COSTA	Confirmation status for ALE	char	1	Allow NULL?
58	SAPRL	SAP Release	nvarchar	4	Allow NULL?
59	UVPAS	Totals incomplete status for all items: packaging	char	1	Allow NULL?
60	UVPIS	Totals incomplete status for all items: Picking	char	1	Allow NULL?
61	UVWAS	Total incomplete status of all items: post goods movement	char	1	Allow NULL?
62	UVPAK	Header incomplete status for packaging	char	1	Allow NULL?
63	UVPIK	Header incomplete status for picking/putaway	char	1	Allow NULL?
64	UVWAK	Post header incomplete status for goods movement	char	1	Allow NULL?
65	UVGEK	UNUSED	char	1	Allow NULL?
66	CMPSM	Credit check data is obsolete	char	1	Allow NULL?
67	DCSTK	Delay status	char	1	Allow NULL?
68	VESTK	Handling Unit Placed in Stock	char	1	Allow NULL?
69	VLSTK	Distribution Status (Decentralized Warehouse Processing)	char	1	Allow NULL?
70	RRSTA	Revenue determination status	char	1	Allow NULL?
71	BLOCK	Indicator: Document preselected for archiving	char	1	Allow NULL?
72	FSSTK	Overall billing block status	char	1	Allow NULL?
73	LSSTK	Overall delivery block status	char	1	Allow NULL?
74	SPSTG	Overall blocked status	char	1	Allow NULL?
75	PDSTK	POD status on header level	char	1	Allow NULL?
76	FMSTK	Status Funds Management	char	1	Allow NULL?
77	MANEK	Manual Completion of Contract	char	1	Allow NULL?
78	SPE_TMPID	Temporary inbound delivery	char	1	Allow NULL?
79	HDALL	Inbound delivery header not yet complete (on Hold)	char	1	Allow NULL?
80	HDALS	At least one of ID items not yet complete (on Hold)	char	1	Allow NULL?
81	CMPS_CM	Status of Credit Check SAP Credit Management	char	1	Allow NULL?
82	CMPS_TE	Status of Technical Error SAP Credit Management	char	1	Allow NULL?
83	VBTYP_EXT	Extension of SD Document Category	nvarchar	4	Allow NULL?

Name	Primary	Unique	Type	Columns
VBUK~0	Yes	Yes	CLUSTERED	MANDT, VBELN
VBUK~SPE	No	No	NONCLUSTERED	MANDT, SPSTG

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

83 COLUMNS | 2 INDEXES | ERP 6.0 | VBUK TABLE

TOP ERP 6.0 | VBUK COLUMNS

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

83 COLUMNS | 2 INDEXES | ERP 6.0 | VBUK TABLE

TOPERP 6.0 | VBUK COLUMNS

TOPERP 6.0 | VBUK INDEXES

TOP ERP 6.0 | VBUK COLUMNS

TOP ERP 6.0 | VBUK INDEXES