SAP table VBUP (Sales Document: Item Status)

SAP table VBUP has 3 primary key fields being MANDT,VBELN,POSNR.

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
POSNR Item number of the SD document NUMC 6 0 POSNR
RFSTA Reference Status (Item) CHAR 1 0 RFSTA
RFGSA Overall Reference Status (Item) CHAR 1 0 RFGSA
BESTA Delivery Confirmation Status (Item) CHAR 1 0 BESTA
LFSTA Delivery Status (Item) CHAR 1 0 LFSTA
LFGSA Overall Delivery Status (Item) CHAR 1 0 LFGSA
WBSTA Goods Movement Status (Item) CHAR 1 0 WBSTA
FKSTA Delivery-Related Billing Status (Item) CHAR 1 0 FKSTA
FKSAA Order-Related Billing Status (Item) CHAR 1 0 FKSAA
ABSTA Rejection Status (Item) CHAR 1 0 ABSTA_VB
GBSTA Overall Processing Status (Item) CHAR 1 0 GBSTA
KOSTA Picking Status/Putaway Status (Item) CHAR 1 0 KOSTA
LVSTA Status of Warehouse Management Activities (Item) CHAR 1 0 LVSTA
UVALL Incompletion Status (Item) CHAR 1 0 UVALL_UP
UVVLK Delivery Incompletion Status (Item) CHAR 1 0 UVVLK_UP
UVFAK Billing Incompletion Status (Item) CHAR 1 0 UVFAK_UP
UVPRS Pricing Incompletion Status (Item) CHAR 1 0 UVPRS_UP
FKIVP Intercompany Billing Status (Item) CHAR 1 0 FKIVP
UVP01 Customer reserves 1: Item status CHAR 1 0 UVP01
UVP02 Customer reserves 2: Item status CHAR 1 0 UVP02
UVP03 Item reserves 3: Item status CHAR 1 0 UVP03
UVP04 Item reserves 4: Item status CHAR 1 0 UVP04
UVP05 Customer reserves 5: Item status CHAR 1 0 UVP05
PKSTA Packing Status (Item) CHAR 1 0 PKSTA
KOQUA Confirmation Status of Picking/Putaway CHAR 1 0 KOQUA
COSTA Purchasing Confirmation Status CHAR 1 0 COSTA_D
CMPPI Status of Credit Check Against Financial Document CHAR 1 0 CMPSI
CMPPJ Status of Credit Check Against Export Credit Insurance CHAR 1 0 CMPSJ
UVPIK Picking/Putaway Incompletion Status (Item) CHAR 1 0 UVPIP_UP
UVPAK Packing Incompletion Status (Item) CHAR 1 0 UVPAP_UP
UVWAK Goods Movement Incompletion Status (Item) CHAR 1 0 UVWAP_UP
DCSTA Delay Status (Item) CHAR 1 0 DCSTA
RRSTA Revenue determination status CHAR 1 0 RR_STATUS
VLSTP Decentralized whse processing CHAR 1 0 VLSTP
FSSTA Billing Block Status (Item) CHAR 1 0 FSSTA
LSSTA Overall Delivery Block Status (Item) CHAR 1 0 LSSTA
PDSTA POD status on item level CHAR 1 0 PDSTA
MANEK Manual Completion of Contract CHAR 1 0 MANEK
HDALL Inbound Delivery Item Not Yet Complete (on Hold) CHAR 1 0 /SPE/INB_HDALL_ITM
ARC_STATUS Excise Tax ARC Status CHAR 1 0 ET_ARC_STATUS
Not defined
A EMCS relevance to be evaluated
B Not EMCS relevant
C EMCS relevant
D ARC requested
E ARC available
SHP_PCSTA Product Marketability Check Status CHAR 1 0 TDD_PCSTA_LE
SHP_DGSTA Dangerous Goods Check Status CHAR 1 0 TDD_DGSTA_LE
SHP_SDSSTA Safety Data Sheet Check Status CHAR 1 0 TDD_SDSSTA_LE
ICO_FKIVP Intercompany Billing Status (Item) CHAR 1 0 ICO_FKIVP
TOTAL_FKIVP Intercompany Billing Status (Item) CHAR 1 0 TOTAL_FKIVP
DELIV_RELTD_BILLG_STA Delivery-Related Billing Status (Item) CHAR 1 0 TDD_DELIV_RELTD_BILLG_STA
SHP_EMCST Embargo Status (Item) CHAR 1 0 /SAPSLL/EMCST
SHP_SLCST Screening Status (Item) CHAR 1 0 /SAPSLL/SLCST
SHP_LCCST Legal Control Check Status CHAR 1 0 /SAPSLL/LCCST
/SAPMP/LBASP DTUC Status CHAR 1 0 /SAPMP/LBASTAT
FSH_AR_STAT_ITM Allocation Status of a Sales Document Item CHAR 1 0 FSH_ARUN_STATUS_ITM
MILL_VS_VSSTA Status of sales order item CHAR 1 0 MILL_VS_VSSTA
Changeable original
A Partially changeable original
B Changeable version
C Non-changeable version

VBUP foreign key relationships

Table Field Check Table Check Field
0 VBUP MANDT T000 Clients MANDT