VBUK SAP (Sales Document: Header Status and Administrative Data) Table details
Dictionary Type: Table
Description: Sales Document: Header Status and Administrative Data
Description: Sales Document: Header Status and Administrative Data
Table field list including key, data, relationships and ABAP select examples
VBUK is a standard SAP Table which is used to store Sales Document: Header Status and Administrative Data data and is available within R/3 SAP systems depending on the version and release level.
The VBUK table consists of various fields, each holding specific information or linking keys about Sales Document: Header Status and Administrative Data data available in SAP. These include VBELN (Sales and Distribution Document Number), RFSTK (Reference document header status), RFGSK (Total reference status of all items), BESTK (Confirmation status).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBUK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
RFSTK | Reference document header status | RFSTK | CHAR | 1 | STATV | ||||
RFGSK | Total reference status of all items | RFGSK | CHAR | 1 | STATV | ||||
BESTK | Confirmation status | BESTK | CHAR | 1 | STATV | ||||
LFSTK | Delivery status | LFSTK | CHAR | 1 | STATV | ||||
LFGSK | Overall delivery status for all items | LKGSK | CHAR | 1 | STATV | ||||
WBSTK | Total goods movement status | WBSTK | CHAR | 1 | STATV | ||||
FKSTK | Billing status | FKSTK | CHAR | 1 | STATV | ||||
FKSAK | Billing status (order-related billing document) | FKSAK | CHAR | 1 | STATV | ||||
BUCHK | Posting Status of Billing Document | BUCHK | CHAR | 1 | STATV | ||||
ABSTK | Overall rejection status of all document items | ABSTK | CHAR | 1 | STATV | ||||
GBSTK | Overall processing status of document | GBSTK | CHAR | 1 | STATV | ||||
KOSTK | Overall picking / putaway status | KOSTK | CHAR | 1 | STATV | ||||
LVSTK | Overall status of warehouse management activities | LVSTK | CHAR | 1 | STATV | ||||
UVALS | Total incompletion status of all items in general | UVALL_SU | CHAR | 1 | STATV | ||||
UVVLS | Total incompletion status of all items: Delivery | UVVLS_SU | CHAR | 1 | STATV | ||||
UVFAS | Total incompletion status of all items: Billing | UVFAK_SU | CHAR | 1 | STATV | ||||
UVALL | General incompletion status of the header | UVALL_UK | CHAR | 1 | STATV | ||||
UVVLK | Header incompletion status concerning delivery | UVVLK_UK | CHAR | 1 | STATV | ||||
UVFAK | Header incompletion status with respect to billing | UVFAK_UK | CHAR | 1 | STATV | ||||
UVPRS | Document is incomplete with respect to pricing | UVPRS_UK | CHAR | 1 | STATV | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
VBOBJ | SD document object | VBOBJ | CHAR | 1 | VBOBJ | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
FKIVK | Billing totals status for intercompany billing | FKIVK | CHAR | 1 | STATV | ||||
RELIK | Invoice list status of billing document | RELIK | CHAR | 1 | STATV | ||||
UVK01 | Customer reserves 1: Header status | UVK01 | CHAR | 1 | STATV | ||||
UVK02 | Customer reserves 2: Header status | UVK02 | CHAR | 1 | STATV | ||||
UVK03 | Customer reserves 3: Header status | UVK03 | CHAR | 1 | STATV | ||||
UVK04 | Custmer reserves 4: Header status | UVK04 | CHAR | 1 | STATV | ||||
UVK05 | Customer reserves 5: Header status | UVK05 | CHAR | 1 | STATV | ||||
UVS01 | Customer reserves 1: Sum of all items | UVS01 | CHAR | 1 | STATV | ||||
UVS02 | Customer reserves 2: Sum of all items | UVS02 | CHAR | 1 | STATV | ||||
UVS03 | Customer reserves 3: Sum of all items | UVS03 | CHAR | 1 | STATV | ||||
UVS04 | Customer reserves 4: Sum of all items | UVS04 | CHAR | 1 | STATV | ||||
UVS05 | Customer reserves 5: Sum of all items | UVS05 | CHAR | 1 | STATV | ||||
PKSTK | Overall packing status of all items | PKSTK | CHAR | 1 | STATV_PKST | ||||
CMPSA | Status of static credit limit check | CMPSA | CHAR | 1 | CMPSZ | ||||
CMPSB | Status of dynamic credit limit check in the credit horizon | CMPSB | CHAR | 1 | CMPSZ | ||||
CMPSC | Status of credit check against maximum document value | CMPSC | CHAR | 1 | CMPSZ | ||||
CMPSD | Status of credit check against terms of payment | CMPSD | CHAR | 1 | CMPSZ | ||||
CMPSE | Status of credit check against customer review date | CMPSE | CHAR | 1 | CMPSZ | ||||
CMPSF | Status of credit check against open items due | CMPSF | CHAR | 1 | CMPSZ | ||||
CMPSG | Status of credit check against oldest open items | CMPSG | CHAR | 1 | CMPSZ | ||||
CMPSH | Status of credit check against highest dunning level | CMPSH | CHAR | 1 | CMPSZ | ||||
CMPSI | Status of credit check against financial document | CMPSI | CHAR | 1 | CMPSZ | ||||
CMPSJ | Status of credit check against export credit insurance | CMPSJ | CHAR | 1 | CMPSZ | ||||
CMPSK | Status of credit check against payment card authorization | CMPSK | CHAR | 1 | CMPSZ | ||||
CMPSL | Status of credit check of reserves 4 | CMPSL | CHAR | 1 | CMPSZ | ||||
CMPS0 | Status of credit check for customer reserve 1 | CMPS0 | CHAR | 1 | CMPSZ | ||||
CMPS1 | Status of credit check for customer reserve 2 | CMPS1 | CHAR | 1 | CMPSZ | ||||
CMPS2 | Status of credit check for customer reserve 3 | CMPS2 | CHAR | 1 | CMPSZ | ||||
CMGST | Overall status of credit checks | CMGST | CHAR | 1 | CMGST | ||||
TRSTA | Transportation planning status | TRSTA | CHAR | 1 | TRSTA | ||||
KOQUK | Status of pick confirmation | KOQUK | CHAR | 1 | STATV | ||||
COSTA | Confirmation status for ALE | COSTA_D | CHAR | 1 | COSTA | ||||
SAPRL | SAP Release | SAPRL | CHAR | 4 | SAPRL | ||||
UVPAS | Totals incomplete status for all items: packaging | UVPAK_SU | CHAR | 1 | STATV | ||||
UVPIS | Totals incomplete status for all items: Picking | UVPIK_SU | CHAR | 1 | STATV | ||||
UVWAS | Total incomplete status of all items: post goods movement | UVWAK_SU | CHAR | 1 | STATV | ||||
UVPAK | Header incomplete status for packaging | UVPAK_UK | CHAR | 1 | STATV | ||||
UVPIK | Header incomplete status for picking/putaway | UVPIK_UK | CHAR | 1 | STATV | ||||
UVWAK | Post header incomplete status for goods movement | UVWAK_UK | CHAR | 1 | STATV | ||||
UVGEK | UNUSED | UVGEK_UK | CHAR | 1 | STATV | ||||
CMPSM | Credit check data is obsolete | CMPSM | CHAR | 1 | CMPSZ | ||||
DCSTK | Delay status | DCSTK | CHAR | 1 | STATV | ||||
VESTK | Handling Unit Placed in Stock | VESTK | CHAR | 1 | VESTK | ||||
VLSTK | Distribution Status (Decentralized Warehouse Processing) | VLSTK | CHAR | 1 | VLSTK | ||||
RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | STATV | ||||
BLOCK | Indicator: Document preselected for archiving | BLOCK_VB | CHAR | 1 | BLOCK_VB | ||||
FSSTK | Overall billing block status | FSSTK | CHAR | 1 | STATV | ||||
LSSTK | Overall delivery block status | LSSTK_G | CHAR | 1 | STATV | ||||
SPSTG | Overall blocked status | SPSTG | CHAR | 1 | STATV | ||||
PDSTK | POD status on header level | PDSTK | CHAR | 1 | STATV | ||||
FMSTK | Status Funds Management | FMSTK | CHAR | 1 | STATV | ||||
MANEK | Manual Completion of Contract | MANEK | CHAR | 1 | MANEK | ||||
SPE_TMPID | Temporary inbound delivery | /SPE/TMPID | CHAR | 1 | /SPE/TMPID | ||||
HDALL | Inbound delivery header not yet complete (on Hold) | /SPE/INB_HDALL | CHAR | 1 | XFELD | ||||
HDALS | At least one of ID items not yet complete (on Hold) | /SPE/INB_HDALS | CHAR | 1 | XFELD | ||||
CMPS_CM | Status of Credit Check SAP Credit Management | CMPS_CM | CHAR | 1 | CMPSZ | ||||
CMPS_TE | Status of Technical Error SAP Credit Management | CMPS_TE | CHAR | 1 | CMPSZ | ||||
VBTYP_EXT | Extension of SD Document Category | TDD_VBTYP_EXT | CHAR | 4 | DOM_VBTYP_EXT | ||||
.INCLU--AP | 0 | ||||||||
/SAPMP/LBASK | DTUC Status | /SAPMP/LBASTAT | CHAR | 1 | STATV | ||||
.INCLU--AP | 0 | ||||||||
PODVWK | POD Seen Flag | ISI_PODVWK | CHAR | 1 | ISI_PODVWK |
Key field | Non-key field |
How do I retrieve data from SAP table VBUK using ABAP code
The following ABAP code Example will allow you to do a basic selection on VBUK to SELECT all data from the tableDATA: WA_VBUK TYPE VBUK.
SELECT SINGLE *
FROM VBUK
INTO CORRESPONDING FIELDS OF WA_VBUK
WHERE...
How to access SAP table VBUK
Within an ECC or HANA version of SAP you can also view further information about VBUK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects