MGIR_SSTN - Material / Info Record Sustainability table

Material / Info Record Sustainability table information is stored in SAP table MGIR_SSTN.
It is part of development package MG_SSTN in software component LO-MD-MM. This development package consists of objects that can be grouped under "Material Sustainability".

Fields for table MGIR_SSTN

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
UUID	SSTN UUID	X	SSTN_MGIR_UUID	CHAR	64
MATNR_SUST_ID	Material Sustainability ID		MATNR_SUST_ID	CHAR	24	*
CREATED_BY	User Name		USNAM	CHAR	24	*
CREATED_ON	Date		DATUM	DATS	16
LAST_CHANGED_BY	User Name		USNAM	CHAR	24	*
LAST_CHANGED_ON	Date		DATUM	DATS	16
.INCLUDE				SSTN_MGIR_ID_STY	0
MATNR	Material Number		MATNR	CHAR	80	*
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	*
WERKS	Plant		EWERK	CHAR	8	*
EKORG	Purchasing organization		EKORG	CHAR	8	*
VALIDITY_START	Validity Start Date		SSTN_MGIR_VAL_START_DATE	DATS	16
VALIDITY_END	Validity End Date		SSTN_MGIR_VAL_END_DATE	DATS	16
WERKS_NAME	Name 1		AD_NAME1	CHAR	80
DEL_FLAG	Checkbox		XFELD	CHAR	2
.INCLUDE				SSTN_MGIR_DETAIL_STY	0
OVERALL_RATING	Environmental Rating		SSTN_MAT_RATING	NUMC	6
RECYCLED_CONTENT	Recycled Content		SSTN_RECYCLED_CONTENT	NUMC	6
GHG_SCOPE1	Scope 1 Emissions		SSTN_MAT_GHGS1	QUAN	7
GHG_SCOPE1_UN	Unit for Scope 1 Emissions		SSTN_GHGS1_UNIT	UNIT	6	T006
GHG_SCOPE2	Scope 2 Emissions		SSTN_MAT_GHGS2	QUAN	7
GHG_SCOPE2_UN	Unit For Scope 2 Emissions		SSTN_GHGS2_UNIT	UNIT	6	T006
GHG_SCOPE3	Scope 3 Emissions		SSTN_MAT_GHGS3	QUAN	7
GHG_SCOPE3_UN	Unit for Scope 3 Emissions		SSTN_GHGS3_UNIT	UNIT	6	T006
DIRECT_ENERGY	Energy Consumption		SSTN_MAT_DIRECT_ENG	QUAN	7
DIRECT_ENG_UNIT	Unit for Energy Consumption		SSTN_MAT_DIRECT_ENG_UN	UNIT	6	T006
DIRECT_WATER	Water Consumption		SSTN_MAT_WATER_USED	QUAN	7
DIRECT_WATER_UN	Water Consumption Unit		SSTN_MAT_WATER_UNIT	UNIT	6	T006
DIRECT_WASTE	Waste Generated		SSTN_MAT_DIRECT_WASTE	QUAN	7
DIRECT_WASTE_UN	Unit for Material Waste Generated		SSTN_MAT_WASTE_UN	UNIT	6	T006