S214BIW2

S214BIW2 * CatMan: Indexes for Space Management Program | #transactional | Component: Obsolete Functionality
Column Name Description
MANDT FK Client
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
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SSOUR Statistic(s) origin
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
  • S214BIW2.MANDT == T006.MANDT
  • S214BIW2.BASME == T006.MSEHI
Category
Subcategory
Segment
  • Segment
  • Client
Subsegment
  • Subsegment
  • Client
Sub-Subsegment
Product Group
  • Product Group
  • Client
Brand
Client S214BIW2.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S214BIW2.MATNR == MARA.MATNR
  • S214BIW2.MANDT == MARA.MANDT
Database Currency for Planning Data in a Planning Scenario
  • S214BIW2.MANDT == TCURC.MANDT
  • S214BIW2.PSWAE == TCURC.WAERS
Plant
  • S214BIW2.MANDT == T001W.MANDT
  • S214BIW2.WERKS == T001W.WERKS