MGIR_SSTN

Material / Info Record Sustainability table | #masterdata | Component: Material Master
Column Name Description
MANDT Client
UUID SSTN UUID
Column Name Description
Column Name Description
📏 Unit for Scope 1 Emissions (GHG_SCOPE1_UN):
GHG_SCOPE1 Scope 1 Emissions
📏 Unit For Scope 2 Emissions (GHG_SCOPE2_UN):
GHG_SCOPE2 Scope 2 Emissions
📏 Unit for Scope 3 Emissions (GHG_SCOPE3_UN):
GHG_SCOPE3 Scope 3 Emissions
📏 Unit for Energy Consumption (DIRECT_ENG_UNIT):
DIRECT_ENERGY Energy Consumption
📏 Water Consumption Unit (DIRECT_WATER_UN):
DIRECT_WATER Water Consumption
📏 Unit for Material Waste Generated (DIRECT_WASTE_UN):
DIRECT_WASTE Waste Generated
Column Name Description
CREATED_ON Date
LAST_CHANGED_ON Date
VALIDITY_START Validity Start Date
VALIDITY_END Validity End Date
Column Name Description
DEL_FLAG Checkbox Show values
Column Name Description Domain name
MATNR_SUST_ID Material Sustainability ID SSTN_ID
CREATED_BY User Name XUBNAME
LAST_CHANGED_BY User Name XUBNAME
MATNR Material Number MATNR
LIFNR Account Number of Supplier LIFNR
WERKS Plant WERKS
EKORG Purchasing organization EKORG
WERKS_NAME Name 1 TEXT40
OVERALL_RATING Environmental Rating SSTN_MAT_PERCENT
RECYCLED_CONTENT Recycled Content SSTN_MAT_PERCENT
Master Data Relations Join Conditions
Unit for Energy Consumption
  • MGIR_SSTN.MANDT == T006.MANDT
  • MGIR_SSTN.DIRECT_ENG_UNIT == T006.MSEHI
Unit for Material Waste Generated
  • MGIR_SSTN.MANDT == T006.MANDT
  • MGIR_SSTN.DIRECT_WASTE_UN == T006.MSEHI
Water Consumption Unit
  • MGIR_SSTN.MANDT == T006.MANDT
  • MGIR_SSTN.DIRECT_WATER_UN == T006.MSEHI
Unit for Scope 1 Emissions
  • MGIR_SSTN.MANDT == T006.MANDT
  • MGIR_SSTN.GHG_SCOPE1_UN == T006.MSEHI
Unit For Scope 2 Emissions
  • MGIR_SSTN.MANDT == T006.MANDT
  • MGIR_SSTN.GHG_SCOPE2_UN == T006.MSEHI
Unit for Scope 3 Emissions
  • MGIR_SSTN.MANDT == T006.MANDT
  • MGIR_SSTN.GHG_SCOPE3_UN == T006.MSEHI