S219

null | #transactional | Component: Obsolete Functionality
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
HIER_ID Hierarchy ID
CDT1 FK Category
CDT2 FK Subcategory
CDT3 FK Segment
CDT4 FK Subsegment
MATNR FK Material Number
CM_LAND1 FK Country/Region Key
REGIO FK Region (State, Province, County)
Column Name Description
💲 Database Currency for Planning Data in a Planning Scenario (PSWAE):
UMSGVO Sales at retail
UMSGEO Sales at cost
CM_UMMKT_E Market Turnover (External)
CM_AVGPR_E Average Price per Article (External)
CM_SHLFPRC Recommended Shelf Price
Column Name Description
📏 Base Unit of Measure (BASME):
UMSMNG Sales quantity in base unit of measure
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
CM_AZART Number of Articles DEC8_3
CM_LISTED Listing Indicator LISTED
CM_ABDSG_E Market Coverage for Segment Level (External) DEC3_3
CM_ABDSS_E Market Coverage for Subsegment Level (External) DEC3_3
Master Data Relations Join Conditions
Base Unit of Measure
  • S219.MANDT == T006.MANDT
  • S219.BASME == T006.MSEHI
Category
Subcategory
Segment
  • Segment
  • Client
Subsegment
  • Subsegment
  • Client
Sub-Subsegment
Product Group
  • Product Group
  • Client
Brand
Country/Region Key
  • Country/Region Key
  • Client
  • S219.CM_LAND1 == T005.LAND1
  • S219.MANDT == T005.MANDT
Client S219.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S219.MATNR == MARA.MATNR
  • S219.MANDT == MARA.MANDT
Database Currency for Planning Data in a Planning Scenario
  • S219.MANDT == TCURC.MANDT
  • S219.PSWAE == TCURC.WAERS
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • S219.MANDT == T005S.MANDT
  • S219.CM_LAND1 == T005S.LAND1
  • S219.REGIO == T005S.BLAND