SAP ABAP Table SSTN_MGIR_STY (Used for data passing across application)

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_STY	Table Relationship Diagram
Short Description	Used for data passing across application

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

History

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