S217

MAP: AvgRetail MON | #transactional | Component: Obsolete Functionality
Column Name Description
MANDT FK Client
SPMON Period to analyze - month
WGRU2 Material group hierarchy 2
WGRU1 Material group hierarchy 1
MATKL FK Material Group
MATNR FK Material Number
WERKS FK Plant
AVGWS FK Currency Key for Average Retail
VRSIO Version number in the information structure
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
💲 Memory Currency 1 in Currency Fields for Average Retail (AVGWS_D):
UMSGEO Sales at cost
UMSGVO Sales at retail
UMSGVP Sales at retail with tax
PRSNLS Sales deviation during sales
UBPGVO Revaluation at retail, plus
UBPGVP Revaluation at retail, plus, at retail with tax
UBMGVO Revaluation at retail, minus
UBMGVP Revaluation at retail, minus, at retail with tax
Column Name Description
📏 Sales unit (VRKME):
UMSMNG Sales quantity in base unit of measure
📏 Base Unit of Measure (BASME):
UBMVPM Revaluation at retail, minus, quantity
UBPVPM Revaluation at retail, plus, quantity
UMMENGE Sales Volume Quantity
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
MERK1 Characteristic 1 ATWRT
MERK2 Characteristic 2 ATWRT
MERK3 Characteristic 3 ATWRT
Master Data Relations Join Conditions
Currency Key for Average Retail
  • S217.MANDT == TCURC.MANDT
  • S217.AVGWS == TCURC.WAERS
Memory Currency 1 in Currency Fields for Average Retail
  • S217.MANDT == TCURC.MANDT
  • S217.AVGWS_D == TCURC.WAERS
Base Unit of Measure
  • S217.MANDT == T006.MANDT
  • S217.BASME == T006.MSEHI
Account number of regular vendor
  • S217.MANDT == LFA1.MANDT
  • S217.LIFNR == LFA1.LIFNR
Client S217.MANDT == T000.MANDT
Material Group
  • S217.MANDT == T023.MANDT
  • S217.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S217.MATNR == MARA.MATNR
  • S217.MANDT == MARA.MANDT
Purchase Order Unit of Measure
  • S217.MANDT == T006.MANDT
  • S217.MEINS == T006.MSEHI
Price Band Category
  • S217.MANDT == TWPT.MANDT
  • S217.PLGTP == TWPT.PLGTP
Sales unit
  • S217.MANDT == T006.MANDT
  • S217.VRKME == T006.MSEHI
Plant
  • S217.MANDT == T001W.MANDT
  • S217.WERKS == T001W.WERKS