S124

Customer / material | #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
WERKS FK Plant
KUNAG FK Sold-to Party
WGRU2 Material group hierarchy 2
WGRU1 Material group hierarchy 1
MATKL FK Material Group
SAISO FK Season Category
PLGTP FK Price Band Category
MATNR FK Material Number
Column Name Description
💲 Local Currency (HWAER):
KAVGEO Sales order volume at cost
KAVGVO Sales order volume at retail
KAVGVP Sales order volume at retail with tax
RAVGEO Return orders at cost
RAVGVO Return orders at retail
RAVGVP Return orders at retail with tax
SAVGEO Third-party orders at cost
SAVGVO Third party orders at retail
SAVGVP Third-party orders at retail with tax
OAVWRT On-order value IS-R
UMAGEO Sales (absolute) at cost
UMAGVO Sales (absolute) at retail
UMAGVP Sales (absolute) at retail with tax
PRSNLA Sales deviation (absolute) during sales
AUMGEO Promotion sales at cost
AUMGVO Promotion sales at retail
AUMGVP Promotion sales at retail with tax
GUTGEO Credit memo at cost
GUTGVO Credit memo at retail
GUTGVP Credit memo at retail with tax
GUTNLS Credit memo deviation at sale
UMSGEO Third-party sales at cost
UMSGVO Third-party sales at retail
UMSGVP Third-party sales at retail with tax
PRSNLS Third-party sales deviation
Column Name Description
📏 Base Unit of Measure (BASME):
KAVMNG Sales order volume quantity
RAVMNG Return orders quantity
SAVMNG Third-party orders quantity
LIFMNG Deliveries to customers, quantity
RLFMNG Return deliveries from customer, quantity
OAVMNG On-order quantity IS-R
UMAMNG Sales (absolute) quantity in BUn
AUMMNG Promotion sales quantity in BUn
GUTMNG Credit memo quantity in BUn
UMSMNG Third-party 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
KAVANZ Sales order volume number of transactions MCZAEHLINT
RAVANZ Return orders, no. of transactions MCZAEHLINT
SAVANZ Third-party order, no. of transactions MCZAEHLINT
LIFANZ Deliveries to customers, no. of transactions MCZAEHLINT
RLFANZ Return deliveries from customer, no. of transactions MCZAEHLINT
KAVMAM Sales order volume margin with tax PRZ32V
KAVMAO Sales order volume margin PRZ32V
SAVMAM Third-party order margin w/tax PRZ32V
SAVMAO Third-party order margin PRZ32V
UMSMAO Sales margin PRZ32V
UMSMAM Sales margin with tax PRZ32V
AUMMAO Promotion sales margin PRZ32V
AUMMAM Promotion sales margin with tax PRZ32V
ASCAR Assortment ASORT
Master Data Relations Join Conditions
Base Unit of Measure
  • S124.MANDT == T006.MANDT
  • S124.BASME == T006.MSEHI
Local Currency
  • S124.MANDT == TCURC.MANDT
  • S124.HWAER == TCURC.WAERS
Customer Group
  • Customer Group
  • Client
  • S124.KDGRP == T151.KDGRP
  • S124.MANDT == T151.MANDT
Sold-to Party
  • S124.MANDT == KNA1.MANDT
  • S124.KUNAG == KNA1.KUNNR
Payer
  • S124.MANDT == KNA1.MANDT
  • S124.KUNRG == KNA1.KUNNR
Vendor's account number
  • S124.MANDT == LFA1.MANDT
  • S124.LIFNR == LFA1.LIFNR
Client S124.MANDT == T000.MANDT
Material Group
  • S124.MANDT == T023.MANDT
  • S124.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S124.MATNR == MARA.MATNR
  • S124.MANDT == MARA.MANDT
Price Band Category
  • S124.MANDT == TWPT.MANDT
  • S124.PLGTP == TWPT.PLGTP
Season Category
  • S124.MANDT == T6WSP.MANDT
  • S124.SAISO == T6WSP.SAISO
Plant
  • S124.MANDT == T001W.MANDT
  • S124.WERKS == T001W.WERKS