| 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 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 4 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | No | T148 | SOBKZ | Allow NULL? |
| 5 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN | Allow NULL? |
| 6 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR | Allow NULL? |
| 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LFGJA | Allow NULL? |
| 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | LFMON | Allow NULL? |
| 9 | SALAB | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LABST | |
| 10 | SAINS | Stock in Quality Inspection | decimal | 13 | 3 | QUAN | ((0)) | Yes | | INSME | |
| 11 | SASPE | Blocked Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SPEME | |
| 12 | SAEIN | Total Stock of All Restricted Batches | decimal | 13 | 3 | QUAN | ((0)) | Yes | | EINME | |
| 13 | ERSDA | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERSDA | Allow NULL? |
| 14 | KZBWS | Valuation of Special Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | KZBWS | Allow NULL? |
| 15 | SATRA | Stock in transit | decimal | 13 | 3 | QUAN | ((0)) | No | | SATRA | |
| 16 | SARUE | MxxxH rec. already exists for per. before last of Mxxx per. | char | 1 | 0 | CHAR | (N' ') | Yes | | SBRUE | Allow NULL? |
| 17 | SABWE | Valuated Goods Receipt Blocked Stock, Sales Order | decimal | 13 | 3 | QUAN | ((0)) | No | | SABWE | |