S086

Promotion | #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
AKTNR FK Promotion
WERKS FK Plant
BTRKZ Plant category Show values
WGRU2 Material group hierarchy 2
WGRU1 Material group hierarchy 1
MATKL FK Material Group
MATNR FK Material Number
AKTYP FK Promotion Category
AKTHE FK Promotion theme
Column Name Description
💲 Local Currency (HWAER):
UMSGEO Sales at cost
UMSGVO Sales at retail
UMSGVP Sales at retail with tax
PRSNLS Sales deviation during sales
WESGEO Goods receipt (vendor) at cost
WESGVO Goods receipt (vendor) at retail
WESGVP Goods receipt (vendor) at retail with tax
KMEGEO Goods receipt (DC) at cost
KMEGVO Goods receipt (DC) at retail
KMEGVP Goods receipt (dist. center) at retail with tax
KMAGEO Goods issue (DC) at cost
KMAGVO Goods issue (DC) at retail
KMAGVP Goods issue (dist. center) at retail with tax
BVLGEO Order volume at cost
BVLGVO Order volume at retail
BVLGVP Order volume at retail with tax
Column Name Description
📏 Base Unit of Measure (BASME):
UMSMNG Sales quantity in base unit of measure
WESMNG Goods receipt (vendor) quantity in BUn
KMEMNG Goods receipt (distribution center) quantity in BUn
KMAMNG Goods issue (distribution center) quantity in BUn
BVLMNG Order volume quantity Retail
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
BTRKZ Plant category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
WESANZ Goods receipt (vendor) number of transactions MCZAEHLINT
KMEANZ Goods receipt (distribution center), no. of transactions MCZAEHLINT
KMAANZ Goods issue (distribution center), no. of transactions MCZAEHLINT
BVLANZ Order volume, number of transactions MCZAEHLINT
WESMAO Goods receipt margin (vendor+GR(DC)) PRZ32V
WESMAM Goods receipt margin with tax (vendor+GR(DC)) PRZ32V
UMSMAO Sales margin PRZ32V
UMSMAM Sales margin with tax PRZ32V
BVLMAO Order volume margin PRZ32V
BVLMAM Order volume margin with tax PRZ32V
Master Data Relations Join Conditions
Promotion theme
  • S086.MANDT == TWAT.MANDT
  • S086.AKTHE == TWAT.AKTHE
Promotion
  • Promotion
  • Client
  • S086.AKTNR == WAKH.AKTNR
  • S086.MANDT == WAKH.MANDT
Promotion Category
  • Promotion Category
  • Client
  • S086.AKTYP == TWTY.AKTYP
  • S086.MANDT == TWTY.MANDT
Base Unit of Measure
  • S086.MANDT == T006.MANDT
  • S086.BASME == T006.MSEHI
Local Currency
  • S086.MANDT == TCURC.MANDT
  • S086.HWAER == TCURC.WAERS
Client S086.MANDT == T000.MANDT
Material Group
  • S086.MANDT == T023.MANDT
  • S086.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S086.MATNR == MARA.MATNR
  • S086.MANDT == MARA.MANDT
Plant
  • S086.MANDT == T001W.MANDT
  • S086.WERKS == T001W.WERKS