S117

Receipt/article | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPTAG Period to analyze - current date
BONNR Transaction number (till receipt)
WERKS FK Plant
MATKL FK Material Group
MATNR FK Material Number
AFLAG Promotion indicator Show values
KALWOC Calendar week
WOCHTG Weekday Show values
TGZTKL FK Time of day class
VKSTD Hour of sale Show values
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
💲 SD Document Currency (WAERK):
UMSATZ Sales POS
PRSNLS Price reduction from sales as per receipts/aggregated sales
Column Name Description
📏 Base Unit of Measure (BASME):
UMSMNG Transaction sales - quantity in base unit of measure
📏 Sales unit (VRKME):
VKMNG Transaction sales - quantity in sales unit
Column Name Description
SPTAG Period to analyze - current date
UHZEIT Time sale was entered
Column Name Description
AFLAG Promotion indicator Show values
WOCHTG Weekday Show values
VKSTD Hour of sale Show values
ATTYP Material Category Show values
KUNDK Customer ID Show values
KMONAT Calendar month Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
SAISJ Season Year CJAHR
MAKTX Material Description TEXT40
CCNUM Payment cards: Card number CCNUM
ANZPOS Number of transaction items (till receipts) MCZAEHLINT
ANZAAR Number of promotion items MCZAEHLINT
QUARTAL Quarter NUM01
JAHR Year GJAHR
Master Data Relations Join Conditions
Promotion theme
  • S117.MANDT == TWAT.MANDT
  • S117.AKTHE == TWAT.AKTHE
Promotion
  • Promotion
  • Client
  • S117.AKTNR == WAKH.AKTNR
  • S117.MANDT == WAKH.MANDT
Promotion Category
  • Promotion Category
  • Client
  • S117.AKTYP == TWTY.AKTYP
  • S117.MANDT == TWTY.MANDT
Base Unit of Measure
  • S117.MANDT == T006.MANDT
  • S117.BASME == T006.MSEHI
Customer number
  • S117.MANDT == KNA1.MANDT
  • S117.KUNNR == KNA1.KUNNR
Client S117.MANDT == T000.MANDT
Material Group
  • S117.MANDT == T023.MANDT
  • S117.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S117.MATNR == MARA.MATNR
  • S117.MANDT == MARA.MANDT
Material type
  • S117.MANDT == T134.MANDT
  • S117.MTART == T134.MTART
Price Band Category
  • S117.MANDT == TWPT.MANDT
  • S117.PLGTP == TWPT.PLGTP
Season Category
  • S117.MANDT == T6WSP.MANDT
  • S117.SAISO == T6WSP.SAISO
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • S117.SATNR == MARA.MATNR
  • S117.MANDT == MARA.MANDT
Time of day class
  • S117.MANDT == TMCWW.MANDT
  • S117.TGZTKL == TMCWW.TGZTKL
Sales unit
  • S117.MANDT == T006.MANDT
  • S117.VRKME == T006.MSEHI
SD Document Currency
  • S117.MANDT == TCURC.MANDT
  • S117.WAERK == TCURC.WAERS
Plant
  • S117.MANDT == T001W.MANDT
  • S117.WERKS == T001W.WERKS
Product catalog number
  • Product catalog number
  • Client
  • S117.WMINR == WWMI.WMINR
  • S117.MANDT == WWMI.MANDT