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