| 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 | VZTTG | Warehouse process | char | 1 | 0 | CHAR | (N' ') | No | | MCL_VZTTG | Allow NULL? |
| 5 | WARTYP | Goods category (promotional goods or normal goods) | char | 1 | 0 | CHAR | (N' ') | No | | MCL_WARTYP | Allow NULL? |
| 6 | BELTYP | Document category: rough workload estimate | nvarchar | 3 | 0 | CHAR | (N' ') | No | | MCL_BELTYP | 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 | TIMEL | Time slot: Rough workload forecast | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | MCL_TIMEL | Allow NULL? |
| 10 | GEWEH | Weight unit: Rough Workload Estimate and picking waves | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCL_GEWEH | Allow NULL? |
| 11 | VOLEH | Volume unit: Rough Workload Estimate and picking waves | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCL_VOLEH | Allow NULL? |
| 12 | UGEWEH | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 13 | UVOLEH | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 14 | PLOBJ | Planning object | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | PLOBJ | Allow NULL? |
| 15 | PERKZ | Period indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PERVR | Allow NULL? |
| 16 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 17 | PLTKZ | Indicator: element used in planning | char | 1 | 0 | CHAR | (N' ') | Yes | | PLTKZ | Allow NULL? |
| 18 | ANTEI | Proportional factor (%) for disaggregation of product group | float | 15 | 16 | FLTP | ((0)) | Yes | | DANTEF | |
