S217 - MAP: AvgRetail MON
MAP: AvgRetail MON information is stored in SAP table S217.
It is part of development package WIS_PLAN in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Retail: Planning".
It is part of development package WIS_PLAN in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Retail: Planning".
Fields for table S217
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| WGRU2 | Material group hierarchy 2 | X | MCW_WGRU2 | CHAR | 36 | |
| WGRU1 | Material group hierarchy 1 | X | MCW_WGRU1 | CHAR | 36 | |
| MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| AVGWS | Currency Key for Average Retail | X | WISP_AVGWS | CUKY | 10 | TCURC |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| VRKME | Sales unit | VRKME | UNIT | 6 | T006 | |
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| AVGWS_D | Memory Currency 1 in Currency Fields for Average Retail | WISP_AVGW1 | CUKY | 10 | TCURC | |
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 8 | ||
| UBMVPM | Revaluation at retail, minus, quantity | MCW_UBMVPM | QUAN | 8 | ||
| UBPVPM | Revaluation at retail, plus, quantity | MCW_UBPVPM | QUAN | 8 | ||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 10 | ||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 10 | ||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 10 | ||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 10 | ||
| UBPGVO | Revaluation at retail, plus | MCW_UBPGVO | CURR | 10 | ||
| UBPGVP | Revaluation at retail, plus, at retail with tax | MCW_UBPGVP | CURR | 10 | ||
| UBMGVO | Revaluation at retail, minus | MCW_UBMGVO | CURR | 10 | ||
| UBMGVP | Revaluation at retail, minus, at retail with tax | MCW_UBMGVP | CURR | 10 | ||
| MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 6 | T006 | |
| MERK1 | Characteristic 1 | MCW_MERK1 | CHAR | 140 | ||
| MERK2 | Characteristic 2 | MCW_MERK2 | CHAR | 140 | ||
| MERK3 | Characteristic 3 | MCW_MERK3 | CHAR | 140 | ||
| LIFNR | Account number of regular vendor | MCW_RLIFN | CHAR | 20 | LFA1 | |
| PLGTP | Price Band Category | PLGTP | CHAR | 4 | TWPT | |
| UMMENGE | Sales Volume Quantity | MC_UMMENGE | QUAN | 8 |