S200E

S200 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
INVNU Physical Inventory Number
WERKS Plant
LGORT Storage location
MATKL FK Material Group
MATNR FK Material Number
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
BSTAR FK Stock type
IVSTAT Statistical status of physical inventory Show values
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IVSTAT Statistical status of physical inventory 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
Base Unit of Measure
  • S200E.MANDT == T006.MANDT
  • S200E.BASME == T006.MSEHI
Stock type S200E.BSTAR == T064A.BSTAR
Batch Number
  • Material Number
  • Client
  • Batch Number
  • S200E.MATNR == MCH1.MATNR
  • S200E.MANDT == MCH1.MANDT
  • S200E.CHARG == MCH1.CHARG
Local Currency
  • S200E.MANDT == TCURC.MANDT
  • S200E.HWAER == TCURC.WAERS
Client S200E.MANDT == T000.MANDT
Material Group
  • S200E.MANDT == T023.MANDT
  • S200E.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S200E.MATNR == MARA.MATNR
  • S200E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S200E.PERIV == T009.PERIV
  • S200E.MANDT == T009.MANDT
Special Stock Indicator
  • S200E.MANDT == T148.MANDT
  • S200E.SOBKZ == T148.SOBKZ