S086E

S086 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
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
Column Name Description
Column Name Description
Column Name Description
BTRKZ Plant category Show values
Column Name Description Domain name
UBASME Conversion factor: quantities FLTP
UHWAER 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
Promotion theme
  • S086E.MANDT == TWAT.MANDT
  • S086E.AKTHE == TWAT.AKTHE
Promotion
  • Promotion
  • Client
  • S086E.AKTNR == WAKH.AKTNR
  • S086E.MANDT == WAKH.MANDT
Promotion Category
  • Promotion Category
  • Client
  • S086E.AKTYP == TWTY.AKTYP
  • S086E.MANDT == TWTY.MANDT
Base Unit of Measure
  • S086E.MANDT == T006.MANDT
  • S086E.BASME == T006.MSEHI
Local Currency
  • S086E.MANDT == TCURC.MANDT
  • S086E.HWAER == TCURC.WAERS
Client S086E.MANDT == T000.MANDT
Material Group
  • S086E.MANDT == T023.MANDT
  • S086E.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S086E.MATNR == MARA.MATNR
  • S086E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S086E.PERIV == T009.PERIV
  • S086E.MANDT == T009.MANDT
Plant
  • S086E.MANDT == T001W.MANDT
  • S086E.WERKS == T001W.WERKS