SAP ABAP Table LFS_SSTN_TREND_ENVIRONMENTAL (Trend anlysis structure)

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_TREND_ENVIRONMENTAL	Table Relationship Diagram
Short Description	Trend anlysis structure

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	.INCLUDE	☐				0	0	Vendor Master Sustainability Fields UI for Generic data
2	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
3	UUID	☐	SSTN_UUID	SYSUUID_C	CHAR	32	0	SSTN UUID
4	.INCLUDE	☐				0	0	Environmental Compliance
5	ENV_COMMENTS	☐	SSTN_COMMENTS	TEXT255	CHAR	255	0	Comments
6	.INCLUDE	☐				0	0	Environmental compliance attributes
7	ENV_PROTECTION	☐	SSTN_ENVIRONMENT_PROTECTION	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Protection Compliance Code
8	ENV_INITIATIVES	☐	SSTN_ENVIRONMENTAL_INITIATIVES	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Initiatives Compliance Code
9	ENV_TECHNOLOGY	☐	SSTN_CLEAN_TECHNOLOGY	SSTN_COMPLIANCE_CODE	CHAR	1	0	Clean Technology Compliance Code
10	ENV_PROC_SYS	☐	SSTN_ENVIRON_PROCESSES_SYSTEMS	SSTN_COMPLIANCE_CODE	CHAR	1	0	Environmental Compliance Regarding Processes and Systems
11	ENV_FINES	☐	SSTN_ENVIRONMENT_FINE	WERT7	CURR	13	2	Environmental Fine
12	ENV_FINES_CURR	☐	SSTN_SUPPLIER_CURRENCY	WAERS	CUKY	5	0	Currency	*
13	.INCLUDE	☐				0	0	Sustainability Energy Attributes
14	TTL_ENR_CONS	☐	SSTN_TOTAL_ENERGY_CONSUMED	MENG13	QUAN	13	3	Total Energy Consumption
15	TTL_ENR_CONS_UN	☐	SSTN_TOTAL_ENERGY_CONSUMED_UN	MEINS	UNIT	3	0	Total Energy Consumption Unit	T006
16	RENEWABLE_ENERGY	☐	SSTN_RENEWABLE_ENERGY	MENG13	QUAN	13	3	Renewable Energy
17	RENEW_ENERGY_UN	☐	SSTN_RENEWABLE_ENERGY_UNIT	MEINS	UNIT	3	0	Renewable Energy Unit	T006
18	TTL_WATER_CONS	☐	SSTN_WATER_CONSUMPTION	MENG13	QUAN	13	3	Total Water Consumption
19	TTL_WATER_CON_UN	☐	SSTN_WATER_CONSUMPTION_UN	MEINS	UNIT	3	0	Total Water Consumption Unit	T006
20	RECYCLED_WATER	☐	SSTN_WATER_RECYCLED	MENG13	QUAN	13	3	Amount of Water Recycled
21	RECYCL_WATER_UN	☐	SSTN_WATER_RECYCLED_UN	MEINS	UNIT	3	0	Water Recycled Unit	T006
22	.INCLUDE	☐				0	0	Sustainability Fields Related to GHG scope attributes
23	GHG_SCOPE1	☐	SSTN_GHG_SCOPE1	MENG13	QUAN	13	3	Direct Emissions
24	GHG_SCOPE1_UN	☐	SSTN_GHG_SCOPE1_UN	MEINS	UNIT	3	0	Direct Emissions Unit	T006
25	GHG_SCOPE2	☐	SSTN_GHG_SCOPE2	MENG13	QUAN	13	3	Indirect Emissions
26	GHG_SCOPE2_UN	☐	SSTN_GHG_SCOPE2_UN	MEINS	UNIT	3	0	Indirect Emissions Unit	T006
27	GHG_SCOPE3	☐	SSTN_GHG_SCOPE3	MENG13	QUAN	13	3	Third-Party Emissions
28	GHG_SCOPE3_UN	☐	SSTN_GHG_SCOPE3_UN	MEINS	UNIT	3	0	Third-Party Emissions Unit	T006
29	.INCLUDE	☐				0	0	Sustainability Fields Related to waste abd recycled products
30	WASTE_NON_HZD	☐	SSTN_WASTE_NON_HZD	MENG13	QUAN	13	3	Total Non-Hazardous Waste
31	WASTE_NON_HZD_UN	☐	SSTN_WASTE_NON_HZD_UNIT	MEINS	UNIT	3	0	Total Non-Hazardous Waste Unit	*
32	WASTE_HZD	☐	SSTN_WASTE_HZD	MENG13	QUAN	13	3	Total Hazardous Waste
33	WASTE_HZD_UNIT	☐	SSTN_WASTE_HZD_UNIT	MEINS	UNIT	3	0	Total Hazardous Waste Unit	T006
34	WASTE_RECYCLED	☐	SSTN_WASTE_RECYCLED	MENG13	QUAN	13	3	Total Waste Recycled
35	WASTE_RECYCLD_UN	☐	SSTN_WASTE_RECYCLED_UN	MEINS	UNIT	3	0	Total Waste Recycled Unit	*
36	PER_PERSON	☐	SSTN_PER_PERSON	TEXT8	CHAR	8	0	Per Person
37	.INCLUDE	☐				0	0	Sustainability Economic Customer fields
38	DUMMY3	☐	SSTN_XT_DUMMY1		CHAR	10	0	SSTN_XT_Dummy Field1
39	ENV_PROTECTION_UI	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
40	ENV_INITIATIVES_UI	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
41	ENV_TECHNOLOGY_UI	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
42	ENV_PROC_SYS_UI	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
43	VALIDITY_RANGE	☐	CHAR50	TEXT50	CHAR	50	0	Comment
44	VALIDITY_START	☐	SSTN_VALIDITY_START_DATE	DATUM	DATS	8	0	Validity Start Date
45	VALIDITY_END	☐	SSTN_VALIDITY_END_DATE	DATUM	DATS	8	0	Validity End Date
46	CAT_TEXT	☐	CHAR50	TEXT50	CHAR	50	0	Comment
47	GHG_SCOPE1_AVG_UN	☐	SSTN_GHG_SCOPE1_UN	MEINS	UNIT	3	0	Direct Emissions Unit	*
48	GHG_SCOPE2_AVG_UN	☐	SSTN_GHG_SCOPE2_UN	MEINS	UNIT	3	0	Indirect Emissions Unit	*
49	GHG_SCOPE3_AVG_UN	☐	SSTN_GHG_SCOPE3_UN	MEINS	UNIT	3	0	Third-Party Emissions Unit	*
50	TTL_ENR_CONS_AVG_UN	☐	SSTN_TOTAL_ENERGY_CONSUMED_UN	MEINS	UNIT	3	0	Total Energy Consumption Unit	*
51	RENEWABLE_ENERGY_AVG_UN	☐	SSTN_RENEWABLE_ENERGY_UNIT	MEINS	UNIT	3	0	Renewable Energy Unit	*
52	WASTE_AVG_UN	☐	SSTN_WASTE_NON_HZD_UNIT	MEINS	UNIT	3	0	Total Non-Hazardous Waste Unit	*
53	WASTE_RECYCLED_AVG_UN	☐	SSTN_MAT_WASTE_UN	MEINS	UNIT	3	0	Unit for Material Waste Generated	*
54	WASTE_HZD_AVG_UN	☐	SSTN_WASTE_HZD_UNIT	MEINS	UNIT	3	0	Total Hazardous Waste Unit	*
55	GHG_SCOPE1_AVG	☐	SSTN_GHG_SCOPE1	MENG13	QUAN	13	3	Direct Emissions
56	GHG_SCOPE2_AVG	☐	SSTN_GHG_SCOPE2	MENG13	QUAN	13	3	Indirect Emissions
57	GHG_SCOPE3_AVG	☐	SSTN_GHG_SCOPE3	MENG13	QUAN	13	3	Third-Party Emissions
58	TTL_ENR_CONS_AVG	☐	SSTN_TOTAL_ENERGY_CONSUMED	MENG13	QUAN	13	3	Total Energy Consumption
59	RENEWABLE_ENERGY_AVG	☐	SSTN_RENEWABLE_ENERGY	MENG13	QUAN	13	3	Renewable Energy
60	WASTE_AVG	☐	SSTN_WASTE_NON_HZD	MENG13	QUAN	13	3	Total Non-Hazardous Waste
61	WASTE_RECYCLED_AVG	☐	SSTN_WASTE_HZD	MENG13	QUAN	13	3	Total Hazardous Waste
62	WASTE_HZD_AVG	☐	SSTN_WASTE_RECYCLED	MENG13	QUAN	13	3	Total Waste Recycled

Foreign Keys

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

History

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