| 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 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | No | T300 | LGNUM | Allow NULL? |
| 9 | VZTTG | Warehouse process | char | 1 | 0 | CHAR | (N' ') | No | | MCL_VZTTG | Allow NULL? |
| 10 | WARTYP | Goods category (promotional goods or normal goods) | char | 1 | 0 | CHAR | (N' ') | No | | MCL_WARTYP | Allow NULL? |
| 11 | BELTYP | Document category: rough workload estimate | nvarchar | 3 | 0 | CHAR | (N' ') | No | | MCL_BELTYP | Allow NULL? |
| 12 | METYP | Unit-of-measure load category according to workload criteria | char | 1 | 0 | CHAR | (N' ') | No | TMET | METYP | Allow NULL? |
| 13 | VHART | Packaging Material Type Rough Workload Estimate | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVTY | MCL_VHARTL | Allow NULL? |
| 14 | TIMEL | Time slot: Rough workload forecast | nvarchar | 4 | 0 | CHAR | (N' ') | No | TC37A | MCL_TIMEL | Allow NULL? |
| 15 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 16 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 17 | GEWEH | Weight unit: Rough Workload Estimate and picking waves | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCL_GEWEH | Allow NULL? |
| 18 | VOLEH | Volume unit: Rough Workload Estimate and picking waves | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCL_VOLEH | Allow NULL? |
| 19 | METYP_E | Quantity for unit-of-measure load category + | decimal | 15 | 3 | DEC | ((0)) | Yes | | MCL_METYPE | |
| 20 | METYP_R | Quantity for UoM handling group | decimal | 15 | 3 | DEC | ((0)) | Yes | | MCL_METYPR | |
| 21 | METYP_D | Quantity for unit-of-measure load category | decimal | 15 | 3 | DEC | ((0)) | Yes | | MCL_METYPD | |
| 22 | MEGEW_E | Weight for quantity + | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCL_MEGEWE | |
| 23 | MEGEW_R | Weight for quantity - | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCL_MEGEWR | |
| 24 | MEGEW_D | Weight for quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCL_MEGEWD | |
| 25 | MEVOL_E | Volume for quantity + | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCL_MEVOLE | |
| 26 | MEVOL_R | Volume for quantity - | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCL_MEVOLR | |
| 27 | MEVOL_D | Volume for quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCL_MEVOLD | |
| 28 | BZEIT_E | Processing time+ for quantity in hours | decimal | 17 | 5 | DEC | ((0)) | Yes | | MCL_BZEITE | |
| 29 | BZEIT_R | Processing time- for quantity in hours | decimal | 17 | 5 | DEC | ((0)) | Yes | | MCL_BZEITR | |
| 30 | BZEIT_D | Processing time for quantity in hours | decimal | 17 | 5 | DEC | ((0)) | Yes | | MCL_BZEITD | |
| 31 | VHART_E | Packaging Materials for Packaging Material Type + | decimal | 15 | 3 | DEC | ((0)) | Yes | | MCL_VHARTE | |
| 32 | VHART_R | Packaging Materials for Packaging Material Type | decimal | 15 | 3 | DEC | ((0)) | Yes | | MCL_VHARTR | |
| 33 | VHART_D | Packaging Materials for Packaging Material Type | decimal | 15 | 3 | DEC | ((0)) | Yes | | MCL_VHARTD | |
| 34 | ANZBP_E | Number of document items/schedule lines + | int | 10 | 0 | INT4 | ((0)) | Yes | | MCL_ANZBPE | Allow NULL? |
| 35 | ANZBP_R | Number of document items/schedule lines - | int | 10 | 0 | INT4 | ((0)) | Yes | | MCL_ANZBPR | Allow NULL? |
| 36 | ANZBP_D | Number of document items/schedule lines | int | 10 | 0 | INT4 | ((0)) | Yes | | MCL_ANZBPD | Allow NULL? |
| 37 | BELNRL | Last document number for database record RWE | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | MCL_BELNRL | Allow NULL? |
| 38 | BELPSL | Last document item for RWE database record | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | MCL_BELPSL | Allow NULL? |
