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