| 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 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024 | EKGRP | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 10 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | ELIFN | Allow NULL? |
| 11 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 12 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | SATNR | Allow NULL? |
| 13 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 14 | SAISJ | Season Year | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SAISJ | Allow NULL? |
| 15 | SAISO | Season Category | nvarchar | 4 | 0 | CHAR | (N' ') | No | T6WSP | SAISO | Allow NULL? |
| 16 | PLGTP | Price Band Category | nvarchar | 2 | 0 | CHAR | (N' ') | No | TWPT | PLGTP | 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 | AUMMNG | Promotion sales quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUMMNG | |
| 27 | AUMGEO | Promotion sales at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGEO | |
| 28 | AUMGVO | Promotion sales at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGVO | |
| 29 | AUMGVP | Promotion sales at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGVP | |
| 30 | UBPVPM | Revaluation at retail, plus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBPVPM | |
| 31 | UBPGVO | Revaluation at retail, plus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGVO | |
| 32 | UBPGVP | Revaluation at retail, plus, at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGVP | |
| 33 | UBPVAZ | Revaluation at retail, plus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBPVAZ | Allow NULL? |
| 34 | UBMVPM | Revaluation at retail, minus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBMVPM | |
| 35 | UBMGVO | Revaluation at retail, minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGVO | |
| 36 | UBMGVP | Revaluation at retail, minus, at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGVP | |
| 37 | UBMVAZ | Revaluation at retail, minus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBMVAZ | Allow NULL? |
| 38 | ZUGMNG | Receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ZUGMNG | |
| 39 | ZUGGEO | Receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGEO | |
| 40 | ZUGGVO | Receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVO | |
| 41 | ZUGGVP | Receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVP | |
| 42 | ABGMNG | Issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ABGMNG | |
| 43 | ABGGEO | Issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGEO | |
| 44 | ABGGVO | Issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVO | |
| 45 | ABGGVP | Issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVP | |
| 46 | BBZMNG | Order stock receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BBZMNG | |
| 47 | BBZGEO | Order stock receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBZGEO | |
| 48 | BBZGVO | Order stock receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBZGVO | |
| 49 | BBZGVP | Order stock receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBZGVP | |
| 50 | BBAMNG | Order stock issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BBAMNG | |
| 51 | BBAGEO | Order stock issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBAGEO | |
| 52 | BBAGVO | Order stock issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBAGVO | |
| 53 | BBAGVP | Order stock issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBAGVP | |
| 54 | KMAMNG | Goods issue (distribution center) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_KMAMNG | |
| 55 | KMAGEO | Goods issue (DC) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGEO | |
| 56 | KMAGVO | Goods issue (DC) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGVO | |
| 57 | KMAGVP | Goods issue (dist. center) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGVP | |
| 58 | KMAANZ | Goods issue (distribution center), no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_KMAANZ | Allow NULL? |
| 59 | ULEMNG | Goods clearing: receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ULEMNG | |
| 60 | ULEGEO | Goods clearing: receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGEO | |
| 61 | ULEGVO | Goods clearing: receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGVO | |
| 62 | ULEGVP | Goods clearing: receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGVP | |
| 63 | ULEANZ | Goods clearing: receipts, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ULEANZ | Allow NULL? |
| 64 | ULAMNG | Goods clearing: issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ULAMNG | |
| 65 | ULAGEO | Goods clearing: issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGEO | |
| 66 | ULAGVO | Goods clearing: issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGVO | |
| 67 | ULAGVP | Goods clearing: issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGVP | |
| 68 | ULAANZ | Goods clearing: issues, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ULAANZ | Allow NULL? |
| 69 | MERK1 | Characteristic 1 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MCW_MERK1 | Allow NULL? |
| 70 | MERK2 | Characteristic 2 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MCW_MERK2 | Allow NULL? |
| 71 | MERK3 | Characteristic 3 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MCW_MERK3 | Allow NULL? |
| 72 | WGRU2 | Material group hierarchy 2 | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | MCW_WGRU2 | Allow NULL? |
| 73 | WGRU1 | Material group hierarchy 1 | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | MCW_WGRU1 | Allow NULL? |
| 74 | ATINM1 | Internal characteristic number, characteristic 1 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | MCW_ATINM1 | Allow NULL? |
| 75 | ATINM2 | Internal characteristic number, characteristic 2 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | MCW_ATINM2 | Allow NULL? |
| 76 | ATINM3 | Internal characteristic number, characteristic 3 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | MCW_ATINM3 | Allow NULL? |