SAP ABAP Table LFS_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
⤷ FI-AP-AP (Application Component) Basic Functions
⤷ FBK_SUST (Package) Sustainability enhancements for Vendor
Basic Data
Table Category | INTTAB | Structure |
Structure | LFS_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 | ERNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
3 | UUID | SSTN_UUID | SYSUUID_C | CHAR | 32 | 0 | SSTN UUID | ||
4 | CREATED_BY | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
5 | CHANGED_BY | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
6 | CREATED_ON | DATUM | DATUM | DATS | 8 | 0 | Date | ||
7 | LIFNR_SUST_ID | LIFNR_SUST_ID | SSTN_ID | CHAR | 12 | 0 | Vendor Sustainability ID | * | |
8 | LAST_CHANGED_ON | DATUM | DATUM | DATS | 8 | 0 | Date | ||
9 | .INCLUDE | 0 | 0 | Overall list of sustainability attributes | |||||
10 | .INCLUDE | 0 | 0 | Sustainability Generic Fields | |||||
11 | .INCLUDE | 0 | 0 | Basic data of the general structure | |||||
12 | VALIDITY_START | SSTN_VALIDITY_START_DATE | DATUM | DATS | 8 | 0 | Validity Start Date | ||
13 | VALIDITY_END | SSTN_VALIDITY_END_DATE | DATUM | DATS | 8 | 0 | Validity End Date | ||
14 | AUDIT_AGENCY | SSTN_AUDIT_AGENCY | CHAR | 20 | 0 | Audit Agency | |||
15 | AUDIT_CONDUCT_ON | SSTN_AUDIT_CONDUCTED_ON | DATUM | DATS | 8 | 0 | Audit Date | ||
16 | SUPP_COC | SSTN_SUPP_COC | SSTN_CODE_OF_CONDUCT_INDICATOR | CHAR | 1 | 0 | Supplier Code of Conduct Indicator | ||
17 | SUPP_COC_DATE | SSTN_SUPP_COC_DATE | DATUM | DATS | 8 | 0 | Supplier Code of Conduct Date | ||
18 | SUST_REPORT | SSTN_SUST_REPORT | CHAR | 50 | 0 | Sustainability Reporting Standard | |||
19 | SUST_RPT_RATING | SSTN_REPORT_RATING | SSTN_SCORE | INT1 | 3 | 0 | Sustainability Reporting Standard Rating | ||
20 | SUST_REPORT_DATE | SSTN_SUST_REPORT_DATE | DATS | DATS | 8 | 0 | Last Publication Date of Sustainability Report | ||
21 | DEL_FLAG | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
22 | .INCLUDE | 0 | 0 | Score related part of the general structure | |||||
23 | OVERALL_SCORE | SSTN_OVERALL_SCORE | SSTN_SCORE | INT1 | 3 | 0 | Overall Score | ||
24 | TOT_RESP_SCORE | SSTN_TOTAL_SOC_RESPONSIBILITY | SSTN_SCORE | INT1 | 3 | 0 | Social Responsibility Compliance Score | ||
25 | TOT_ENV_SCORE | SSTN_TOTAL_ENVIRONMENTAL | SSTN_SCORE | INT1 | 3 | 0 | Total Environmental Compliance Score | ||
26 | TOT_ECO_SCORE | SSTN_TOTAL_ECONOMIC | SSTN_SCORE | INT1 | 3 | 0 | Total Economic Compliance Score | ||
27 | .INCLUDE | 0 | 0 | Social compliance attributes of a supplier | |||||
28 | SOC_COMMENTS | SSTN_COMMENTS | TEXT255 | CHAR | 255 | 0 | Comments | ||
29 | .INCLUDE | 0 | 0 | Social compliance | |||||
30 | SOC_PROC_SYS | SSTN_SOCIAL_PROCESSES_SYSTEMS | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Social Compliance Regarding Processes and Systems | ||
31 | HUMAN_RIGHTS | SSTN_HUMAN_RIGHT | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Human Rights Compliance Code | ||
32 | HEALTH_SAFETY | SSTN_HEALTH_SAFETY | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Health and Safety Compliance Code | ||
33 | SOC_FINES | SSTN_SOCIAL_FINE | WERT7 | CURR | 13 | 2 | Fines Paid for Non-Compliance with Social Standards | ||
34 | SOC_FINES_CURR | SSTN_SUPPLIER_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
35 | .INCLUDE | 0 | 0 | Labour Standards Compliance | |||||
36 | DISCRIMINATION | SSTN_DISCRIMINATION | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Non-Discrimination Compliance Code | ||
37 | CHILD_LABOUR | SSTN_CHILD_LABOUR | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Child Labor Compliance Code | ||
38 | FORCED_LABOUR | SSTN_FORCED_LABOUR | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Forced Labor Compliance Code | ||
39 | COL_BARGAINING | SSTN_COLLECTIVE_BARGAINING | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Right to Collective Bargaining Compliance Code | ||
40 | .INCLUDE | 0 | 0 | Other social compliance attributes | |||||
41 | ANTI_CORRUPTION | SSTN_ANTICORRUPTION | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Anti-Corruption Compliance Code | ||
42 | WOMEN_OWNED | SSTN_WOMEN_OWNED | SSTN_CERTIFIED_COMPANY | CHAR | 1 | 0 | Women-Owned Business (WBE-Certified) | ||
43 | WOM_OWNED_EXP | SSTN_CERTIFICATE_EXPIRE_DATE | DATS | DATS | 8 | 0 | Expiration Date of a Certificate (WBE/MBE, for ex.) | ||
44 | MINORITY_OWNED | SSTN_MINORITY_OWNED | SSTN_CERTIFIED_COMPANY | CHAR | 1 | 0 | Minority-Owned Business (MBE-Certified) | ||
45 | MIN_OWNED_EXP | SSTN_CERTIFICATE_EXPIRE_DATE | DATS | DATS | 8 | 0 | Expiration Date of a Certificate (WBE/MBE, for ex.) | ||
46 | .INCLUDE | 0 | 0 | Environmental Compliance | |||||
47 | ENV_COMMENTS | SSTN_COMMENTS | TEXT255 | CHAR | 255 | 0 | Comments | ||
48 | .INCLUDE | 0 | 0 | Environmental compliance attributes | |||||
49 | ENV_PROTECTION | SSTN_ENVIRONMENT_PROTECTION | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Environmental Protection Compliance Code | ||
50 | ENV_INITIATIVES | SSTN_ENVIRONMENTAL_INITIATIVES | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Environmental Initiatives Compliance Code | ||
51 | ENV_TECHNOLOGY | SSTN_CLEAN_TECHNOLOGY | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Clean Technology Compliance Code | ||
52 | ENV_PROC_SYS | SSTN_ENVIRON_PROCESSES_SYSTEMS | SSTN_COMPLIANCE_CODE | CHAR | 1 | 0 | Environmental Compliance Regarding Processes and Systems | ||
53 | ENV_FINES | SSTN_ENVIRONMENT_FINE | WERT7 | CURR | 13 | 2 | Environmental Fine | ||
54 | ENV_FINES_CURR | SSTN_SUPPLIER_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
55 | .INCLUDE | 0 | 0 | Sustainability Energy Attributes | |||||
56 | TTL_ENR_CONS | SSTN_TOTAL_ENERGY_CONSUMED | MENG13 | QUAN | 13 | 3 | Total Energy Consumption | ||
57 | TTL_ENR_CONS_UN | SSTN_TOTAL_ENERGY_CONSUMED_UN | MEINS | UNIT | 3 | 0 | Total Energy Consumption Unit | T006 | |
58 | RENEWABLE_ENERGY | SSTN_RENEWABLE_ENERGY | MENG13 | QUAN | 13 | 3 | Renewable Energy | ||
59 | RENEW_ENERGY_UN | SSTN_RENEWABLE_ENERGY_UNIT | MEINS | UNIT | 3 | 0 | Renewable Energy Unit | T006 | |
60 | TTL_WATER_CONS | SSTN_WATER_CONSUMPTION | MENG13 | QUAN | 13 | 3 | Total Water Consumption | ||
61 | TTL_WATER_CON_UN | SSTN_WATER_CONSUMPTION_UN | MEINS | UNIT | 3 | 0 | Total Water Consumption Unit | T006 | |
62 | RECYCLED_WATER | SSTN_WATER_RECYCLED | MENG13 | QUAN | 13 | 3 | Amount of Water Recycled | ||
63 | RECYCL_WATER_UN | SSTN_WATER_RECYCLED_UN | MEINS | UNIT | 3 | 0 | Water Recycled Unit | T006 | |
64 | .INCLUDE | 0 | 0 | Sustainability Fields Related to GHG scope attributes | |||||
65 | GHG_SCOPE1 | SSTN_GHG_SCOPE1 | MENG13 | QUAN | 13 | 3 | Direct Emissions | ||
66 | GHG_SCOPE1_UN | SSTN_GHG_SCOPE1_UN | MEINS | UNIT | 3 | 0 | Direct Emissions Unit | T006 | |
67 | GHG_SCOPE2 | SSTN_GHG_SCOPE2 | MENG13 | QUAN | 13 | 3 | Indirect Emissions | ||
68 | GHG_SCOPE2_UN | SSTN_GHG_SCOPE2_UN | MEINS | UNIT | 3 | 0 | Indirect Emissions Unit | T006 | |
69 | GHG_SCOPE3 | SSTN_GHG_SCOPE3 | MENG13 | QUAN | 13 | 3 | Third-Party Emissions | ||
70 | GHG_SCOPE3_UN | SSTN_GHG_SCOPE3_UN | MEINS | UNIT | 3 | 0 | Third-Party Emissions Unit | T006 | |
71 | .INCLUDE | 0 | 0 | Sustainability Fields Related to waste abd recycled products | |||||
72 | WASTE_NON_HZD | SSTN_WASTE_NON_HZD | MENG13 | QUAN | 13 | 3 | Total Non-Hazardous Waste | ||
73 | WASTE_NON_HZD_UN | SSTN_WASTE_NON_HZD_UNIT | MEINS | UNIT | 3 | 0 | Total Non-Hazardous Waste Unit | * | |
74 | WASTE_HZD | SSTN_WASTE_HZD | MENG13 | QUAN | 13 | 3 | Total Hazardous Waste | ||
75 | WASTE_HZD_UNIT | SSTN_WASTE_HZD_UNIT | MEINS | UNIT | 3 | 0 | Total Hazardous Waste Unit | T006 | |
76 | WASTE_RECYCLED | SSTN_WASTE_RECYCLED | MENG13 | QUAN | 13 | 3 | Total Waste Recycled | ||
77 | WASTE_RECYCLD_UN | SSTN_WASTE_RECYCLED_UN | MEINS | UNIT | 3 | 0 | Total Waste Recycled Unit | * | |
78 | .INCLUDE | 0 | 0 | Suppliers sustainability attributes: economic & risk related | |||||
79 | .INCLUDE | 0 | 0 | Company related part of the economic and risk data | |||||
80 | TOTAL_SPEND | SSTN_SUPPLIER_TOTAL_SPEND | WERT15 | CURR | 15 | 2 | Total Spend with Supplier | ||
81 | TOTAL_SPEND_CURR | SSTN_SUPPLIER_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
82 | TOTAL_REVENUE | SSTN_SUPPLIER_TOTAL_REVENUE | WERT15 | CURR | 15 | 2 | Total Revenue of Supplier | ||
83 | TOT_REVENUE_CURR | SSTN_SUPPLIER_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
84 | EMPLOYEE_COUNT | SSTN_EMP_COUNT | SSTN_EMP_COUNT | NUMC | 12 | 0 | Number of Employees | ||
85 | .INCLUDE | 0 | 0 | Supply Risk | |||||
86 | TOTAL_RISK | SSTN_TOTAL_SUPPLY_RISK | SSTN_SUPPLY_RISK | CHAR | 1 | 0 | Total Supply Risk Code | ||
87 | FINANCIAL_RISK | SSTN_FINANCIAL_SUPPLY_RISK | SSTN_SUPPLY_RISK | CHAR | 1 | 0 | Financial Supply Risk Code | ||
88 | LOGISTICAL_RISK | SSTN_LOGISTICAL_SUPPLY_RISK | SSTN_SUPPLY_RISK | CHAR | 1 | 0 | Logistics Supply Risk Code | ||
89 | QUALITY_RISK | SSTN_QUALITY_SUPPLY_RISK | SSTN_SUPPLY_RISK | CHAR | 1 | 0 | Quality Supply Risk Code | ||
90 | POLITICAL_RISK | SSTN_POLITICAL_SUPPLY_RISK | SSTN_SUPPLY_RISK | CHAR | 1 | 0 | Political Supply Risk Code | ||
91 | .INCLUDE | 0 | 0 | Extension Include for Sustainability / Classification Data | |||||
92 | DUMMY_EEW_SSTN | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
93 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LFS_SSTN | GHG_SCOPE1_UN | T006 | MSEHI | REF | ||
2 | LFS_SSTN | GHG_SCOPE2_UN | T006 | MSEHI | REF | ||
3 | LFS_SSTN | GHG_SCOPE3_UN | T006 | MSEHI | REF | ||
4 | LFS_SSTN | RECYCL_WATER_UN | T006 | MSEHI | |||
5 | LFS_SSTN | RENEW_ENERGY_UN | T006 | MSEHI | REF | ||
6 | LFS_SSTN | TTL_ENR_CONS_UN | T006 | MSEHI | REF | ||
7 | LFS_SSTN | TTL_WATER_CON_UN | T006 | MSEHI | |||
8 | LFS_SSTN | WASTE_HZD_UNIT | T006 | MSEHI |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 606 |