S110E

S110 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
SAISO FK Season Category
EKORG FK Purchasing organization
VKORG FK Sales Organization
VTWEG FK Distribution Channel
WGRU2 Material group hierarchy 2
WGRU1 Material group hierarchy 1
MATKL FK Material Group
PLGTP FK Price Band Category
WERKS FK Plant
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
UHWAER Conversion factor: quantities FLTP
UBASME Conversion factor: quantities FLTP
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Factor (%) for disaggregation of planning level quantity CHAR10
Master Data Relations Join Conditions
Base Unit of Measure
  • S110E.MANDT == T006.MANDT
  • S110E.BASME == T006.MSEHI
Purchasing organization
  • S110E.MANDT == T024E.MANDT
  • S110E.EKORG == T024E.EKORG
Local Currency
  • S110E.MANDT == TCURC.MANDT
  • S110E.HWAER == TCURC.WAERS
Client S110E.MANDT == T000.MANDT
Material Group
  • S110E.MANDT == T023.MANDT
  • S110E.MATKL == T023.MATKL
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S110E.PERIV == T009.PERIV
  • S110E.MANDT == T009.MANDT
Price Band Category
  • S110E.MANDT == TWPT.MANDT
  • S110E.PLGTP == TWPT.PLGTP
Season Category
  • S110E.MANDT == T6WSP.MANDT
  • S110E.SAISO == T6WSP.SAISO
Sales Organization
  • S110E.MANDT == TVKO.MANDT
  • S110E.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S110E.VTWEG == TVTW.VTWEG
  • S110E.MANDT == TVTW.MANDT
Plant
  • S110E.MANDT == T001W.MANDT
  • S110E.WERKS == T001W.WERKS