S012E

S012 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
EKORG FK Purchasing organization
LIFNR FK Vendor's account number
MATNR FK Material Number
WERKS FK Plant
ESOKZ Purchasing info record category Show values
MATKL FK Material Group
INFNR FK Number of purchasing info record
LAND1 FK Country/Region Key of Supplier
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ESOKZ Purchasing info record category Show values
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 Proportional factor (%) for disaggregation of product group FLTP
Master Data Relations Join Conditions
Base Unit of Measure
  • S012E.MANDT == T006.MANDT
  • S012E.BASME == T006.MSEHI
Purchasing organization
  • S012E.MANDT == T024E.MANDT
  • S012E.EKORG == T024E.EKORG
Local Currency
  • S012E.MANDT == TCURC.MANDT
  • S012E.HWAER == TCURC.WAERS
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • S012E.INFNR == EINA.INFNR
  • S012E.MANDT == EINA.MANDT
Country/Region Key of Supplier
  • Country/Region Key of Supplier
  • Client
  • S012E.LAND1 == T005.LAND1
  • S012E.MANDT == T005.MANDT
Vendor's account number
  • S012E.MANDT == LFA1.MANDT
  • S012E.LIFNR == LFA1.LIFNR
Client S012E.MANDT == T000.MANDT
Material Group
  • S012E.MANDT == T023.MANDT
  • S012E.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S012E.MATNR == MARA.MATNR
  • S012E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S012E.PERIV == T009.PERIV
  • S012E.MANDT == T009.MANDT
Plant
  • S012E.MANDT == T001W.MANDT
  • S012E.WERKS == T001W.WERKS