| 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 | ALTYP | Stock removal storage type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T301 | MCWM_ALTYP | Allow NULL? |
| 10 | ALBER | Stock removal storage section | nvarchar | 3 | 0 | CHAR | (N' ') | No | T302 | MCWM_ALBER | Allow NULL? |
| 11 | ELTYP | Stock placement storage type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T301 | MCWM_ELTYP | Allow NULL? |
| 12 | ELBER | Stock placement storage section | nvarchar | 3 | 0 | CHAR | (N' ') | No | T302 | MCWM_ELBER | Allow NULL? |
| 13 | BWLVS | Movement Type for Warehouse Management | nvarchar | 3 | 0 | NUMC | (N'000') | No | T333 | BWLVS | Allow NULL? |
| 14 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 15 | LETYP | Storage Unit Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T307 | LVS_LETYP | Allow NULL? |
| 16 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 17 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 18 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | * | GEWEI | Allow NULL? |
| 19 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | No | * | MEINS | Allow NULL? |
| 20 | LZEIT | WM time unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | | MCWM_LZEIT | Allow NULL? |
| 21 | AEGEW | Moved weight between stock removal/placement type | decimal | 15 | 3 | QUAN | ((0)) | No | | MCWM_AEGEW | |
| 22 | AEMNG | Moved quantity between stock removal/placement type | decimal | 15 | 3 | QUAN | ((0)) | No | | MCWM_AEMNG | |
| 23 | AEPSC | Number of movements between stock removal/placement type | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_AEPSC | |
| 24 | EDMNG | Real difference quantity (not on source bin) | decimal | 15 | 3 | QUAN | ((0)) | No | | MCWM_EDMNG | |
| 25 | EDPSC | Counter of real difference items | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_EDPSC | |
| 26 | VDMNG | Difference quantity for the source bin | decimal | 15 | 3 | QUAN | ((0)) | No | | MCWM_VDMNG | |
| 27 | VDPSC | Counter for source bin difference items | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_VDPSC | |
| 28 | RGLAC | Return to stock removal bin | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_RGLAC | |
| 29 | NKPSC | Counter for items with zero stock check | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_NKPSC | |
| 30 | RSBZC | Number with reservation reference | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_RSBZC | |
| 31 | TBBZC | Number with TR reference | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_TBBZC | |
| 32 | LFBZC | Number of items for deliveries | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_LFBZC | |
| 33 | RFBZC | Number of items with reference to reference number | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_RFBZC | |
| 34 | AE_AQ | Time between TO creation and confirmation in minutes | decimal | 15 | 0 | QUAN | ((0)) | No | | MCWM_AE_AQ | |
| 35 | AEAQC | Counter for totals field time diff. TO creat. to TO conf. | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_AEAQC | |
| 36 | BE_AE | Time between TR creation and TO creation | decimal | 15 | 0 | QUAN | ((0)) | No | | MCWM_BE_AE | |
| 37 | BEAEC | Counter for totals field time diff.TR creat. to TO creat. | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_BEAEC | |
| 38 | BP_AE | Time between TR planning data and TO creation | decimal | 15 | 0 | QUAN | ((0)) | No | | MCWM_BP_AE | |
| 39 | BPAEC | Counter for totals field time difference TR plng to TO creat | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_BPAEC | |
| 40 | LK_AE | Time between delivery note pick date and TO creation | decimal | 15 | 0 | QUAN | ((0)) | No | | MCWM_LK_AE | |
| 41 | LKAEC | Counter for totals field, time diff. pick.date to TO creat. | decimal | 9 | 0 | DEC | ((0)) | No | | MCWM_LKAEC | |
