| 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 | RFSTK | Reference document header status | char | 1 | 0 | | | | Allow NULL? |
| 5 | RFGSK | Total reference status of all items | char | 1 | 0 | | | | Allow NULL? |
| 6 | BESTK | Confirmation status | char | 1 | 0 | | | | Allow NULL? |
| 7 | LFSTK | Delivery status | char | 1 | 0 | | | | Allow NULL? |
| 8 | LFGSK | Overall delivery status for all items | char | 1 | 0 | | | | Allow NULL? |
| 9 | WBSTK | Total goods movement status | char | 1 | 0 | | | | Allow NULL? |
| 10 | FKSTK | Billing status | char | 1 | 0 | | | | Allow NULL? |
| 11 | FKSAK | Billing status (order-related billing document) | char | 1 | 0 | | | | Allow NULL? |
| 12 | BUCHK | Posting Status of Billing Document | char | 1 | 0 | | | | Allow NULL? |
| 13 | ABSTK | Overall rejection status of all document items | char | 1 | 0 | | | | Allow NULL? |
| 14 | GBSTK | Overall processing status of document | char | 1 | 0 | | | | Allow NULL? |
| 15 | KOSTK | Overall picking / putaway status | char | 1 | 0 | | | | Allow NULL? |
| 16 | LVSTK | Overall status of warehouse management activities | char | 1 | 0 | | | | Allow NULL? |
| 17 | UVALS | Total incompletion status of all items in general | char | 1 | 0 | | | | Allow NULL? |
| 18 | UVVLS | Total incompletion status of all items: Delivery | char | 1 | 0 | | | | Allow NULL? |
| 19 | UVFAS | Total incompletion status of all items: Billing | char | 1 | 0 | | | | Allow NULL? |
| 20 | UVALL | General incompletion status of the header | char | 1 | 0 | | | | Allow NULL? |
| 21 | UVVLK | Header incompletion status concerning delivery | char | 1 | 0 | | | | Allow NULL? |
| 22 | UVFAK | Header incompletion status with respect to billing | char | 1 | 0 | | | | Allow NULL? |
| 23 | UVPRS | Document is incomplete with respect to pricing | char | 1 | 0 | | | | Allow NULL? |
| 24 | VBTYP | SD document category | char | 1 | 0 | | | | Allow NULL? |
| 25 | VBOBJ | SD document object | char | 1 | 0 | | | | Allow NULL? |
| 26 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | FKIVK | Billing totals status for intercompany billing | char | 1 | 0 | | | | Allow NULL? |
| 28 | RELIK | Invoice list status of billing document | char | 1 | 0 | | | | Allow NULL? |
| 29 | UVK01 | Customer reserves 1: Header status | char | 1 | 0 | | | | Allow NULL? |
| 30 | UVK02 | Customer reserves 2: Header status | char | 1 | 0 | | | | Allow NULL? |
| 31 | UVK03 | Customer reserves 3: Header status | char | 1 | 0 | | | | Allow NULL? |
| 32 | UVK04 | Custmer reserves 4: Header status | char | 1 | 0 | | | | Allow NULL? |
| 33 | UVK05 | Customer reserves 5: Header status | char | 1 | 0 | | | | Allow NULL? |
| 34 | UVS01 | Customer reserves 1: Sum of all items | char | 1 | 0 | | | | Allow NULL? |
| 35 | UVS02 | Customer reserves 2: Sum of all items | char | 1 | 0 | | | | Allow NULL? |
| 36 | UVS03 | Customer reserves 3: Sum of all items | char | 1 | 0 | | | | Allow NULL? |
| 37 | UVS04 | Customer reserves 4: Sum of all items | char | 1 | 0 | | | | Allow NULL? |
| 38 | UVS05 | Customer reserves 5: Sum of all items | char | 1 | 0 | | | | Allow NULL? |
| 39 | PKSTK | Overall packing status of all items | char | 1 | 0 | | | | Allow NULL? |
| 40 | CMPSA | Status of static credit limit check | char | 1 | 0 | | | | Allow NULL? |
| 41 | CMPSB | Status of dynamic credit limit check in the credit horizon | char | 1 | 0 | | | | Allow NULL? |
| 42 | CMPSC | Status of credit check against maximum document value | char | 1 | 0 | | | | Allow NULL? |
| 43 | CMPSD | Status of credit check against terms of payment | char | 1 | 0 | | | | Allow NULL? |
| 44 | CMPSE | Status of credit check against customer review date | char | 1 | 0 | | | | Allow NULL? |
| 45 | CMPSF | Status of credit check against open items due | char | 1 | 0 | | | | Allow NULL? |
| 46 | CMPSG | Status of credit check against oldest open items | char | 1 | 0 | | | | Allow NULL? |
| 47 | CMPSH | Status of credit check against highest dunning level | char | 1 | 0 | | | | Allow NULL? |
| 48 | CMPSI | Status of credit check against financial document | char | 1 | 0 | | | | Allow NULL? |
| 49 | CMPSJ | Status of credit check against export credit insurance | char | 1 | 0 | | | | Allow NULL? |
| 50 | CMPSK | Status of credit check against payment card authorization | char | 1 | 0 | | | | Allow NULL? |
| 51 | CMPSL | Status of credit check of reserves 4 | char | 1 | 0 | | | | Allow NULL? |
| 52 | CMPS0 | Status of credit check for customer reserve 1 | char | 1 | 0 | | | | Allow NULL? |
| 53 | CMPS1 | Status of credit check for customer reserve 2 | char | 1 | 0 | | | | Allow NULL? |
| 54 | CMPS2 | Status of credit check for customer reserve 3 | char | 1 | 0 | | | | Allow NULL? |
| 55 | CMGST | Overall status of credit checks | char | 1 | 0 | | | | Allow NULL? |
| 56 | TRSTA | Transportation planning status | char | 1 | 0 | | | | Allow NULL? |
| 57 | KOQUK | Status of pick confirmation | char | 1 | 0 | | | | Allow NULL? |
| 58 | COSTA | Confirmation status for ALE | char | 1 | 0 | | | | Allow NULL? |
| 59 | SAPRL | SAP Release | nvarchar | 4 | 0 | | | | Allow NULL? |
| 60 | UVPAS | Totals incomplete status for all items: packaging | char | 1 | 0 | | | | Allow NULL? |
| 61 | UVPIS | Totals incomplete status for all items: Picking | char | 1 | 0 | | | | Allow NULL? |
| 62 | UVWAS | Total incomplete status of all items: post goods movement | char | 1 | 0 | | | | Allow NULL? |
| 63 | UVPAK | Header incomplete status for packaging | char | 1 | 0 | | | | Allow NULL? |
| 64 | UVPIK | Header incomplete status for picking/putaway | char | 1 | 0 | | | | Allow NULL? |
| 65 | UVWAK | Post header incomplete status for goods movement | char | 1 | 0 | | | | Allow NULL? |
| 66 | UVGEK | UNUSED | char | 1 | 0 | | | | Allow NULL? |
| 67 | CMPSM | Credit check data is obsolete | char | 1 | 0 | | | | Allow NULL? |
| 68 | DCSTK | Delay status | char | 1 | 0 | | | | Allow NULL? |
| 69 | VESTK | Handling Unit Placed in Stock | char | 1 | 0 | | | | Allow NULL? |
| 70 | VLSTK | Distribution Status (Decentralized Warehouse Processing) | char | 1 | 0 | | | | Allow NULL? |
| 71 | RRSTA | Revenue determination status | char | 1 | 0 | | | | Allow NULL? |
| 72 | BLOCK | Indicator: Document preselected for archiving | char | 1 | 0 | | | | Allow NULL? |