SAP ABAP Table SSTN_MGIR_STY_ALV (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_ALV	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_UUID	SYSUUID_C	CHAR	32	0	SSTN UUID
2	.INCLUDE	☐				0	0	Material sustainability generic attributes
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
4	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
5	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
6	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
7	VALIDITY_START	☐	SSTN_MGIR_VAL_START_DATE	DATUM	DATS	8	0	Validity Start Date
8	VALIDITY_END	☐	SSTN_MGIR_VAL_END_DATE	DATUM	DATS	8	0	Validity End Date
9	WERKS_NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
10	DEL_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
11	.INCLUDE	☐				0	0	Material Sustainability Attributes
12	OVERALL_RATING	☐	SSTN_MAT_RATING	SSTN_MAT_PERCENT	NUMC	3	0	Environmental Rating
13	RECYCLED_CONTENT	☐	SSTN_RECYCLED_CONTENT	SSTN_MAT_PERCENT	NUMC	3	0	Recycled Content
14	GHG_SCOPE1	☐	SSTN_MAT_GHGS1	MENG13	QUAN	13	3	Scope 1 Emissions
15	GHG_SCOPE1_UN	☐	SSTN_GHGS1_UNIT	MEINS	UNIT	3	0	Unit for Scope 1 Emissions	T006
16	GHG_SCOPE2	☐	SSTN_MAT_GHGS2	MENG13	QUAN	13	3	Scope 2 Emissions
17	GHG_SCOPE2_UN	☐	SSTN_GHGS2_UNIT	MEINS	UNIT	3	0	Unit For Scope 2 Emissions	T006
18	GHG_SCOPE3	☐	SSTN_MAT_GHGS3	MENG13	QUAN	13	3	Scope 3 Emissions
19	GHG_SCOPE3_UN	☐	SSTN_GHGS3_UNIT	MEINS	UNIT	3	0	Unit for Scope 3 Emissions	T006
20	DIRECT_ENERGY	☐	SSTN_MAT_DIRECT_ENG	MENG13	QUAN	13	3	Energy Consumption
21	DIRECT_ENG_UNIT	☐	SSTN_MAT_DIRECT_ENG_UN	MEINS	UNIT	3	0	Unit for Energy Consumption	T006
22	DIRECT_WATER	☐	SSTN_MAT_WATER_USED	MENG13	QUAN	13	3	Water Consumption
23	DIRECT_WATER_UN	☐	SSTN_MAT_WATER_UNIT	MEINS	UNIT	3	0	Water Consumption Unit	T006
24	DIRECT_WASTE	☐	SSTN_MAT_DIRECT_WASTE	MENG13	QUAN	13	3	Waste Generated
25	DIRECT_WASTE_UN	☐	SSTN_MAT_WASTE_UN	MEINS	UNIT	3	0	Unit for Material Waste Generated	T006
26	.INCLUDE	☐				0	0	Material Sustainability Ecolabel Attributes
27	ECOLABEL_ID_PRE	☐	SSTN_ECOLABEL_ID_PRE	SSTN_MAT_ECOLABEL1	CHAR	15	0	Certificate Name	SSTN_ECOLABEL
28	ECOLABEL_RAT_PRE	☐	SSTN_ECOLABEL_RATING_PRE	SSTN_ECO_RATING	CHAR	10	0	Certificate Rating	SSTN_ECORATING
29	ECOLABEL_ID_SEC	☐	SSTN_ECOLABEL_ID_SEC	SSTN_MAT_ECOLABEL1	CHAR	15	0	Secondary Certificate	SSTN_ECOLABEL
30	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_STY_ALV	DIRECT_ENG_UNIT	T006	MSEHI
2	SSTN_MGIR_STY_ALV	DIRECT_WASTE_UN	T006	MSEHI
3	SSTN_MGIR_STY_ALV	DIRECT_WATER_UN	T006	MSEHI
4	SSTN_MGIR_STY_ALV	ECOLABEL_ID_PRE	SSTN_ECOLABEL	ECOLABEL_ID
5	SSTN_MGIR_STY_ALV	ECOLABEL_ID_SEC	SSTN_ECOLABEL	ECOLABEL_ID
6	SSTN_MGIR_STY_ALV	ECOLABEL_RAT_PRE	SSTN_ECORATING	ECO_RATING_ID
7	SSTN_MGIR_STY_ALV	ECOLABEL_RAT_SEC	SSTN_ECORATING	ECO_RATING_ID
8	SSTN_MGIR_STY_ALV	GHG_SCOPE1_UN	T006	MSEHI
9	SSTN_MGIR_STY_ALV	GHG_SCOPE2_UN	T006	MSEHI
10	SSTN_MGIR_STY_ALV	GHG_SCOPE3_UN	T006	MSEHI

History

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