SAP table VBUK (Sales Document: Header Status and Administrative Data)

SAP table VBUK has 2 primary key fields being MANDT,VBELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
RFSTK Reference Status (All Items) CHAR 1 0 RFSTK
RFGSK Overall Reference Status (All Items) CHAR 1 0 RFGSK
BESTK Delivery Confirmation Status (All Items) CHAR 1 0 BESTK
LFSTK Delivery Status (All Items) CHAR 1 0 LFSTK
LFGSK Overall Delivery Status (All Items) CHAR 1 0 LKGSK
WBSTK Goods Movement Status (All Items) CHAR 1 0 WBSTK
FKSTK Delivery-Related Billing Status (All Items) CHAR 1 0 FKSTK
FKSAK Order-Related Billing Status (All Items) CHAR 1 0 FKSAK
BUCHK Posting Status of Billing Document CHAR 1 0 BUCHK
ABSTK Rejection Status (All Items) CHAR 1 0 ABSTK
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
KOSTK Picking Status/Putaway Status (All Items) CHAR 1 0 KOSTK
LVSTK Status of Warehouse Management Activities (All Items) CHAR 1 0 LVSTK
UVALS Incompletion Status (All Items) CHAR 1 0 UVALL_SU
UVVLS Delivery Incompletion Status (All Items) CHAR 1 0 UVVLS_SU
UVFAS Billing Incompletion Status (All Items) CHAR 1 0 UVFAK_SU
UVALL Incompletion Status (Header) CHAR 1 0 UVALL_UK
UVVLK Delivery Incompletion Status (Header) CHAR 1 0 UVVLK_UK
UVFAK Billing Incompletion Status (Header) CHAR 1 0 UVFAK_UK
UVPRS Pricing Incompletion Status (All Items) CHAR 1 0 UVPRS_UK
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
VBOBJ SD document object CHAR 1 0 VBOBJ
A Order
B Purchase Order
F Billing Document
K Sales Activities
L Delivery
T Shipment
V Shipping
W Bulk Transportation (only IS-OIL)
X Others
AEDAT Last Changed On DATS 8 0 AEDAT
FKIVK Intercompany Billing Status (All Items) CHAR 1 0 FKIVK
RELIK Invoice list status of billing document CHAR 1 0 RELIK
UVK01 Customer reserves 1: Header status CHAR 1 0 UVK01
UVK02 Customer reserves 2: Header status CHAR 1 0 UVK02
UVK03 Customer reserves 3: Header status CHAR 1 0 UVK03
UVK04 Custmer reserves 4: Header status CHAR 1 0 UVK04
UVK05 Customer reserves 5: Header status CHAR 1 0 UVK05
UVS01 Customer reserves 1: Sum of all items CHAR 1 0 UVS01
UVS02 Customer reserves 2: Sum of all items CHAR 1 0 UVS02
UVS03 Customer reserves 3: Sum of all items CHAR 1 0 UVS03
UVS04 Customer reserves 4: Sum of all items CHAR 1 0 UVS04
UVS05 Customer reserves 5: Sum of all items CHAR 1 0 UVS05
PKSTK Packing Status (All Items) CHAR 1 0 PKSTK
CMPSA Status of static credit limit check CHAR 1 0 CMPSA
CMPSB Status of dynamic credit limit check in the credit horizon CHAR 1 0 CMPSB
CMPSC Status of Credit Check Against Maximum Document Value CHAR 1 0 CMPSC
CMPSD Status of Credit Check Against Terms of Payment CHAR 1 0 CMPSD
CMPSE Status of credit check against customer review date CHAR 1 0 CMPSE
CMPSF Status of credit check against open items due CHAR 1 0 CMPSF
CMPSG Status of credit check against oldest open items CHAR 1 0 CMPSG
CMPSH Status of credit check against highest dunning level CHAR 1 0 CMPSH
CMPSI Status of Credit Check Against Financial Document CHAR 1 0 CMPSI
CMPSJ Status of Credit Check Against Export Credit Insurance CHAR 1 0 CMPSJ
CMPSK Status of Credit Check Against Payment Card Authorization CHAR 1 0 CMPSK
CMPSL Status of credit check of reserves 4 CHAR 1 0 CMPSL
CMPS0 Status of credit check for customer reserve 1 CHAR 1 0 CMPS0
CMPS1 Status of credit check for customer reserve 2 CHAR 1 0 CMPS1
CMPS2 Status of credit check for customer reserve 3 CHAR 1 0 CMPS2
CMGST Overall Status of Credit Checks CHAR 1 0 CMGST
Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
TRSTA Transportation Planning Status (Header) CHAR 1 0 TRSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
KOQUK Status of Pick Confirmation CHAR 1 0 KOQUK
COSTA Purchasing Confirmation Status CHAR 1 0 COSTA_D
SAPRL SAP Release CHAR 4 0 SAPRL
UVPAS Packing Incompletion Status (All Items) CHAR 1 0 UVPAK_SU
UVPIS Picking/Putaway Incompletion Status (All Items) CHAR 1 0 UVPIK_SU
UVWAS Goods Movement Incompletion Status (All Items) CHAR 1 0 UVWAK_SU
UVPAK Packing Incompletion Status (Header) CHAR 1 0 UVPAK_UK
UVPIK Picking/Putaway Incompletion Status (Header) CHAR 1 0 UVPIK_UK
UVWAK Goods Movement Incompletion Status (Header) CHAR 1 0 UVWAK_UK
UVGEK UNUSED CHAR 1 0 UVGEK_UK
CMPSM Credit check data is obsolete CHAR 1 0 CMPSM
DCSTK Delay Status (All Items) CHAR 1 0 DCSTK
VESTK Handling Unit Placed in Stock CHAR 1 0 VESTK
No shipping unit put away in WM for delivery
X At least one shipping unit put away in WM for delivery
VLSTK Distribution Status (Decentralized Warehouse Processing) CHAR 1 0 VLSTK
Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
RRSTA Revenue determination status CHAR 1 0 RR_STATUS
BLOCK Indicator: Document preselected for archiving CHAR 1 0 BLOCK_VB
No document block
A Document has been selected for archiving
FSSTK Billing Block Status (All Items) CHAR 1 0 FSSTK
LSSTK Overall Delivery Block Status (All Items) CHAR 1 0 LSSTK_G
SPSTG Overall Block Status (Header) CHAR 1 0 SPSTG
PDSTK POD Status on Header Level CHAR 1 0 PDSTK
FMSTK Status Funds Management CHAR 1 0 FMSTK
MANEK Manual Completion of Contract CHAR 1 0 MANEK
SPE_TMPID Temporary inbound delivery CHAR 1 0 /SPE/TMPID
Real (non temporary) delivery
1 Temp.ID is waiting for acknowledgement for changing ID
2 Temp.ID is waiting for acknowledgement for deleting ID
3 Temp.ID is waiting for acknowledgement for purging ID
4 Temp.ID is waiting for ackn. to delete caused by redirecting
HDALL Inbound delivery header not yet complete (on Hold) CHAR 1 0 /SPE/INB_HDALL
HDALS At least one of ID items not yet complete (on Hold) CHAR 1 0 /SPE/INB_HDALS
CMPS_CM Status of Credit Check SAP Credit Management CHAR 1 0 CMPS_CM
CMPS_TE Status of Technical Error SAP Credit Management CHAR 1 0 CMPS_TE
VBTYP_EXT Extension of SD Document Category - Obsolete CHAR 4 0 TDD_VBTYP_EXT_OBSOLETE
TOTAL_ARC_STATUS Excise Tax Total ARC Status (on Delivery Header Level) CHAR 1 0 ET_TOTAL_ARC_STATUS
SHP_TOTAL_PCSTA Total Product Marketability Check Status CHAR 1 0 TDD_TOTAL_PCSTA_LE
SHP_TOTAL_DGSTA Total Dangerous Goods Check Status CHAR 1 0 TDD_TOTAL_DGSTA_LE
SHP_TOTAL_SDSSTA Total Safety Data Sheet Check Status CHAR 1 0 TDD_TOTAL_SDSSTA_LE
TM_WHSE_EXEC Warehouse Execution Status CHAR 1 0 LE_TM_WHSE_EXEC
Not Relevant
1 Delivery is blocked for Warehouse Execution
2 Delivery is released for Warehouse Execution
3 Delivery is in Warehouse Processing
4 Delivery is ready for Shipping
ICO_FKIVK Intercompany Billing Status (All Items) CHAR 1 0 ICO_FKIVK
TOTAL_FKIVK Intercompany Billing Status (All Items) CHAR 1 0 TOTAL_FKIVK
TOTAL_DELIV_RELTD_BILLG_STA Delivery-Related Billing Status (All Items) CHAR 1 0 TDD_TOT_DELIV_RELTD_BILLG_STA
SHP_TOTAL_EMCST Embargo Status (All Items) CHAR 1 0 TDD_TOTAL_EMCST
SHP_TOTAL_SLCST Screening Status (All Items) CHAR 1 0 TDD_TOTAL_SLCST
SHP_TOTAL_LCCST Legal Control Status CHAR 1 0 TDD_TOTAL_LCCST
/SAPMP/LBASK DTUC Status CHAR 1 0 /SAPMP/LBASTAT
FSH_AR_STAT_HDR Overall Allocation Status (Sales Document Header) CHAR 1 0 FSH_ARUN_STATUS_HDR

VBUK foreign key relationships

Table Field Check Table Check Field
0 VBUK MANDT T000 Clients MANDT