SAP ABAP Table SSTN_MGIR_EXT (Ext Structure Vendor Material Sustainability Attributes)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	SSTN_MGIR_EXT	Table Relationship Diagram
Short Description	Ext Structure Vendor Material Sustainability Attributes

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Used for data passing across application
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
32	.INCLUDE	☐				0	0	Material Sustainability Ecolabel Attributes
33	ECOLABEL_ID_PRE	☐	SSTN_ECOLABEL_ID_PRE	SSTN_MAT_ECOLABEL1	CHAR	15	0	Certificate Name	SSTN_ECOLABEL
34	ECOLABEL_RAT_PRE	☐	SSTN_ECOLABEL_RATING_PRE	SSTN_ECO_RATING	CHAR	10	0	Certificate Rating	SSTN_ECORATING
35	ECOLABEL_ID_SEC	☐	SSTN_ECOLABEL_ID_SEC	SSTN_MAT_ECOLABEL1	CHAR	15	0	Secondary Certificate	SSTN_ECOLABEL
36	ECOLABEL_RAT_SEC	☐	SSTN_ECOLABEL_RATING_SEC	SSTN_ECO_RATING	CHAR	10	0	Certificate Rating	SSTN_ECORATING

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SSTN_MGIR_EXT	DIRECT_ENG_UNIT	T006	MSEHI
2	SSTN_MGIR_EXT	DIRECT_WASTE_UN	T006	MSEHI
3	SSTN_MGIR_EXT	DIRECT_WATER_UN	T006	MSEHI
4	SSTN_MGIR_EXT	ECOLABEL_ID_PRE	SSTN_ECOLABEL	ECOLABEL_ID
5	SSTN_MGIR_EXT	ECOLABEL_ID_SEC	SSTN_ECOLABEL	ECOLABEL_ID
6	SSTN_MGIR_EXT	ECOLABEL_RAT_PRE	SSTN_ECORATING	ECO_RATING_ID
7	SSTN_MGIR_EXT	ECOLABEL_RAT_SEC	SSTN_ECORATING	ECO_RATING_ID
8	SSTN_MGIR_EXT	GHG_SCOPE1_UN	T006	MSEHI
9	SSTN_MGIR_EXT	GHG_SCOPE2_UN	T006	MSEHI
10	SSTN_MGIR_EXT	GHG_SCOPE3_UN	T006	MSEHI

History

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