/SRMSMC/D_S_SUST - Supplier Sustainability Data

Supplier Sustainability Data information is stored in SAP table /SRMSMC/D_S_SUST.
It is part of development package /SRMSMC/FND_MO_BP_BL in software component SLC-SUP. This development package consists of objects that can be grouped under "Package for Business Logic of the BO Business Partner".

Fields for table /SRMSMC/D_S_SUST

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
PARTNER	Key: Supplier ID	X	/SRMSMC/SUPPLIER_ID_KEY	CHAR	20	*
RECORD_GUID	UUID in X form (binary)	X	SYSUUID_X	RAW	16
.INCLUDE				SSTN_S_SUST_CLASS	0
.INCLUDE	SUST			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	16
VALIDITY_END	Validity End Date		SSTN_VALIDITY_END_DATE	DATS	16
AUDIT_AGENCY	Audit Agency		SSTN_AUDIT_AGENCY	CHAR	40
AUDIT_CONDUCT_ON	Audit Date		SSTN_AUDIT_CONDUCTED_ON	DATS	16
SUPP_COC	Supplier Code of Conduct Indicator		SSTN_SUPP_COC	CHAR	2
SUPP_COC_DATE	Supplier Code of Conduct Date		SSTN_SUPP_COC_DATE	DATS	16
SUST_REPORT	Sustainability Reporting Standard		SSTN_SUST_REPORT	CHAR	100
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	16
DEL_FLAG	Checkbox		XFELD	CHAR	2
.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	510
.INCLUDE	SOC_COMPL			SSTN_S_SOCIAL_COMPL	0
SOC_PROC_SYS	Social Compliance Regarding Processes and Systems		SSTN_SOCIAL_PROCESSES_SYSTEMS	CHAR	2
HUMAN_RIGHTS	Human Rights Compliance Code		SSTN_HUMAN_RIGHT	CHAR	2
HEALTH_SAFETY	Health and Safety Compliance Code		SSTN_HEALTH_SAFETY	CHAR	2
SOC_FINES	Fines Paid for Non-Compliance with Social Standards		SSTN_SOCIAL_FINE	CURR	7
SOC_FINES_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	10	*
.INCLUDE	LABOUR			SSTN_S_LABOUR_STANDARDS	0
DISCRIMINATION	Non-Discrimination Compliance Code		SSTN_DISCRIMINATION	CHAR	2
CHILD_LABOUR	Child Labor Compliance Code		SSTN_CHILD_LABOUR	CHAR	2
FORCED_LABOUR	Forced Labor Compliance Code		SSTN_FORCED_LABOUR	CHAR	2
COL_BARGAINING	Right to Collective Bargaining Compliance Code		SSTN_COLLECTIVE_BARGAINING	CHAR	2
.INCLUDE	OTHERS			SSTN_S_SOCIAL_OTHERS	0
ANTI_CORRUPTION	Anti-Corruption Compliance Code		SSTN_ANTICORRUPTION	CHAR	2
WOMEN_OWNED	Women-Owned Business (WBE-Certified)		SSTN_WOMEN_OWNED	CHAR	2
WOM_OWNED_EXP	Expiration Date of a Certificate (WBE/MBE, for ex.)		SSTN_CERTIFICATE_EXPIRE_DATE	DATS	16
MINORITY_OWNED	Minority-Owned Business (MBE-Certified)		SSTN_MINORITY_OWNED	CHAR	2
MIN_OWNED_EXP	Expiration Date of a Certificate (WBE/MBE, for ex.)		SSTN_CERTIFICATE_EXPIRE_DATE	DATS	16
.INCLUDE	ENVIRONMENT			SSTN_S_ENVIRONMENT	0
ENV_COMMENTS	Comments		SSTN_COMMENTS	CHAR	510
.INCLUDE	ENV_COMPL			SSTN_S_ENV_COMPL	0
ENV_PROTECTION	Environmental Protection Compliance Code		SSTN_ENVIRONMENT_PROTECTION	CHAR	2
ENV_INITIATIVES	Environmental Initiatives Compliance Code		SSTN_ENVIRONMENTAL_INITIATIVES	CHAR	2
ENV_TECHNOLOGY	Clean Technology Compliance Code		SSTN_CLEAN_TECHNOLOGY	CHAR	2
ENV_PROC_SYS	Environmental Compliance Regarding Processes and Systems		SSTN_ENVIRON_PROCESSES_SYSTEMS	CHAR	2
ENV_FINES	Environmental Fine		SSTN_ENVIRONMENT_FINE	CURR	7
ENV_FINES_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	10	*
.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	6	T006
RENEWABLE_ENERGY	Renewable Energy		SSTN_RENEWABLE_ENERGY	QUAN	7
RENEW_ENERGY_UN	Renewable Energy Unit		SSTN_RENEWABLE_ENERGY_UNIT	UNIT	6	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	6	T006
RECYCLED_WATER	Amount of Water Recycled		SSTN_WATER_RECYCLED	QUAN	7
RECYCL_WATER_UN	Water Recycled Unit		SSTN_WATER_RECYCLED_UN	UNIT	6	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	6	T006
GHG_SCOPE2	Indirect Emissions		SSTN_GHG_SCOPE2	QUAN	7
GHG_SCOPE2_UN	Indirect Emissions Unit		SSTN_GHG_SCOPE2_UN	UNIT	6	T006
GHG_SCOPE3	Third-Party Emissions		SSTN_GHG_SCOPE3	QUAN	7
GHG_SCOPE3_UN	Third-Party Emissions Unit		SSTN_GHG_SCOPE3_UN	UNIT	6	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	6	*
WASTE_HZD	Total Hazardous Waste		SSTN_WASTE_HZD	QUAN	7
WASTE_HZD_UNIT	Total Hazardous Waste Unit		SSTN_WASTE_HZD_UNIT	UNIT	6	T006
WASTE_RECYCLED	Total Waste Recycled		SSTN_WASTE_RECYCLED	QUAN	7
WASTE_RECYCLD_UN	Total Waste Recycled Unit		SSTN_WASTE_RECYCLED_UN	UNIT	6	*
.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	10	*
TOTAL_REVENUE	Total Revenue of Supplier		SSTN_SUPPLIER_TOTAL_REVENUE	CURR	8
TOT_REVENUE_CURR	Currency		SSTN_SUPPLIER_CURRENCY	CUKY	10	*
EMPLOYEE_COUNT	Number of Employees		SSTN_EMP_COUNT	NUMC	24
.INCLUDE	RISK			SSTN_S_SUPPLY_RISK	0
TOTAL_RISK	Total Supply Risk Code		SSTN_TOTAL_SUPPLY_RISK	CHAR	2
FINANCIAL_RISK	Financial Supply Risk Code		SSTN_FINANCIAL_SUPPLY_RISK	CHAR	2
LOGISTICAL_RISK	Logistics Supply Risk Code		SSTN_LOGISTICAL_SUPPLY_RISK	CHAR	2
QUALITY_RISK	Quality Supply Risk Code		SSTN_QUALITY_SUPPLY_RISK	CHAR	2
POLITICAL_RISK	Political Supply Risk Code		SSTN_POLITICAL_SUPPLY_RISK	CHAR	2
.INCLUDE	EXTENSION			SSTN_S_EXTENSION	0
DUMMY_EEW_SSTN	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE	CI			CI_S_SSTN_EXTENSION	0
.INCLUDE	CLASS			SSTN_S_CLASSIFICATION	0
SUPPLIER_AREA	Supplier Area Grouping Code		SSTN_SUPPLIER_AREA_GROUPING	CHAR	8	*
SUPPLIER_ORIGIN	Supplier Origin Type Code		SSTN_SUPPLIER_ORIGIN_TYPE	CHAR	8	*
EVALUATION_SCORE	Evaluation Score (0 to 100; Manually Assigned to Suppliers)		SSTN_MANUAL_EVALUATION_SCORE	INT1	1
STRAT_IMPORTANCE	Strategic Importance Code		SSTN_STRATEGIC_IMPORTANCE	CHAR	2
PREFERRED_SUPPL	Preferred Supplier Indicator		SSTN_PREFERRED_SUPPLIER_IND	CHAR	2
STRAT_PARTNER	Strategic Partnership Indicator		SSTN_STRATEGIC_PARTNER_IND	CHAR	2
QUALIFICATION	Supplier Qualification Level Code		SSTN_QUALIFICATION_LEVEL	CHAR	2
DEPENDENCY_RATIO	Dependency Ratio		SSTN_DEPENDENCY_RATIO	DEC	3