VBUP SAP (Sales Document: Item Status) Table details
Dictionary Type: Table
Description: Sales Document: Item Status
Description: Sales Document: Item Status
Table field list including key, data, relationships and ABAP select examples
VBUP is a standard SAP Table which is used to store Sales Document: Item Status data and is available within R/3 SAP systems depending on the version and release level.
The VBUP table consists of various fields, each holding specific information or linking keys about Sales Document: Item Status data available in SAP. These include VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), RFSTA (Reference status), RFGSA (Overall status of reference).. 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)
SAP VBUP 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 | VBUK | ALPHA | VBELN | AUN | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
| RFSTA | Reference status | RFSTA | CHAR | 1 | STATV | ||||
| RFGSA | Overall status of reference | RFGSA | CHAR | 1 | STATV | ||||
| BESTA | Confirmation Status of Document Item | BESTA | CHAR | 1 | STATV | ||||
| LFSTA | Delivery status | LFSTA | CHAR | 1 | STATV | ||||
| LFGSA | Overall delivery status of the item | LFGSA | CHAR | 1 | STATV | ||||
| WBSTA | Goods movement status | WBSTA | CHAR | 1 | STATV | ||||
| FKSTA | Billing status of delivery-related billing documents | FKSTA | CHAR | 1 | STATV | ||||
| FKSAA | Billing Status for Order-Related Billing Documents | FKSAA | CHAR | 1 | STATV | ||||
| ABSTA | Rejection status for SD item | ABSTA_VB | CHAR | 1 | STATV | ||||
| GBSTA | Overall processing status of the SD document item | GBSTA | CHAR | 1 | STATV | ||||
| KOSTA | Picking status/Putaway status | KOSTA | CHAR | 1 | STATV | ||||
| LVSTA | Status of warehouse management activities | LVSTA | CHAR | 1 | STATV | ||||
| UVALL | General Incompletion Status of Item | UVALL_UP | CHAR | 1 | STATV | ||||
| UVVLK | Incompletion status of the item with regard to delivery | UVVLK_UP | CHAR | 1 | STATV | ||||
| UVFAK | Item Incompletion Status with Respect to Billing | UVFAK_UP | CHAR | 1 | STATV | ||||
| UVPRS | Pricing for item is incomplete | UVPRS_UP | CHAR | 1 | STATV | ||||
| FKIVP | Intercompany Billing Status | FKIVP | CHAR | 1 | STATV | ||||
| UVP01 | Customer reserves 1: Item status | UVP01 | CHAR | 1 | STATV | ||||
| UVP02 | Customer reserves 2: Item status | UVP02 | CHAR | 1 | STATV | ||||
| UVP03 | Item reserves 3: Item status | UVP03 | CHAR | 1 | STATV | ||||
| UVP04 | Item reserves 4: Item status | UVP04 | CHAR | 1 | STATV | ||||
| UVP05 | Customer reserves 5: Item status | UVP05 | CHAR | 1 | STATV | ||||
| PKSTA | Packing status of item | PKSTA | CHAR | 1 | STATV | ||||
| KOQUA | Confirmation status of picking/putaway | KOQUA | CHAR | 1 | STATV | ||||
| COSTA | Confirmation status for ALE | COSTA_D | CHAR | 1 | COSTA | ||||
| CMPPI | Status of credit check against financial document | CMPSI | CHAR | 1 | CMPSZ | ||||
| CMPPJ | Status of credit check against export credit insurance | CMPSJ | CHAR | 1 | CMPSZ | ||||
| UVPIK | Incomplete status of item for picking/putaway | UVPIP_UP | CHAR | 1 | STATV | ||||
| UVPAK | Incomplete status of item for packaging | UVPAP_UP | CHAR | 1 | STATV | ||||
| UVWAK | Incomplete status of item regarding goods issue | UVWAP_UP | CHAR | 1 | STATV | ||||
| DCSTA | Delay status | DCSTA | CHAR | 1 | STATV | ||||
| RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | STATV | ||||
| VLSTP | Decentralized whse processing | VLSTP | CHAR | 1 | STATV | ||||
| FSSTA | Billing block status for items | FSSTA | CHAR | 1 | STATV | ||||
| LSSTA | Delivery block status for item | LSSTA | CHAR | 1 | STATV | ||||
| PDSTA | POD status on item level | PDSTA | CHAR | 1 | STATV | ||||
| MANEK | Manual Completion of Contract | MANEK | CHAR | 1 | MANEK | ||||
| HDALL | Inbound Delivery Item Not Yet Complete (on Hold) | /SPE/INB_HDALL_ITM | CHAR | 1 | XFELD | ||||
| .INCLU--AP | 0 | ||||||||
| BUMP | High tech bump indicator | /SAPHT/SW_BUMP | CHAR | 1 | /SAPHT/SW_BUMP | ||||
| .INCLU--AP | 0 | ||||||||
| LTSPS | Indicator : stockable type switched into standard product | /SAPHT/SW_LTSPS | CHAR | 1 | /SAPHT/SW_LTSPS | ||||
| .INCLU--AP | 0 | ||||||||
| /SAPMP/LBASP | DTUC Status | /SAPMP/LBASTAT | CHAR | 1 | STATV | ||||
| .INCLU--AP | 0 | ||||||||
| MILL_VS_VSSTA | Status of sales order item | MILL_VS_VSSTA | CHAR | 1 | MILL_VS_VSSTA |
| Key field | Non-key field |
How do I retrieve data from SAP table VBUP using ABAP code
The following ABAP code Example will allow you to do a basic selection on VBUP to SELECT all data from the tableDATA: WA_VBUP TYPE VBUP.
SELECT SINGLE *
FROM VBUP
INTO CORRESPONDING FIELDS OF WA_VBUP
WHERE...
How to access SAP table VBUP
Within an ECC or HANA version of SAP you can also view further information about VBUP 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