LFSSTN - Sustainability details for Vendor

Sustainability details for Vendor information is stored in SAP table LFSSTN.
It is part of development package FBK_SUST in software component FI-AP-AP. This development package consists of objects that can be grouped under "Sustainability enhancements for Vendor".

Fields for table LFSSTN

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	T000
LIFNR	Account Number of Supplier	X	LIFNR	CHAR	10	LFA1
UUID	SSTN UUID	X	SSTN_UUID	CHAR	32
LIFNR_SUST_ID	Vendor Sustainability ID		LIFNR_SUST_ID	CHAR	12	*
CREATED_BY	User Name		USNAM	CHAR	12	*
CHANGED_BY	User Name		USNAM	CHAR	12	*
CREATED_ON	Date		DATUM	DATS	8
LAST_CHANGED_ON	Date		DATUM	DATS	8
.INCLUDE				SSTN_S_SUSTAINABILITY	0
.INCLUDE	OVERALL			SSTN_S_GENERIC	0
.INCLUDE	BASIC_DATA			SSTN_S_BASIC_DATA	0
VALIDITY_START	Validity Start Date		SSTN_VALIDITY_START_DATE	DATS	8
VALIDITY_END	Validity End Date		SSTN_VALIDITY_END_DATE	DATS	8
AUDIT_AGENCY	Audit Agency		SSTN_AUDIT_AGENCY	CHAR	20
AUDIT_CONDUCT_ON	Audit Date		SSTN_AUDIT_CONDUCTED_ON	DATS	8
SUPP_COC	Supplier Code of Conduct Indicator		SSTN_SUPP_COC	CHAR	1
SUPP_COC_DATE	Supplier Code of Conduct Date		SSTN_SUPP_COC_DATE	DATS	8
SUST_REPORT	Sustainability Reporting Standard		SSTN_SUST_REPORT	CHAR	50
SUST_RPT_RATING	Sustainability Reporting Standard Rating		SSTN_REPORT_RATING	INT1	1
SUST_REPORT_DATE	Last Publication Date of Sustainability Report		SSTN_SUST_REPORT_DATE	DATS	8
DEL_FLAG	Checkbox		XFELD	CHAR	1
.INCLUDE	SCORES			SSTN_S_SCORES	0
OVERALL_SCORE	Overall Score		SSTN_OVERALL_SCORE	INT1	1
TOT_RESP_SCORE	Social Responsibility Compliance Score		SSTN_TOTAL_SOC_RESPONSIBILITY	INT1	1
TOT_ENV_SCORE	Total Environmental Compliance Score		SSTN_TOTAL_ENVIRONMENTAL	INT1	1
TOT_ECO_SCORE	Total Economic Compliance Score		SSTN_TOTAL_ECONOMIC	INT1	1
.INCLUDE	SOCIAL			SSTN_S_SOCIAL	0
SOC_COMMENTS	Comments		SSTN_COMMENTS	CHAR	255
.INCLUDE	SOC_COMPL			SSTN_S_SOCIAL_COMPL	0
SOC_PROC_SYS	Social Compliance Regarding Processes and Systems		SSTN_SOCIAL_PROCESSES_SYSTEMS	CHAR	1
HUMAN_RIGHTS	Human Rights Compliance Code		SSTN_HUMAN_RIGHT	CHAR	1
HEALTH_SAFETY	Health and Safety Compliance Code		SSTN_HEALTH_SAFETY	CHAR	1
SOC_FINES	Fines Paid for Non-Compliance with Social Standards		SSTN_SOCIAL_FINE	CURR	7
SOC_FINES_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	5	*
.INCLUDE	LABOUR			SSTN_S_LABOUR_STANDARDS	0
DISCRIMINATION	Non-Discrimination Compliance Code		SSTN_DISCRIMINATION	CHAR	1
CHILD_LABOUR	Child Labor Compliance Code		SSTN_CHILD_LABOUR	CHAR	1
FORCED_LABOUR	Forced Labor Compliance Code		SSTN_FORCED_LABOUR	CHAR	1
COL_BARGAINING	Right to Collective Bargaining Compliance Code		SSTN_COLLECTIVE_BARGAINING	CHAR	1
.INCLUDE	OTHERS			SSTN_S_SOCIAL_OTHERS	0
ANTI_CORRUPTION	Anti-Corruption Compliance Code		SSTN_ANTICORRUPTION	CHAR	1
WOMEN_OWNED	Women-Owned Business (WBE-Certified)		SSTN_WOMEN_OWNED	CHAR	1
WOM_OWNED_EXP	Expiration Date of a Certificate (WBE/MBE, for ex.)		SSTN_CERTIFICATE_EXPIRE_DATE	DATS	8
MINORITY_OWNED	Minority-Owned Business (MBE-Certified)		SSTN_MINORITY_OWNED	CHAR	1
MIN_OWNED_EXP	Expiration Date of a Certificate (WBE/MBE, for ex.)		SSTN_CERTIFICATE_EXPIRE_DATE	DATS	8
.INCLUDE	ENVIRONMENT			SSTN_S_ENVIRONMENT	0
ENV_COMMENTS	Comments		SSTN_COMMENTS	CHAR	255
.INCLUDE	ENV_COMPL			SSTN_S_ENV_COMPL	0
ENV_PROTECTION	Environmental Protection Compliance Code		SSTN_ENVIRONMENT_PROTECTION	CHAR	1
ENV_INITIATIVES	Environmental Initiatives Compliance Code		SSTN_ENVIRONMENTAL_INITIATIVES	CHAR	1
ENV_TECHNOLOGY	Clean Technology Compliance Code		SSTN_CLEAN_TECHNOLOGY	CHAR	1
ENV_PROC_SYS	Environmental Compliance Regarding Processes and Systems		SSTN_ENVIRON_PROCESSES_SYSTEMS	CHAR	1
ENV_FINES	Environmental Fine		SSTN_ENVIRONMENT_FINE	CURR	7
ENV_FINES_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	5	*
.INCLUDE	CONSUMPTION			SSTN_S_ENV_ENERGY	0
TTL_ENR_CONS	Total Energy Consumption		SSTN_TOTAL_ENERGY_CONSUMED	QUAN	7
TTL_ENR_CONS_UN	Total Energy Consumption Unit		SSTN_TOTAL_ENERGY_CONSUMED_UN	UNIT	3	T006
RENEWABLE_ENERGY	Renewable Energy		SSTN_RENEWABLE_ENERGY	QUAN	7
RENEW_ENERGY_UN	Renewable Energy Unit		SSTN_RENEWABLE_ENERGY_UNIT	UNIT	3	T006
TTL_WATER_CONS	Total Water Consumption		SSTN_WATER_CONSUMPTION	QUAN	7
TTL_WATER_CON_UN	Total Water Consumption Unit		SSTN_WATER_CONSUMPTION_UN	UNIT	3	T006
RECYCLED_WATER	Amount of Water Recycled		SSTN_WATER_RECYCLED	QUAN	7
RECYCL_WATER_UN	Water Recycled Unit		SSTN_WATER_RECYCLED_UN	UNIT	3	T006
.INCLUDE	EMISSION			SSTN_S_ENV_GHG	0
GHG_SCOPE1	Direct Emissions		SSTN_GHG_SCOPE1	QUAN	7
GHG_SCOPE1_UN	Direct Emissions Unit		SSTN_GHG_SCOPE1_UN	UNIT	3	T006
GHG_SCOPE2	Indirect Emissions		SSTN_GHG_SCOPE2	QUAN	7
GHG_SCOPE2_UN	Indirect Emissions Unit		SSTN_GHG_SCOPE2_UN	UNIT	3	T006
GHG_SCOPE3	Third-Party Emissions		SSTN_GHG_SCOPE3	QUAN	7
GHG_SCOPE3_UN	Third-Party Emissions Unit		SSTN_GHG_SCOPE3_UN	UNIT	3	T006
.INCLUDE	WASTE			SSTN_S_ENV_WASTE	0
WASTE_NON_HZD	Total Non-Hazardous Waste		SSTN_WASTE_NON_HZD	QUAN	7
WASTE_NON_HZD_UN	Total Non-Hazardous Waste Unit		SSTN_WASTE_NON_HZD_UNIT	UNIT	3	*
WASTE_HZD	Total Hazardous Waste		SSTN_WASTE_HZD	QUAN	7
WASTE_HZD_UNIT	Total Hazardous Waste Unit		SSTN_WASTE_HZD_UNIT	UNIT	3	T006
WASTE_RECYCLED	Total Waste Recycled		SSTN_WASTE_RECYCLED	QUAN	7
WASTE_RECYCLD_UN	Total Waste Recycled Unit		SSTN_WASTE_RECYCLED_UN	UNIT	3	*
.INCLUDE	ECONOMIC			SSTN_S_ECONOMIC_RISK	0
.INCLUDE	COMPANY			SSTN_S_COMPANY	0
TOTAL_SPEND	Total Spend with Supplier		SSTN_SUPPLIER_TOTAL_SPEND	CURR	8
TOTAL_SPEND_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	5	*
TOTAL_REVENUE	Total Revenue of Supplier		SSTN_SUPPLIER_TOTAL_REVENUE	CURR	8
TOT_REVENUE_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	5	*
EMPLOYEE_COUNT	Number of Employees		SSTN_EMP_COUNT	NUMC	12
.INCLUDE	RISK			SSTN_S_SUPPLY_RISK	0
TOTAL_RISK	Total Supply Risk Code		SSTN_TOTAL_SUPPLY_RISK	CHAR	1
FINANCIAL_RISK	Financial Supply Risk Code		SSTN_FINANCIAL_SUPPLY_RISK	CHAR	1
LOGISTICAL_RISK	Logistics Supply Risk Code		SSTN_LOGISTICAL_SUPPLY_RISK	CHAR	1
QUALITY_RISK	Quality Supply Risk Code		SSTN_QUALITY_SUPPLY_RISK	CHAR	1
POLITICAL_RISK	Political Supply Risk Code		SSTN_POLITICAL_SUPPLY_RISK	CHAR	1
.INCLUDE	EXTENSION			SSTN_S_EXTENSION	0
DUMMY_EEW_SSTN	Dummy function in length 1		DUMMY	CHAR	1
.INCLUDE	CI			CI_S_SSTN_EXTENSION	0