SAP ABAP Table MGIR_SSTN (Material / Info Record Sustainability table)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MG_SSTN (Package) Material Sustainability

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MGIR_SSTN	Table Relationship Diagram
Short Description	Material / Info Record Sustainability table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	UUID	☑	SSTN_MGIR_UUID	SYSUUID_C	CHAR	32	0	SSTN UUID
3	MATNR_SUST_ID	☐	MATNR_SUST_ID	SSTN_ID	CHAR	12	0	Material Sustainability ID	*
4	CREATED_BY	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
5	CREATED_ON	☐	DATUM	DATUM	DATS	8	0	Date
6	LAST_CHANGED_BY	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
7	LAST_CHANGED_ON	☐	DATUM	DATUM	DATS	8	0	Date
8	.INCLUDE	☐				0	0	Material sustainability generic attributes
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
10	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
11	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
12	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
13	VALIDITY_START	☐	SSTN_MGIR_VAL_START_DATE	DATUM	DATS	8	0	Validity Start Date
14	VALIDITY_END	☐	SSTN_MGIR_VAL_END_DATE	DATUM	DATS	8	0	Validity End Date
15	WERKS_NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
16	DEL_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
17	.INCLUDE	☐				0	0	Material Sustainability Attributes
18	OVERALL_RATING	☐	SSTN_MAT_RATING	SSTN_MAT_PERCENT	NUMC	3	0	Environmental Rating
19	RECYCLED_CONTENT	☐	SSTN_RECYCLED_CONTENT	SSTN_MAT_PERCENT	NUMC	3	0	Recycled Content
20	GHG_SCOPE1	☐	SSTN_MAT_GHGS1	MENG13	QUAN	13	3	Scope 1 Emissions
21	GHG_SCOPE1_UN	☐	SSTN_GHGS1_UNIT	MEINS	UNIT	3	0	Unit for Scope 1 Emissions	T006
22	GHG_SCOPE2	☐	SSTN_MAT_GHGS2	MENG13	QUAN	13	3	Scope 2 Emissions
23	GHG_SCOPE2_UN	☐	SSTN_GHGS2_UNIT	MEINS	UNIT	3	0	Unit For Scope 2 Emissions	T006
24	GHG_SCOPE3	☐	SSTN_MAT_GHGS3	MENG13	QUAN	13	3	Scope 3 Emissions
25	GHG_SCOPE3_UN	☐	SSTN_GHGS3_UNIT	MEINS	UNIT	3	0	Unit for Scope 3 Emissions	T006
26	DIRECT_ENERGY	☐	SSTN_MAT_DIRECT_ENG	MENG13	QUAN	13	3	Energy Consumption
27	DIRECT_ENG_UNIT	☐	SSTN_MAT_DIRECT_ENG_UN	MEINS	UNIT	3	0	Unit for Energy Consumption	T006
28	DIRECT_WATER	☐	SSTN_MAT_WATER_USED	MENG13	QUAN	13	3	Water Consumption
29	DIRECT_WATER_UN	☐	SSTN_MAT_WATER_UNIT	MEINS	UNIT	3	0	Water Consumption Unit	T006
30	DIRECT_WASTE	☐	SSTN_MAT_DIRECT_WASTE	MENG13	QUAN	13	3	Waste Generated
31	DIRECT_WASTE_UN	☐	SSTN_MAT_WASTE_UN	MEINS	UNIT	3	0	Unit for Material Waste Generated	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGIR_SSTN	DIRECT_ENG_UNIT	T006	MSEHI
2	MGIR_SSTN	DIRECT_WASTE_UN	T006	MSEHI
3	MGIR_SSTN	DIRECT_WATER_UN	T006	MSEHI
4	MGIR_SSTN	GHG_SCOPE1_UN	T006	MSEHI
5	MGIR_SSTN	GHG_SCOPE2_UN	T006	MSEHI
6	MGIR_SSTN	GHG_SCOPE3_UN	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in	606