SAP ABAP Table LFS_SSTN_ALV (Vendor Master Sustainability Fields)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AP-AP (Application Component) Basic Functions
     ⤷ FBK_SUST (Package) Sustainability enhancements for Vendor

Basic Data

Table Category	INTTAB	Structure
Structure	LFS_SSTN_ALV	Table Relationship Diagram
Short Description	Vendor Master Sustainability Fields

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	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
2	ERNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
3	UUID	☐	SSTN_UUID	SYSUUID_C	CHAR	32	0	SSTN UUID
4	CREATED_BY	☐	CREATEDBY	USNAM	CHAR	12	0	Created By
5	CHANGED_BY	☐	CHANGD_BY	USNAM	CHAR	12	0	Changed By
6	CREATED_ON	☐	CREATED_ON	DATUM	DATS	8	0	Created On
7	LAST_CHANGED_ON	☐	CHANGED_ON	DATUM	DATS	8	0	Last Changed On
8	.INCLUDE	☐				0	0	Overall list of sustainability attributes
9	.INCLUDE	☐				0	0	Sustainability Generic Fields
10	.INCLUDE	☐				0	0	Basic data of the general structure
11	VALIDITY_START	☐	SSTN_VALIDITY_START_DATE	DATUM	DATS	8	0	Validity Start Date
12	VALIDITY_END	☐	SSTN_VALIDITY_END_DATE	DATUM	DATS	8	0	Validity End Date
13	AUDIT_AGENCY	☐	SSTN_AUDIT_AGENCY		CHAR	20	0	Audit Agency
14	AUDIT_CONDUCT_ON	☐	SSTN_AUDIT_CONDUCTED_ON	DATUM	DATS	8	0	Audit Date
15	SUPP_COC	☐	SSTN_SUPP_COC	SSTN_CODE_OF_CONDUCT_INDICATOR	CHAR	1	0	Supplier Code of Conduct Indicator
16	SUPP_COC_DATE	☐	SSTN_SUPP_COC_DATE	DATUM	DATS	8	0	Supplier Code of Conduct Date
17	SUST_REPORT	☐	SSTN_SUST_REPORT		CHAR	50	0	Sustainability Reporting Standard
18	SUST_RPT_RATING	☐	SSTN_REPORT_RATING	SSTN_SCORE	INT1	3	0	Sustainability Reporting Standard Rating
19	SUST_REPORT_DATE	☐	SSTN_SUST_REPORT_DATE	DATS	DATS	8	0	Last Publication Date of Sustainability Report
20	DEL_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
21	.INCLUDE	☐				0	0	Score related part of the general structure
22	OVERALL_SCORE	☐	SSTN_OVERALL_SCORE	SSTN_SCORE	INT1	3	0	Overall Score
23	TOT_RESP_SCORE	☐	SSTN_TOTAL_SOC_RESPONSIBILITY	SSTN_SCORE	INT1	3	0	Social Responsibility Compliance Score
24	TOT_ENV_SCORE	☐	SSTN_TOTAL_ENVIRONMENTAL	SSTN_SCORE	INT1	3	0	Total Environmental Compliance Score
25	TOT_ECO_SCORE	☐	SSTN_TOTAL_ECONOMIC	SSTN_SCORE	INT1	3	0	Total Economic Compliance Score
26	.INCLUDE	☐				0	0	Social compliance attributes of a supplier
27	SOC_COMMENTS	☐	SSTN_SOC_COMMENTS	TEXT255	CHAR	255	0	Social Comments
28	.INCLUDE	☐				0	0	Social compliance
29	SOC_PROC_SYS	☐	SSTN_SOCIAL_PROCESSES_SYSTEMS	SSTN_COMPLIANCE_CODE	CHAR	1	0	Social Compliance Regarding Processes and Systems
30	HUMAN_RIGHTS	☐	SSTN_HUMAN_RIGHT	SSTN_COMPLIANCE_CODE	CHAR	1	0	Human Rights Compliance Code
31	HEALTH_SAFETY	☐	SSTN_HEALTH_SAFETY	SSTN_COMPLIANCE_CODE	CHAR	1	0	Health and Safety Compliance Code
32	SOC_FINES	☐	SSTN_SOCIAL_FINE	WERT7	CURR	13	2	Fines Paid for Non-Compliance with Social Standards
33	SOC_FINES_CURR	☐	SSTN_SOCIAL_FINE_CUR	WAERS	CUKY	5	0	Social Fine Currency	*
34	.INCLUDE	☐				0	0	Labour Standards Compliance
35	DISCRIMINATION	☐	SSTN_DISCRIMINATION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Non-Discrimination Compliance Code
36	CHILD_LABOUR	☐	SSTN_CHILD_LABOUR	SSTN_COMPLIANCE_CODE	CHAR	1	0	Child Labor Compliance Code
37	FORCED_LABOUR	☐	SSTN_FORCED_LABOUR	SSTN_COMPLIANCE_CODE	CHAR	1	0	Forced Labor Compliance Code
38	COL_BARGAINING	☐	SSTN_COLLECTIVE_BARGAINING	SSTN_COMPLIANCE_CODE	CHAR	1	0	Right to Collective Bargaining Compliance Code
39	.INCLUDE	☐				0	0	Other social compliance attributes
40	ANTI_CORRUPTION	☐	SSTN_ANTICORRUPTION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Anti-Corruption Compliance Code
41	WOMEN_OWNED	☐	SSTN_WOMEN_OWNED	SSTN_CERTIFIED_COMPANY	CHAR	1	0	Women-Owned Business (WBE-Certified)
42	WOM_OWNED_EXP	☐	SSTN_WOM_CERT_EXPIRE_DATE	DATS	DATS	8	0	Women Owned Expiration Date of a Certificate
43	MINORITY_OWNED	☐	SSTN_MINORITY_OWNED	SSTN_CERTIFIED_COMPANY	CHAR	1	0	Minority-Owned Business (MBE-Certified)
44	MIN_OWNED_EXP	☐	SSTN_CERTIFICATE_EXPIRE_DATE	DATS	DATS	8	0	Expiration Date of a Certificate (WBE/MBE, for ex.)
45	.INCLUDE	☐				0	0	Environmental Compliance
46	ENV_COMMENTS	☐	SSTN_ENV_COMMENTS	TEXT255	CHAR	255	0	Environmental Comments
47	.INCLUDE	☐				0	0	Environmental compliance attributes
48	ENV_PROTECTION	☐	SSTN_ENVIRONMENT_PROTECTION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Protection Compliance Code
49	ENV_INITIATIVES	☐	SSTN_ENVIRONMENTAL_INITIATIVES	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Initiatives Compliance Code
50	ENV_TECHNOLOGY	☐	SSTN_CLEAN_TECHNOLOGY	SSTN_COMPLIANCE_CODE	CHAR	1	0	Clean Technology Compliance Code
51	ENV_PROC_SYS	☐	SSTN_ENVIRON_PROCESSES_SYSTEMS	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Compliance Regarding Processes and Systems
52	ENV_FINES	☐	SSTN_ENVIRONMENT_FINE	WERT7	CURR	13	2	Environmental Fine
53	ENV_FINES_CURR	☐	SSTN_ENV_FINE_CUR	WAERS	CUKY	5	0	Environmental Fine Currency	*
54	.INCLUDE	☐				0	0	Sustainability Energy Attributes
55	TTL_ENR_CONS	☐	SSTN_TOTAL_ENERGY_CONSUMED	MENG13	QUAN	13	3	Total Energy Consumption
56	TTL_ENR_CONS_UN	☐	SSTN_TOTAL_ENERGY_CONSUMED_UN	MEINS	UNIT	3	0	Total Energy Consumption Unit	T006
57	RENEWABLE_ENERGY	☐	SSTN_RENEWABLE_ENERGY	MENG13	QUAN	13	3	Renewable Energy
58	RENEW_ENERGY_UN	☐	SSTN_RENEWABLE_ENERGY_UNIT	MEINS	UNIT	3	0	Renewable Energy Unit	T006
59	TTL_WATER_CONS	☐	SSTN_WATER_CONSUMPTION	MENG13	QUAN	13	3	Total Water Consumption
60	TTL_WATER_CON_UN	☐	SSTN_WATER_CONSUMPTION_UN	MEINS	UNIT	3	0	Total Water Consumption Unit	T006
61	RECYCLED_WATER	☐	SSTN_WATER_RECYCLED	MENG13	QUAN	13	3	Amount of Water Recycled
62	RECYCL_WATER_UN	☐	SSTN_WATER_RECYCLED_UN	MEINS	UNIT	3	0	Water Recycled Unit	T006
63	.INCLUDE	☐				0	0	Sustainability Fields Related to GHG scope attributes
64	GHG_SCOPE1	☐	SSTN_GHG_SCOPE1	MENG13	QUAN	13	3	Direct Emissions
65	GHG_SCOPE1_UN	☐	SSTN_GHG_SCOPE1_UN	MEINS	UNIT	3	0	Direct Emissions Unit	T006
66	GHG_SCOPE2	☐	SSTN_GHG_SCOPE2	MENG13	QUAN	13	3	Indirect Emissions
67	GHG_SCOPE2_UN	☐	SSTN_GHG_SCOPE2_UN	MEINS	UNIT	3	0	Indirect Emissions Unit	T006
68	GHG_SCOPE3	☐	SSTN_GHG_SCOPE3	MENG13	QUAN	13	3	Third-Party Emissions
69	GHG_SCOPE3_UN	☐	SSTN_GHG_SCOPE3_UN	MEINS	UNIT	3	0	Third-Party Emissions Unit	T006
70	.INCLUDE	☐				0	0	Sustainability Fields Related to waste abd recycled products
71	WASTE_NON_HZD	☐	SSTN_WASTE_NON_HZD	MENG13	QUAN	13	3	Total Non-Hazardous Waste
72	WASTE_NON_HZD_UN	☐	SSTN_WASTE_NON_HZD_UNIT	MEINS	UNIT	3	0	Total Non-Hazardous Waste Unit	*
73	WASTE_HZD	☐	SSTN_WASTE_HZD	MENG13	QUAN	13	3	Total Hazardous Waste
74	WASTE_HZD_UNIT	☐	SSTN_WASTE_HZD_UNIT	MEINS	UNIT	3	0	Total Hazardous Waste Unit	T006
75	WASTE_RECYCLED	☐	SSTN_WASTE_RECYCLED	MENG13	QUAN	13	3	Total Waste Recycled
76	WASTE_RECYCLD_UN	☐	SSTN_WASTE_RECYCLED_UN	MEINS	UNIT	3	0	Total Waste Recycled Unit	*
77	.INCLUDE	☐				0	0	Suppliers sustainability attributes: economic & risk related
78	.INCLUDE	☐				0	0	Company related part of the economic and risk data
79	TOTAL_SPEND	☐	SSTN_SUPPLIER_TOTAL_SPEND	WERT15	CURR	15	2	Total Spend with Supplier
80	TOTAL_SPEND_CURR	☐	SSTN_TOT_SPEND_CURRENCY	WAERS	CUKY	5	0	Total Spend Currency	*
81	TOTAL_REVENUE	☐	SSTN_SUPPLIER_TOTAL_REVENUE	WERT15	CURR	15	2	Total Revenue of Supplier
82	TOT_REVENUE_CURR	☐	SSTN_SUPPLIER_CURRENCY	WAERS	CUKY	5	0	Currency	*
83	EMPLOYEE_COUNT	☐	SSTN_EMP_COUNT	SSTN_EMP_COUNT	NUMC	12	0	Number of Employees
84	.INCLUDE	☐				0	0	Supply Risk
85	TOTAL_RISK	☐	SSTN_TOTAL_SUPPLY_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Total Supply Risk Code
86	FINANCIAL_RISK	☐	SSTN_FINANCIAL_SUPPLY_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Financial Supply Risk Code
87	LOGISTICAL_RISK	☐	SSTN_LOGISTICAL_SUPPLY_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Logistics Supply Risk Code
88	QUALITY_RISK	☐	SSTN_QUALITY_SUPPLY_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Quality Supply Risk Code
89	POLITICAL_RISK	☐	SSTN_POLITICAL_SUPPLY_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Political Supply Risk Code
90	.INCLUDE	☐				0	0	Extension Include for Sustainability / Classification Data
91	DUMMY_EEW_SSTN	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
92	.INCLUDE	☐				0	0
93	.INCLUDE	☐				0	0	Text fields of ALV structure
94	HUMAN_RT_TEXT	☐	SSTN_HUMAN_RT_TEXT		CHAR	60	0	Human Rights Description
95	DISCRI_TEXT	☐	SSTN_DISCRI_TEXT		CHAR	60	0	Discrimination Description
96	CHILD_LAB_TEXT	☐	SSTN_CHILD_TEXT		CHAR	60	0	Child Labor Description
97	FORCED_LAB_TEXT	☐	SSTN_FORCED_TEXT		CHAR	60	0	Forced Labor Description
98	COL_BARGAIN_TEXT	☐	SSTN_COL_BARGAIN_TEXT		CHAR	60	0	Collective Bargain Description
99	WOMEN_OWNED_TEXT	☐	SSTN_WOMEN_OWNED_TEXT		CHAR	60	0	Women-Owned Business Description
100	MINOR_OWNED_TEXT	☐	SSTN_MINOR_OWNED_TEXT		CHAR	60	0	Minority-Owned Business Description
101	ANTI_CORR_TEXT	☐	SSTN_ANTICORR_TEXT		CHAR	60	0	Anti-Corruption Description
102	ENV_PROTECTION_TEXT	☐	SSTN_ENV_TEXT		CHAR	60	0	Environmental Protection Description
103	ENV_PROC_TEXT	☐	SSTN_PROC_TEXT		CHAR	60	0	Environmental Processes and Systems
104	ENV_INIT_TEXT	☐	SSTN_ENV_INIT_TEXT		CHAR	60	0	Environmental Initiatives
105	ENV_TECH_TEXT	☐	SSTN_ENV_FRI_TEXT		CHAR	60	0	Environmentally Friendly Technology Description
106	NAME1	☐	SSTN_LIFNR_NAME		CHAR	35	0	Vendor Name
107	TOTAL_RISK_TEXT	☐	SSTN_TOT_RISK_TEXT		CHAR	60	0	Total Supply Risk
108	FIN_RISK_TEXT	☐	SSTN_FIN_RISK_TEXT		CHAR	60	0	Financial Risk Rating Description
109	LOGISTIC_RISK_TEXT	☐	SSTN_LOGI_RISK_TEXT		CHAR	60	0	Logistics Risk Description
110	QUALITY_RISK_TEXT	☐	SSTN_QUALITY_TEXT		CHAR	60	0	Quality Risk Description
111	POLITIC_RISK_TEXT	☐	SSTN_POLITIC_TEXT		CHAR	60	0	Political Risk Description
112	SOC_PROCESS_TEXT	☐	SSTN_SOC_PROCESS		CHAR	60	0	Social Processes and Systems
113	HEALTH_SAFE_TEXT	☐	SSTN_HEALTH_TEXT		CHAR	60	0	Health and Safety Compliance

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LFS_SSTN_ALV	GHG_SCOPE1_UN	T006	MSEHI	REF
2	LFS_SSTN_ALV	GHG_SCOPE2_UN	T006	MSEHI	REF
3	LFS_SSTN_ALV	GHG_SCOPE3_UN	T006	MSEHI	REF
4	LFS_SSTN_ALV	RECYCL_WATER_UN	T006	MSEHI
5	LFS_SSTN_ALV	RENEW_ENERGY_UN	T006	MSEHI	REF
6	LFS_SSTN_ALV	TTL_ENR_CONS_UN	T006	MSEHI	REF
7	LFS_SSTN_ALV	TTL_WATER_CON_UN	T006	MSEHI
8	LFS_SSTN_ALV	WASTE_HZD_UNIT	T006	MSEHI

History

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