| 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 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | No | T300 | LGNUM | Allow NULL? |
| 4 | VBELN | Delivery | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN_VL | Allow NULL? |
| 5 | PLGTYP | Planned picking storage type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T301 | MCL_PLGTYP | Allow NULL? |
| 6 | PKOBER | Planned picking area | nvarchar | 3 | 0 | CHAR | (N' ') | No | T30A | MCL_PKOBER | Allow NULL? |
| 7 | METYP | Unit-of-measure load category according to workload criteria | char | 1 | 0 | CHAR | (N' ') | No | TMET | METYP | Allow NULL? |
| 8 | VHART | Packaging Material Type Rough Workload Estimate | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVTY | MCL_VHARTL | Allow NULL? |
| 9 | GEWEH | Weight unit: Rough Workload Estimate and picking waves | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCL_GEWEH | Allow NULL? |
| 10 | VOLEH | Volume unit: Rough Workload Estimate and picking waves | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCL_VOLEH | Allow NULL? |
| 11 | UGEWEH | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 12 | UVOLEH | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 13 | PLOBJ | Planning object | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | PLOBJ | Allow NULL? |
| 14 | PERKZ | Period indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PERVR | Allow NULL? |
| 15 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 16 | PLTKZ | Indicator: element used in planning | char | 1 | 0 | CHAR | (N' ') | Yes | | PLTKZ | Allow NULL? |
| 17 | ANTEI | Proportional factor (%) for disaggregation of product group | float | 15 | 16 | FLTP | ((0)) | Yes | | DANTEF | |
