| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | CHAR | (N' ') | No | | VMSTA | Allow NULL? |
| 3 | SPVBA | Blocked for inquiry | char | 1 | 0 | CHAR | (N' ') | No | | SPVBA | Allow NULL? |
| 4 | SPVBB | Blocked for quotation | char | 1 | 0 | CHAR | (N' ') | No | | SPVBB | Allow NULL? |
| 5 | SPVBC | Blocked for sales order | char | 1 | 0 | CHAR | (N' ') | No | | SPVBC | Allow NULL? |
| 6 | SPVBD | Blocked for product proposal | char | 1 | 0 | CHAR | (N' ') | No | | SPVBD | Allow NULL? |
| 7 | SPVBE | Blocked for scheduling agreement | char | 1 | 0 | CHAR | (N' ') | No | | SPVBE | Allow NULL? |
| 8 | SPVBF | Blocked for value contract | char | 1 | 0 | CHAR | (N' ') | No | | SPVBF_VMS | Allow NULL? |
| 9 | SPVBG | Blocked for contract | char | 1 | 0 | CHAR | (N' ') | No | | SPVBG | Allow NULL? |
| 10 | SPVBH | Blocked for returns | char | 1 | 0 | CHAR | (N' ') | No | | SPVBH | Allow NULL? |
| 11 | SPVBI | Blocked for free of charge delivery | char | 1 | 0 | CHAR | (N' ') | No | | SPVBI | Allow NULL? |
| 12 | SPVBJ | Blocked for delivery | char | 1 | 0 | CHAR | (N' ') | No | | SPVBJ | Allow NULL? |
| 13 | SPVBK | Blocked for credit memo request | char | 1 | 0 | CHAR | (N' ') | No | | SPVBK | Allow NULL? |
| 14 | SPVBL | Blocked for debit memo request | char | 1 | 0 | CHAR | (N' ') | No | | SPVBL | Allow NULL? |
| 15 | LIFSP | Schedule line blocked for delivery | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVLS | LIFSP_EP | Allow NULL? |
| 16 | WAUFT | Blocked for allocation table | char | 1 | 0 | CHAR | (N' ') | Yes | | WAUFT | Allow NULL? |
| 17 | WREPL | Blocked for Replenishment | char | 1 | 0 | CHAR | (N' ') | Yes | | WREPL | Allow NULL? |
| 18 | WSTOR | Blocked for store order | char | 1 | 0 | CHAR | (N' ') | Yes | | WSTOR | Allow NULL? |
| 19 | JSPQP | Locked for Quantity Planning | char | 1 | 0 | CHAR | (N' ') | Yes | | JSPQP | Allow NULL? |
| 20 | JSPOG | Locked for Order Generation | char | 1 | 0 | CHAR | (N' ') | Yes | | JSPOG | Allow NULL? |
| 21 | JSPRP | Locked for Returns | char | 1 | 0 | CHAR | (N' ') | Yes | | JSPRP | Allow NULL? |
| 22 | JSPIP | Locked for Insert Planning | char | 1 | 0 | CHAR | (N' ') | Yes | | JSPIP | Allow NULL? |
