S119E

S119 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
BONNR Transaction number (till receipt)
WERKS FK Plant
AFLAG Promotion indicator Show values
KALWOC Calendar week
WOCHTG Weekday Show values
TGZTKL FK Time of day class
VKSTD Hour of sale Show values
Column Name Description
Column Name Description
Column Name Description
Column Name Description
AFLAG Promotion indicator Show values
WOCHTG Weekday Show values
VKSTD Hour of sale Show values
Column Name Description Domain name
UBASME Conversion factor: quantities FLTP
UVRKME Conversion factor: quantities FLTP
UWAERK Conversion factor: quantities FLTP
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Proportional factor (%) for disaggregation of product group FLTP
Master Data Relations Join Conditions
Base Unit of Measure
  • S119E.MANDT == T006.MANDT
  • S119E.BASME == T006.MSEHI
Client S119E.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S119E.PERIV == T009.PERIV
  • S119E.MANDT == T009.MANDT
Time of day class
  • S119E.MANDT == TMCWW.MANDT
  • S119E.TGZTKL == TMCWW.TGZTKL
Sales unit
  • S119E.MANDT == T006.MANDT
  • S119E.VRKME == T006.MSEHI
SD Document Currency
  • S119E.MANDT == TCURC.MANDT
  • S119E.WAERK == TCURC.WAERS
Plant
  • S119E.MANDT == T001W.MANDT
  • S119E.WERKS == T001W.WERKS