SAP Table VBUP

Sales Document: Item Status

VBUP (Sales Document: Item Status) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBUP to other SAP tables.

VBUP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
RFSTA Reference status RFSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RFGSA Overall status of reference RFGSA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BESTA Confirmation Status of Document Item BESTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFSTA Delivery status LFSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFGSA Overall delivery status of the item LFGSA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTA Goods movement status WBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSTA Billing status of delivery-related billing documents FKSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSAA Billing Status for Order-Related Billing Documents FKSAA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
ABSTA Rejection status for SD item ABSTA_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
GBSTA Overall processing status of the SD document item GBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOSTA Picking status/Putaway status KOSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LVSTA Status of warehouse management activities LVSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALL General Incompletion Status of Item UVALL_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK Incompletion status of the item with regard to delivery UVVLK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK Item Incompletion Status with Respect to Billing UVFAK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Pricing for item is incomplete UVPRS_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKIVP Intercompany Billing Status FKIVP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP01 Customer reserves 1: Item status UVP01 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP02 Customer reserves 2: Item status UVP02 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP03 Item reserves 3: Item status UVP03 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP04 Item reserves 4: Item status UVP04 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP05 Customer reserves 5: Item status UVP05 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PKSTA Packing status of item PKSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOQUA Confirmation status of picking/putaway KOQUA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
COSTA Confirmation status for ALE COSTA_D CHAR 1 0
NULL Item not relevant for confirmation
A Item not yet confirmed by MM
B Item partially confirmed by MM
C All schedule lines by MM confirmed
CMPPI Status of credit check against financial document CMPSI CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPPJ Status of credit check against export credit insurance CMPSJ CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
UVPIK Incomplete status of item for picking/putaway UVPIP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPAK Incomplete status of item for packaging UVPAP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVWAK Incomplete status of item regarding goods issue UVWAP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
DCSTA Delay status DCSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RRSTA Revenue determination status RR_STATUS CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
VLSTP Decentralized whse processing VLSTP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FSSTA Billing block status for items FSSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LSSTA Delivery block status for item LSSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PDSTA POD status on item level PDSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
MANEK Manual Completion of Contract MANEK CHAR 1 0
HDALL Inbound Delivery Item Not Yet Complete (on Hold) /SPE/INB_HDALL_ITM CHAR 1 0
X Yes
NULL No
LTSPS Indicator : stockable type switched into standard product /SAPHT/SW_LTSPS CHAR 1 0
NULL No switch
3 Switched - configuration changeable; compare TVAP-LTYPA
4 Switched - configuration not changeable; compare TVAP-LTYPA
MILL_VS_VSSTA Status of sales order item MILL_VS_VSSTA CHAR 1 0
NULL Changeable original
A Partially changeable original
B Changeable version
C Non-changeable version
OIFINAL Final Delivery Indicator OID_FINAL CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIINVCST1 Status of invoice cycle 1 OIA_INVCS1 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST2 Status of invoice cycle 2 OIA_INVCS2 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST3 Status of invoice cycle 3 OIA_INVCS3 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST4 Status of invoice cycle 4 OIA_INVCS4 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST5 Status of invoice cycle 5 OIA_INVCS5 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST6 Status of invoice cycle 6 OIA_INVCS6 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST7 Status of invoice cycle 7 OIA_INVCS7 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST8 Status of invoice cycle 8 OIA_INVCS8 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST9 Status of invoice cycle 9 OIA_INVCS9 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced

VBUP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBUP MANDT VBUP MANDT T000 Clients MANDT
VBUP VBELN VBUP MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBUP VBELN VBUP VBELN VBUK Sales Document: Header Status and Administrative Data VBELN