S039E

S039 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
WERKS FK Plant
LGORT FK Storage location
MATNR FK Material Number
DISPO FK MRP Controller
DISMM FK MRP Type
MTART FK Material type
MATKL FK Material Group
GSBER FK Business Area
SPART FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AMBWG Number of material movements ANZAHL
UHWAER Conversion factor: quantities FLTP
UBASME Conversion factor: quantities FLTP
UAMBWG 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
  • S039E.MANDT == T006.MANDT
  • S039E.BASME == T006.MSEHI
MRP Type
  • S039E.MANDT == T438A.MANDT
  • S039E.DISMM == T438A.DISMM
MRP Controller
  • Plant
  • MRP Controller
  • Client
  • S039E.WERKS == T024D.WERKS
  • S039E.DISPO == T024D.DISPO
  • S039E.MANDT == T024D.MANDT
Business Area
  • S039E.MANDT == TGSB.MANDT
  • S039E.GSBER == TGSB.GSBER
Local Currency
  • S039E.MANDT == TCURC.MANDT
  • S039E.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S039E.LGORT == T001L.LGORT
  • S039E.MANDT == T001L.MANDT
  • S039E.WERKS == T001L.WERKS
Client S039E.MANDT == T000.MANDT
Material Group
  • S039E.MANDT == T023.MANDT
  • S039E.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S039E.MATNR == MARA.MATNR
  • S039E.MANDT == MARA.MANDT
Material type
  • S039E.MANDT == T134.MANDT
  • S039E.MTART == T134.MTART
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S039E.PERIV == T009.PERIV
  • S039E.MANDT == T009.MANDT
Division
  • S039E.MANDT == TSPA.MANDT
  • S039E.SPART == TSPA.SPART
Plant
  • S039E.MANDT == T001W.MANDT
  • S039E.WERKS == T001W.WERKS