| 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 | AKTNR | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | No | WAKH | WAKTION | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 10 | BTRKZ | Plant category | char | 1 | 0 | CHAR | (N' ') | No | | VLFKZ | Allow NULL? |
| 11 | WGRU2 | Material group hierarchy 2 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU2 | Allow NULL? |
| 12 | WGRU1 | Material group hierarchy 1 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU1 | Allow NULL? |
| 13 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 14 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 15 | AKTYP | Promotion Category | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWTY | W_AKTYP | Allow NULL? |
| 16 | AKTHE | Promotion theme | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWAT | W_AKTHE | Allow NULL? |
| 17 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 18 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 19 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 20 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 21 | UMSMNG | Sales quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UMSMNG | |
| 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGEO | |
| 23 | UMSGVO | Sales at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVO | |
| 24 | UMSGVP | Sales at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVP | |
| 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_PRSNLS | |
| 26 | WESMNG | Goods receipt (vendor) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_WESMNG | |
| 27 | WESGEO | Goods receipt (vendor) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGEO | |
| 28 | WESGVO | Goods receipt (vendor) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGVO | |
| 29 | WESGVP | Goods receipt (vendor) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGVP | |
| 30 | WESANZ | Goods receipt (vendor) number of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_WESANZ | Allow NULL? |
| 31 | KMEMNG | Goods receipt (distribution center) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_KMEMNG | |
| 32 | KMEGEO | Goods receipt (DC) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMEGEO | |
| 33 | KMEGVO | Goods receipt (DC) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMEGVO | |
| 34 | KMEGVP | Goods receipt (dist. center) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMEGVP | |
| 35 | KMEANZ | Goods receipt (distribution center), no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_KMEANZ | Allow NULL? |
| 36 | KMAMNG | Goods issue (distribution center) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_KMAMNG | |
| 37 | KMAGEO | Goods issue (DC) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGEO | |
| 38 | KMAGVO | Goods issue (DC) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGVO | |
| 39 | KMAGVP | Goods issue (dist. center) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGVP | |
| 40 | KMAANZ | Goods issue (distribution center), no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_KMAANZ | Allow NULL? |
| 41 | BVLMNG | Order volume quantity Retail | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BVLMNG | |
| 42 | BVLGEO | Order volume at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BVLGEO | |
| 43 | BVLGVO | Order volume at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BVLGVO | |
| 44 | BVLGVP | Order volume at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BVLGVP | |
| 45 | BVLANZ | Order volume, number of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BVLANZ | Allow NULL? |
| 46 | WESMAO | Goods receipt margin (vendor+GR(DC)) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_WESMAO | |
| 47 | WESMAM | Goods receipt margin with tax (vendor+GR(DC)) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_WESMAM | |
| 48 | UMSMAO | Sales margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UMSMAO | |
| 49 | UMSMAM | Sales margin with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UMSMAM | |
| 50 | BVLMAO | Order volume margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_BVLMAO | |
| 51 | BVLMAM | Order volume margin with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_BVLMAM | |
