SAP ABAP Table LFS_VE_SSTN (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_VE_SSTN	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	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	.INCLUDE	☐				0	0	Vendor Sustainability - Generic parameters
5	OVERALL_RATING	☐	SSTN_OVERALL_SCORE	SSTN_SCORE	INT1	3	0	Overall Score
6	SOCIAL_RATING	☐	SSTN_TOTAL_SOC_RESPONSIBILITY	SSTN_SCORE	INT1	3	0	Social Responsibility Compliance Score
7	ENVIRON_RATING	☐	SSTN_TOTAL_ENVIRONMENTAL	SSTN_SCORE	INT1	3	0	Total Environmental Compliance Score
8	ECONOMIC_RATING	☐	SSTN_TOTAL_ECONOMIC	SSTN_SCORE	INT1	3	0	Total Economic Compliance Score
9	VALIDITY_START	☐	SSTN_VALIDITY_START_DATE	DATUM	DATS	8	0	Validity Start Date
10	VALIDITY_END	☐	SSTN_VALIDITY_END_DATE	DATUM	DATS	8	0	Validity End Date
11	AUDIT_AGENCY	☐	SSTN_AUDIT_AGENCY		CHAR	20	0	Audit Agency
12	AUDIT_CONDUCT_ON	☐	SSTN_AUDIT_CONDUCTED_ON	DATUM	DATS	8	0	Audit Date
13	COMMENTS	☐	SSTN_COMMENTS	TEXT255	CHAR	255	0	Comments
14	ISO_CERTI	☐	SSTN_ISO_CERTIFICATION	TXT40	CHAR	40	0	ISO Certification
15	SUST_REPORT	☐	SSTN_SUST_REPORT		CHAR	50	0	Sustainability Reporting Standard
16	SUST_RPT_RATING	☐	SSTN_REPORT_RATING	SSTN_SCORE	INT1	3	0	Sustainability Reporting Standard Rating
17	SUPP_COC	☐	SSTN_SUPP_COC	SSTN_CODE_OF_CONDUCT_INDICATOR	CHAR	1	0	Supplier Code of Conduct Indicator
18	SUPP_COC_DATE	☐	SSTN_SUPP_COC_DATE	DATUM	DATS	8	0	Supplier Code of Conduct Date
19	DEL_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
20	.INCLUDE	☐				0	0	Vendor Sustainability - Social Parameters
21	HUMAN_RIGHTS	☐	SSTN_HUMAN_RIGHT	SSTN_COMPLIANCE_CODE	CHAR	1	0	Human Rights Compliance Code
22	ANTI_CORRUPTION	☐	SSTN_ANTICORRUPTION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Anti-Corruption Compliance Code
23	CMPL_LBR_DISC	☐	SSTN_DISCRIMINATION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Non-Discrimination Compliance Code
24	CMPL_LBR_POLICY	☐	SSTN_TOTAL_LABOUR_STANDARDS	SSTN_COMPLIANCE_CODE	CHAR	1	0	Labor Standards Compliance Code
25	CMPL_LBR_CHILD	☐	SSTN_CHILD_LABOUR	SSTN_COMPLIANCE_CODE	CHAR	1	0	Child Labor Compliance Code
26	CMPL_LBR_FORCED	☐	SSTN_FORCED_LABOUR	SSTN_COMPLIANCE_CODE	CHAR	1	0	Forced Labor Compliance Code
27	COL_BARGAIN	☐	SSTN_COLLECTIVE_BARGAINING	SSTN_COMPLIANCE_CODE	CHAR	1	0	Right to Collective Bargaining Compliance Code
28	MINOR_OWNED_BUSI	☐	SSTN_MINORITY_OWNED	SSTN_CERTIFIED_COMPANY	CHAR	1	0	Minority-Owned Business (MBE-Certified)
29	WOMEN_OWNED_BUSI	☐	SSTN_WOMEN_OWNED	SSTN_CERTIFIED_COMPANY	CHAR	1	0	Women-Owned Business (WBE-Certified)
30	EMP_COUNT	☐	SSTN_EMP_COUNT	SSTN_EMP_COUNT	NUMC	12	0	Number of Employees
31	.INCLUDE	☐				0	0	Vendor Sustainability - Economic Parameters
32	RAT_FIN_RISK	☐	SSTN_RATING_FIN_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Financial Risk Rating
33	RAT_FIN_PROVIDER	☐	SSTN_RATING_FIN_PROVIDER		CHAR	20	0	Rating Provider
34	RAT_FIN_DATE	☐	SSTN_RATING_FIN_DATE	DATUM	DATS	8	0	Financial Rating Date
35	SUPPLIER_RISK	☐	SSTN_FINANCIAL_SUPPLY_RISK	SSTN_SUPPLY_RISK	CHAR	1	0	Financial Supply Risk Code
36	.INCLUDE	☐				0	0	Vendor Sustainability - Environmental Parameters
37	TTL_ENR_CONS	☐	SSTN_TOTAL_ENERGY_CONSUMED	MENG13	QUAN	13	3	Total Energy Consumption
38	TTL_ENR_CONS_UN	☐	SSTN_TOTAL_ENERGY_CONSUMED_UN	MEINS	UNIT	3	0	Total Energy Consumption Unit	T006
39	RENEWABLE_ENERGY	☐	SSTN_RENEWABLE_ENERGY	MENG13	QUAN	13	3	Renewable Energy
40	RENEW_ENERGY_UN	☐	SSTN_RENEWABLE_ENERGY_UNIT	MEINS	UNIT	3	0	Renewable Energy Unit	T006
41	WATER_CONS	☐	SSTN_WATER_CONSUMPTION	MENG13	QUAN	13	3	Total Water Consumption
42	WATER_CONS_UN	☐	SSTN_WATER_CONSUMPTION_UN	MEINS	UNIT	3	0	Total Water Consumption Unit	T006
43	ENVI_FINE	☐	SSTN_ENVIRONMENT_FINE	WERT7	CURR	13	2	Environmental Fine
44	ENVI_FINE_UN	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
45	EMISSION_REDUC	☐	SSTN_EMISSION_REDUCTION	MENG13	QUAN	13	3	Emission Reduction
46	EMISS_REDUC_UN	☐	SSTN_EMISSION_REDUCTION_UN	MEINS	UNIT	3	0	Emission Reduction Unit	T006
47	GHG_SCOPE1	☐	SSTN_GHG_SCOPE1	MENG13	QUAN	13	3	Direct Emissions
48	GHG_SCOPE1_UN	☐	SSTN_GHG_SCOPE1_UN	MEINS	UNIT	3	0	Direct Emissions Unit	T006
49	GHG_SCOPE2	☐	SSTN_GHG_SCOPE2	MENG13	QUAN	13	3	Indirect Emissions
50	GHG_SCOPE2_UN	☐	SSTN_GHG_SCOPE2_UN	MEINS	UNIT	3	0	Indirect Emissions Unit	T006
51	GHG_SCOPE3	☐	SSTN_GHG_SCOPE3	MENG13	QUAN	13	3	Third-Party Emissions
52	GHG_SCOPE3_UN	☐	SSTN_GHG_SCOPE3_UN	MEINS	UNIT	3	0	Third-Party Emissions Unit	T006
53	WASTE	☐	SSTN_WASTE	MENG13	QUAN	13	3	Waste
54	WASTE_UNIT	☐	SSTN_WASTE_UNIT	MEINS	UNIT	3	0	Total Waste Unit	T006
55	WASTE_RECYCLED	☐	SSTN_WASTE_RECYCLED	MENG13	QUAN	13	3	Total Waste Recycled
56	WASTE_RECYCLD_UN	☐	SSTN_WASTE_RECYCLED_UN	MEINS	UNIT	3	0	Total Waste Recycled Unit	*
57	ENV_PROTECTION	☐	SSTN_ENVIRONMENT_PROTECTION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Protection Compliance Code
58	ENV_RESP	☐	SSTN_ENVIRONMENTAL_RESP	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Responsibility Compliance Code
59	CLEAN_TECHNOLOGY	☐	SSTN_CLEAN_TECHNOLOGY	SSTN_COMPLIANCE_CODE	CHAR	1	0	Clean Technology Compliance Code
60	WASTE_HZD	☐	SSTN_WASTE_HZD	MENG13	QUAN	13	3	Total Hazardous Waste
61	WASTE_HZD_UNIT	☐	SSTN_WASTE_HZD_UNIT	MEINS	UNIT	3	0	Total Hazardous Waste Unit	T006
62	LAST_UPDATED	☐	DATUM	DATUM	DATS	8	0	Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LFS_VE_SSTN	EMISS_REDUC_UN	T006	MSEHI	REF
2	LFS_VE_SSTN	ENVI_FINE_UN	TCURC	WAERS	REF
3	LFS_VE_SSTN	GHG_SCOPE1_UN	T006	MSEHI	REF
4	LFS_VE_SSTN	GHG_SCOPE2_UN	T006	MSEHI	REF
5	LFS_VE_SSTN	GHG_SCOPE3_UN	T006	MSEHI	REF
6	LFS_VE_SSTN	RENEW_ENERGY_UN	T006	MSEHI	REF
7	LFS_VE_SSTN	TTL_ENR_CONS_UN	T006	MSEHI	REF
8	LFS_VE_SSTN	WASTE_HZD_UNIT	T006	MSEHI
9	LFS_VE_SSTN	WASTE_UNIT	T006	MSEHI
10	LFS_VE_SSTN	WATER_CONS_UN	T006	MSEHI	REF

History

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