S121

Material aggregation - POS | #transactional | Component: Data Collection
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
MATKL FK Material Group
MATNR FK Material Number
WERKS FK Plant
AKTNR FK Promotion
KSCHL FK Condition type, sales
Column Name Description
💲 SD Document Currency (WAERK):
UMSGVP Retail price w/tax from sales as per receipts/aggreg.sales
UMSGVO Rtl price from sales as per receipts/aggreg.sales
UMSGEO Sales transactions (till receipts) at cost
PRSNLS Price reduction
PDIFF Trnsctn price diff. between R/3 -> and sales price at POS
Column Name Description
📏 Base Unit of Measure (BASME):
UMSMNG Transaction 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
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • S121.AKTNR == WAKH.AKTNR
  • S121.MANDT == WAKH.MANDT
Base Unit of Measure
  • S121.MANDT == T006.MANDT
  • S121.BASME == T006.MSEHI
Sales district
  • S121.MANDT == T171.MANDT
  • S121.BZIRK == T171.BZIRK
Condition type, sales
  • Condition type, sales
  • Client
  • ?
  • ?
  • S121.KSCHL == T685.KSCHL
  • S121.MANDT == T685.MANDT
  • S121.[column in domain "KVEWE"] == T685.KVEWE
  • S121.[column in domain "KAPPL"] == T685.KAPPL
Client S121.MANDT == T000.MANDT
Material Group
  • S121.MANDT == T023.MANDT
  • S121.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S121.MATNR == MARA.MATNR
  • S121.MANDT == MARA.MANDT
SD Document Currency
  • S121.MANDT == TCURC.MANDT
  • S121.WAERK == TCURC.WAERS
Plant
  • S121.MANDT == T001W.MANDT
  • S121.WERKS == T001W.WERKS