| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | RFSTA | Reference status | char | 1 | 0 | | | | Allow NULL? |
| 6 | RFGSA | Overall status of reference | char | 1 | 0 | | | | Allow NULL? |
| 7 | BESTA | Confirmation Status of Document Item | char | 1 | 0 | | | | Allow NULL? |
| 8 | LFSTA | Delivery status | char | 1 | 0 | | | | Allow NULL? |
| 9 | LFGSA | Overall delivery status of the item | char | 1 | 0 | | | | Allow NULL? |
| 10 | WBSTA | Goods movement status | char | 1 | 0 | | | | Allow NULL? |
| 11 | FKSTA | Billing status of delivery-related billing documents | char | 1 | 0 | | | | Allow NULL? |
| 12 | FKSAA | Billing Status for Order-Related Billing Documents | char | 1 | 0 | | | | Allow NULL? |
| 13 | ABSTA | Rejection status for SD item | char | 1 | 0 | | | | Allow NULL? |
| 14 | GBSTA | Overall processing status of the SD document item | char | 1 | 0 | | | | Allow NULL? |
| 15 | KOSTA | Picking status/Putaway status | char | 1 | 0 | | | | Allow NULL? |
| 16 | LVSTA | Status of warehouse management activities | char | 1 | 0 | | | | Allow NULL? |
| 17 | UVALL | General Incompletion Status of Item | char | 1 | 0 | | | | Allow NULL? |
| 18 | UVVLK | Incompletion status of the item with regard to delivery | char | 1 | 0 | | | | Allow NULL? |
| 19 | UVFAK | Item Incompletion Status with Respect to Billing | char | 1 | 0 | | | | Allow NULL? |
| 20 | UVPRS | Pricing for item is incomplete | char | 1 | 0 | | | | Allow NULL? |
| 21 | FKIVP | Intercompany Billing Status | char | 1 | 0 | | | | Allow NULL? |
| 22 | UVP01 | Customer reserves 1: Item status | char | 1 | 0 | | | | Allow NULL? |
| 23 | UVP02 | Customer reserves 2: Item status | char | 1 | 0 | | | | Allow NULL? |
| 24 | UVP03 | Item reserves 3: Item status | char | 1 | 0 | | | | Allow NULL? |
| 25 | UVP04 | Item reserves 4: Item status | char | 1 | 0 | | | | Allow NULL? |
| 26 | UVP05 | Customer reserves 5: Item status | char | 1 | 0 | | | | Allow NULL? |
| 27 | PKSTA | Packing status of item | char | 1 | 0 | | | | Allow NULL? |
| 28 | KOQUA | Confirmation status of picking/putaway | char | 1 | 0 | | | | Allow NULL? |
| 29 | COSTA | Confirmation status for ALE | char | 1 | 0 | | | | Allow NULL? |
| 30 | CMPPI | Status of credit check against financial document | char | 1 | 0 | | | | Allow NULL? |
| 31 | CMPPJ | Status of credit check against export credit insurance | char | 1 | 0 | | | | Allow NULL? |
| 32 | UVPIK | Incomplete status of item for picking/putaway | char | 1 | 0 | | | | Allow NULL? |
| 33 | UVPAK | Incomplete status of item for packaging | char | 1 | 0 | | | | Allow NULL? |
| 34 | UVWAK | Incomplete status of item regarding goods issue | char | 1 | 0 | | | | Allow NULL? |
| 35 | DCSTA | Delay status | char | 1 | 0 | | | | Allow NULL? |
| 36 | RRSTA | Revenue determination status | char | 1 | 0 | | | | Allow NULL? |
| 37 | VLSTP | Decentralized whse processing | char | 1 | 0 | | | | Allow NULL? |
| 38 | MILL_VS_VSSTA | Status of sales order item | char | 1 | 0 | | | | Allow NULL? |
