LFSSTN is a SAP table coming under FI module and SAP_FIN component.View details, Fields & related tables of LFSSTN in SAP.
- Table description : Sustainability details for Vendor
- Module : FI-AP-AP
- Parent Module : FI
- Package : FBK_SUST
- Software Component : SAP_FIN
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP LFSSTN Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
LIFNR | Account Number of Vendor or Creditor | LIFNR | LIFNR |
UUID | SSTN UUID | SSTN_UUID | SYSUUID_C |
LIFNR_SUST_ID | Vendor Sustainability ID | LIFNR_SUST_ID | SSTN_ID |
CREATED_BY | User name | USNAM | XUBNAME |
CHANGED_BY | User name | USNAM | XUBNAME |
CREATED_ON | Date | DATUM | DATUM |
LAST_CHANGED_ON | Date | DATUM | DATUM |
.INCLUDE | Overall list of sustainability attributes | ||
.INCLUDE | Sustainability Generic Fields | ||
.INCLUDE | Basic data of the general structure | ||
VALIDITY_START | Validity Start Date | SSTN_VALIDITY_START_DATE | DATUM |
VALIDITY_END | Validity End Date | SSTN_VALIDITY_END_DATE | DATUM |
AUDIT_AGENCY | Audit Agency | SSTN_AUDIT_AGENCY | |
AUDIT_CONDUCT_ON | Audit Date | SSTN_AUDIT_CONDUCTED_ON | DATUM |
SUPP_COC | Supplier Code of Conduct Indicator | SSTN_SUPP_COC | SSTN_CODE_OF_CONDUCT_INDICATOR |
SUPP_COC_DATE | Supplier Code of Conduct Date | SSTN_SUPP_COC_DATE | DATUM |
SUST_REPORT | Sustainability Reporting Standard | SSTN_SUST_REPORT | |
SUST_RPT_RATING | Sustainability Reporting Standard Rating | SSTN_REPORT_RATING | SSTN_SCORE |
SUST_REPORT_DATE | Last Publication Date of Sustainability Report | SSTN_SUST_REPORT_DATE | DATS |
DEL_FLAG | Checkbox | XFELD | XFELD |
.INCLUDE | Score related part of the general structure | ||
OVERALL_SCORE | Overall Score | SSTN_OVERALL_SCORE | SSTN_SCORE |
TOT_RESP_SCORE | Social Responsibility Compliance Score | SSTN_TOTAL_SOC_RESPONSIBILITY | SSTN_SCORE |
TOT_ENV_SCORE | Total Environmental Compliance Score | SSTN_TOTAL_ENVIRONMENTAL | SSTN_SCORE |
TOT_ECO_SCORE | Total Economic Compliance Score | SSTN_TOTAL_ECONOMIC | SSTN_SCORE |
.INCLUDE | Social compliance attributes of a supplier | ||
SOC_COMMENTS | Comments | SSTN_COMMENTS | TEXT255 |
.INCLUDE | Social compliance | ||
SOC_PROC_SYS | Social Compliance Regarding Processes and Systems | SSTN_SOCIAL_PROCESSES_SYSTEMS | SSTN_COMPLIANCE_CODE |
HUMAN_RIGHTS | Human Rights Compliance Code | SSTN_HUMAN_RIGHT | SSTN_COMPLIANCE_CODE |
HEALTH_SAFETY | Health and Safety Compliance Code | SSTN_HEALTH_SAFETY | SSTN_COMPLIANCE_CODE |
SOC_FINES | Fines Paid for Non-Compliance with Social Standards | SSTN_SOCIAL_FINE | WERT7 |
SOC_FINES_CURR | Currency | SSTN_SUPPLIER_CURRENCY | WAERS |
.INCLUDE | Labour Standards Compliance | ||
DISCRIMINATION | Non-Discrimination Compliance Code | SSTN_DISCRIMINATION | SSTN_COMPLIANCE_CODE |
CHILD_LABOUR | Child Labor Compliance Code | SSTN_CHILD_LABOUR | SSTN_COMPLIANCE_CODE |
FORCED_LABOUR | Forced Labor Compliance Code | SSTN_FORCED_LABOUR | SSTN_COMPLIANCE_CODE |
COL_BARGAINING | Right to Collective Bargaining Compliance Code | SSTN_COLLECTIVE_BARGAINING | SSTN_COMPLIANCE_CODE |
.INCLUDE | Other social compliance attributes | ||
ANTI_CORRUPTION | Anti-Corruption Compliance Code | SSTN_ANTICORRUPTION | SSTN_COMPLIANCE_CODE |
WOMEN_OWNED | Women-Owned Business (WBE-Certified) | SSTN_WOMEN_OWNED | SSTN_CERTIFIED_COMPANY |
WOM_OWNED_EXP | Expiration Date of a Certificate (WBE/MBE, for ex.) | SSTN_CERTIFICATE_EXPIRE_DATE | DATS |
MINORITY_OWNED | Minority-Owned Business (MBE-Certified) | SSTN_MINORITY_OWNED | SSTN_CERTIFIED_COMPANY |
MIN_OWNED_EXP | Expiration Date of a Certificate (WBE/MBE, for ex.) | SSTN_CERTIFICATE_EXPIRE_DATE | DATS |
.INCLUDE | Environmental Compliance | ||
ENV_COMMENTS | Comments | SSTN_COMMENTS | TEXT255 |
.INCLUDE | Environmental compliance attributes | ||
ENV_PROTECTION | Environmental Protection Compliance Code | SSTN_ENVIRONMENT_PROTECTION | SSTN_COMPLIANCE_CODE |
ENV_INITIATIVES | Environmental Initiatives Compliance Code | SSTN_ENVIRONMENTAL_INITIATIVES | SSTN_COMPLIANCE_CODE |
ENV_TECHNOLOGY | Clean Technology Compliance Code | SSTN_CLEAN_TECHNOLOGY | SSTN_COMPLIANCE_CODE |
ENV_PROC_SYS | Environmental Compliance Regarding Processes and Systems | SSTN_ENVIRON_PROCESSES_SYSTEMS | SSTN_COMPLIANCE_CODE |
ENV_FINES | Environmental Fine | SSTN_ENVIRONMENT_FINE | WERT7 |
ENV_FINES_CURR | Currency | SSTN_SUPPLIER_CURRENCY | WAERS |
.INCLUDE | Sustainability Energy Attributes | ||
TTL_ENR_CONS | Total Energy Consumption | SSTN_TOTAL_ENERGY_CONSUMED | MENG13 |
TTL_ENR_CONS_UN | Total Energy Consumption Unit | SSTN_TOTAL_ENERGY_CONSUMED_UN | MEINS |
RENEWABLE_ENERGY | Renewable Energy | SSTN_RENEWABLE_ENERGY | MENG13 |
RENEW_ENERGY_UN | Renewable Energy Unit | SSTN_RENEWABLE_ENERGY_UNIT | MEINS |
TTL_WATER_CONS | Total Water Consumption | SSTN_WATER_CONSUMPTION | MENG13 |
TTL_WATER_CON_UN | Total Water Consumption Unit | SSTN_WATER_CONSUMPTION_UN | MEINS |
RECYCLED_WATER | Amount of Water Recycled | SSTN_WATER_RECYCLED | MENG13 |
RECYCL_WATER_UN | Water Recycled Unit | SSTN_WATER_RECYCLED_UN | MEINS |
.INCLUDE | Sustainability Fields Related to GHG scope attributes | ||
GHG_SCOPE1 | Direct Emissions | SSTN_GHG_SCOPE1 | MENG13 |
GHG_SCOPE1_UN | Direct Emissions Unit | SSTN_GHG_SCOPE1_UN | MEINS |
GHG_SCOPE2 | Indirect Emissions | SSTN_GHG_SCOPE2 | MENG13 |
GHG_SCOPE2_UN | Indirect Emissions Unit | SSTN_GHG_SCOPE2_UN | MEINS |
GHG_SCOPE3 | Third-Party Emissions | SSTN_GHG_SCOPE3 | MENG13 |
GHG_SCOPE3_UN | Third-Party Emissions Unit | SSTN_GHG_SCOPE3_UN | MEINS |
.INCLUDE | Sustainability Fields Related to waste abd recycled products | ||
WASTE_NON_HZD | Total Non-Hazardous Waste | SSTN_WASTE_NON_HZD | MENG13 |
WASTE_NON_HZD_UN | Total Non-Hazardous Waste Unit | SSTN_WASTE_NON_HZD_UNIT | MEINS |
WASTE_HZD | Total Hazardous Waste | SSTN_WASTE_HZD | MENG13 |
WASTE_HZD_UNIT | Total Hazardous Waste Unit | SSTN_WASTE_HZD_UNIT | MEINS |
WASTE_RECYCLED | Total Waste Recycled | SSTN_WASTE_RECYCLED | MENG13 |
WASTE_RECYCLD_UN | Total Waste Recycled Unit | SSTN_WASTE_RECYCLED_UN | MEINS |
.INCLUDE | Suppliers sustainability attributes: economic & risk related | ||
.INCLUDE | Company related part of the economic and risk data | ||
TOTAL_SPEND | Total Spend with Supplier | SSTN_SUPPLIER_TOTAL_SPEND | WERT15 |
TOTAL_SPEND_CURR | Currency | SSTN_SUPPLIER_CURRENCY | WAERS |
TOTAL_REVENUE | Total Revenue of Supplier | SSTN_SUPPLIER_TOTAL_REVENUE | WERT15 |
TOT_REVENUE_CURR | Currency | SSTN_SUPPLIER_CURRENCY | WAERS |
EMPLOYEE_COUNT | Number of Employees | SSTN_EMP_COUNT | SSTN_EMP_COUNT |
.INCLUDE | Supply Risk | ||
TOTAL_RISK | Total Supply Risk Code | SSTN_TOTAL_SUPPLY_RISK | SSTN_SUPPLY_RISK |
FINANCIAL_RISK | Financial Supply Risk Code | SSTN_FINANCIAL_SUPPLY_RISK | SSTN_SUPPLY_RISK |
LOGISTICAL_RISK | Logistics Supply Risk Code | SSTN_LOGISTICAL_SUPPLY_RISK | SSTN_SUPPLY_RISK |
QUALITY_RISK | Quality Supply Risk Code | SSTN_QUALITY_SUPPLY_RISK | SSTN_SUPPLY_RISK |
POLITICAL_RISK | Political Supply Risk Code | SSTN_POLITICAL_SUPPLY_RISK | SSTN_SUPPLY_RISK |
.INCLUDE | Extension Include for Sustainability / Classification Data | ||
DUMMY_EEW_SSTN | Dummy function in length 1 | DUMMY | DUMMY |
.INCLUDE |
LFSSTN related tables
Table | Note |
---|---|
LFSSTN | Sustainability details for Vendor |
LFSSTN_CERT | Vendor sustainability certificates |
MGIR_SSTN_ECOLBL | Material / Vendor Sustainability Eco-Label table |
MGIR_SSTN | Material / Info Record Sustainability table |
A109 | Vendor hierarchy: vendor sub-range |
BBP_SD_LOG | Vendor's Entries in Vendor List |
KOTE012 | Vendor Hierarchy: Vendor Sub-Range Rebate |
MSID | Vendor Stock with Vendor |
MSIDH | Vendor Stock with Vendor - History |
MSIS | Vendor Stock with Vendor - Total |
VEN001 | Business Partner: Vendor - Our Number at Vendor |
WSVD_DB_VNDR_PLT | SRS Vendor Master: Maint. Authorization for Store-Vendor |
LFBK | Vendor Master (Bank Details) |
RSDMTPN_VENDOR | DataMining Vendor Details |
TFREP | Reports with Form Details and Sender Details |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP