S004E

S004 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
MATNR FK Material Number
VKORG FK Sales Organization
VTWEG FK Distribution Channel
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
USTWAE 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 Proportional factor (%) for disaggregation of product group FLTP
Master Data Relations Join Conditions
Base Unit of Measure
  • S004E.MANDT == T006.MANDT
  • S004E.BASME == T006.MSEHI
Client S004E.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S004E.MATNR == MARA.MATNR
  • S004E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S004E.PERIV == T009.PERIV
  • S004E.MANDT == T009.MANDT
Statistics Currency
  • S004E.MANDT == TCURC.MANDT
  • S004E.STWAE == TCURC.WAERS
Sales organization in order header
  • S004E.MANDT == TVKO.MANDT
  • S004E.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S004E.VKORG == TVKOV.VKORG
  • S004E.MANDT == TVKOV.MANDT
  • S004E.VTWEG == TVKOV.VTWEG