S214

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
WERKS FK Plant
Column Name Description
💲 Database Currency for Planning Data in a Planning Scenario (PSWAE):
UMSGVO Sales at retail
UMSGEO Sales at cost
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_LISTED Listing Indicator LISTED
REL_UMSMNG Weight Sales Quantity DEC6_2
REL_UMSGVO Weight Sales Sales Price DEC6_2
REL_UMSGEO Weight Sales Purchase Price DEC6_2
REL_MARGE Weight Margin DEC6_2
INDEX1 Index 1 from Plan Data for Space Management DEC6_2
INDEX2 Index 2 from Plan Data for Space Management DEC6_2
INDEX3 Index 3 from Plan Data for Space Management DEC6_2
STRATEGY Node Strategy CDT_STRATEGY
CM_AZART Number of Articles DEC8_3
Master Data Relations Join Conditions
Base Unit of Measure
  • S214.MANDT == T006.MANDT
  • S214.BASME == T006.MSEHI
Category
Subcategory
Segment
  • Segment
  • Client
Subsegment
  • Subsegment
  • Client
Sub-Subsegment
Product Group
  • Product Group
  • Client
Brand
Client S214.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S214.MATNR == MARA.MATNR
  • S214.MANDT == MARA.MANDT
Database Currency for Planning Data in a Planning Scenario
  • S214.MANDT == TCURC.MANDT
  • S214.PSWAE == TCURC.WAERS
Plant
  • S214.MANDT == T001W.MANDT
  • S214.WERKS == T001W.WERKS