| 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 | SAISO | Season Category | nvarchar | 4 | 0 | CHAR | (N' ') | No | T6WSP | SAISO | Allow NULL? |
| 9 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 10 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 11 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 12 | WGRU2 | Material group hierarchy 2 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU2 | Allow NULL? |
| 13 | WGRU1 | Material group hierarchy 1 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU1 | Allow NULL? |
| 14 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 15 | PLGTP | Price Band Category | nvarchar | 2 | 0 | CHAR | (N' ') | No | TWPT | PLGTP | Allow NULL? |
| 16 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | 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 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 20 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 21 | UMSGVP | Sales at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVP | |
| 22 | UMSMNG | Sales quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UMSMNG | |
| 23 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_PRSNLS | |
| 24 | BSTGVP | Stock at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGVP | |
| 25 | BSTMNG | Stock quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BSTMNG | |
| 26 | BSTPROZ | Stock as % of sales volume | float | 15 | 16 | FLTP | ((0)) | Yes | | BESTPROZ | |
| 27 | UBGVP | Revaluations at sales price including tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBGVP | |
| 28 | UBMNG | Revaluation quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | UBMNG | |
| 29 | UBPROZ | Revaluations as a percentage | float | 15 | 16 | FLTP | ((0)) | Yes | | UBPROZ | |
| 30 | BKIVP | Stock adjustments: inventory difference at sales price + tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIVP | |
| 31 | BKIMNG | Stock adjustments: inventory differences as base unit qty | decimal | 15 | 3 | QUAN | ((0)) | Yes | | BKIMNG | |
| 32 | BKIPROZ | Stock adjustments: inventory differences as a % | float | 15 | 16 | FLTP | ((0)) | Yes | | BKIPROZ | |
| 33 | SBUDGVP | Seasonal budget at sales price including tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | GLIMGVP | |
| 34 | SBUDMNG | Seasonal budget - quantity in base unit (BUn) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | GLIMMNG | |
| 35 | VQUOTEPROZ | Initial purchasing quota (%) | float | 15 | 16 | FLTP | ((0)) | Yes | | VERT_LIM | |
| 36 | VLIMGVP | Budget already released at sales price including VAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | VBUDGVP | |
| 37 | VBUDMNG | Budget Already Released - Quantity (Base Unit of Measure) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | VLIMMNG | |
| 38 | RLIMGVP | Reserve budget SPwT | decimal | 19 | 2 | CURR | ((0)) | Yes | | RBUDGVP | |
| 39 | RLIMMNG | Reserve budget quantity in base unit of measure (BUn) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RLIMMNG | |
| 40 | BBSGVP | On-order stock at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBSGVP | |
| 41 | BBSMNG | On-order stock quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BBSMNG | |
| 42 | ULBBSGVP | Open stock transport orders (delivering plant) at SPw/VAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | ULBBSGVP | |
| 43 | ULBBSMNG | Open stock transport order qty (supplying plant) in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | ULBBSMNG | |
| 44 | UBBSGVP | Open stock transport orders at sales price including tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | UBBSGVP | |
| 45 | UBBSMNG | Open stock transport order quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | UBBSMNG | |
| 46 | ZUGGVP | Receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVP | |
| 47 | ZUGMNG | Receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ZUGMNG | |
| 48 | ABGGVP | Issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVP | |
| 49 | ABGMNG | Issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ABGMNG | |
| 50 | SOTBGVP | OTB of seasonal budget at sales price including tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | OTBSGVP | |
| 51 | SOTBMNG | OTB of seasonal budget in quantity of base unit | decimal | 15 | 3 | QUAN | ((0)) | Yes | | OTBSMNG | |
| 52 | VOTBGVP | OTB of budget already released at sales price including tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | OTBVGVP | |
| 53 | VOTBMNG | Open-to-buy of budget already released in qty of base unit | decimal | 15 | 3 | QUAN | ((0)) | Yes | | OTBVMNG | |
| 54 | AVGVP | Average price of price band at sales price with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | AVGVP | |
| 55 | GLIMGVO | Seasonal budget at sales price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | GLIMGVO | |
| 56 | GLIMGEO | Seasonal budget at purchase price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | GLIMGEO | |
| 57 | VBUDGVO | Budget already released at sales price without VAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | VBUDGVO | |
| 58 | VBUDGEO | Budget already released at purchase price without VAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | VBUDGEO | |
| 59 | RBUDGVO | Reserve budget SPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | RBUDGVO | |
| 60 | RBUDGEO | Reserve budget PPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | RBUDGEO | |
| 61 | AVGVO | Average price band price at sales price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | AVGVO | |
| 62 | AVGEO | Average price band price at purchase price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | AVGEO | |
| 63 | UBGVO | Revaluations at sales price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBGVO | |
| 64 | UBGEO | Revaluation PPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBGEO | |
| 65 | BKIVO | Stock adjustments: inventory difference at SPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIVO | |
| 66 | BKIEO | Stock adjustments: inventory difference at PPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIEO | |
| 67 | SOTBGVO | OTB of seasonal budget at sales price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | OTBSGVO | |
| 68 | SOTBGEO | OTB of seasonal budget at purchase price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | OTBSGEO | |
| 69 | VOTBGVO | OTB of budget already released at sales price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | OTBVGVO | |
| 70 | VOTBGEO | OTB of budget already released at purchase price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | OTBVGEO | |
| 71 | UBBSGVO | Open stock transport orders at sales price without tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | UBBSGVO | |
| 72 | UBBSGEO | Open stock transport orders at PPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | UBBSGEO | |
| 73 | ULBBSGVO | Open stock transport orders (delivering plant) at SPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | ULBBSGVO | |
| 74 | ULBBSGEO | Open stock transport orders (delivering plant) at PPw/oVAT | decimal | 19 | 2 | CURR | ((0)) | Yes | | ULBBSGEO | |
| 75 | UMSGEO | Sales at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGEO | |
| 76 | UMSGVO | Sales at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVO | |
| 77 | BSTGEO | Stock at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGEO | |
| 78 | BSTGVO | Stock at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGVO | |
| 79 | ABGGEO | Issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGEO | |
| 80 | ABGGVO | Issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVO | |
| 81 | ZUGGEO | Receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGEO | |
| 82 | ZUGGVO | Receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVO | |
| 83 | BBSGEO | On-order stock at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBSGEO | |
| 84 | BBSGVO | On-order stock at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BBSGVO | |
| 85 | UMSMAO | Sales margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UMSMAO | |
| 86 | UMSMAM | Sales margin with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UMSMAM | |
| 87 | WESMAO | Goods receipt margin (vendor+GR(DC)) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_WESMAO | |
| 88 | WESMAM | Goods receipt margin with tax (vendor+GR(DC)) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_WESMAM | |
| 89 | JUWERT | Annual inventory turn (value) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_JUWERT | |
| 90 | JUMENG | Annual inventory turn (quantity) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_JUMENG | |
