S212BIW1

S212BIW1 * CatMan: High Level | #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
CDT5 FK Sub-Subsegment
CDT6 FK Product Group
CDT7 FK Brand
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):
BSTGEO Stock at cost
UMSGVO Sales at retail
UMSGVP Sales at retail with tax
UMSGEO Sales at cost
CM_UMMKT_E Market Turnover (External)
CM_UMSVO_E Sales at Sales Price (External)
CM_TAVAL_E Average Value of the Shopping Basket (External)
CM_UMSTC_E Target-Customer Sales (External)
BKIMVO Stock adjustment inventory difference minus (retail)
CM_AVGPR_E Average Price per Article (External)
AUMGVO Promotion sales at retail
AUMGEO Promotion sales at cost
Column Name Description
📏 Base Unit of Measure (BASME):
AUMMNG Promotion sales quantity in BUn
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_AZPRM Number of Article Promotions DEC8
CM_PTRTC_E Penetration Amongst Target Customers (External) DEC3_3
CM_PFQTC_E Purchasing Frequency of Target Customers (External) DEC3_3
CM_PFQ_E Purchasing Frequency (External) DEC3_3
CM_AZART Number of Articles DEC8_3
CM_ABDSG_E Market Coverage for Segment Level (External) DEC3_3
CM_ABDSS_E Market Coverage for Subsegment Level (External) DEC3_3
CM_CLOSR_E Closure Rate (External) DEC3_3
CM_STREV_E Number of Store Visits per Customer DEC3_3
CM_SHLFSPC Shelf Space
CM_CUSTF_E Customer Satisfaction (External) DEC3_3
CM_AZKON_E Number of Consumers (External) DEC8_3
CM_AZKUN_E Number of Customers (External) DEC8_3
CM_MGRWT_E Market Growth (External) DECV3_3
CM_AVGUB_E Average Number of Articles per Purchase (External)
CM_PENTR_E Penetration (External) DEC3_3
Master Data Relations Join Conditions
Base Unit of Measure
  • S212BIW1.MANDT == T006.MANDT
  • S212BIW1.BASME == T006.MSEHI
Category
Subcategory
Segment
  • Segment
  • Client
Subsegment
  • Subsegment
  • Client
Sub-Subsegment
Product Group
  • Product Group
  • Client
Brand
Client S212BIW1.MANDT == T000.MANDT
Database Currency for Planning Data in a Planning Scenario
  • S212BIW1.MANDT == TCURC.MANDT
  • S212BIW1.PSWAE == TCURC.WAERS