SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

LFSSTN Table in SAP | Sustainability details for Vendor Table & Fields List

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
LFSSTN table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
LIFNRAccount Number of Vendor or CreditorLIFNRLIFNR
UUIDSSTN UUIDSSTN_UUIDSYSUUID_C
LIFNR_SUST_IDVendor Sustainability IDLIFNR_SUST_IDSSTN_ID
CREATED_BYUser nameUSNAMXUBNAME
CHANGED_BYUser nameUSNAMXUBNAME
CREATED_ONDateDATUMDATUM
LAST_CHANGED_ONDateDATUMDATUM
.INCLUDEOverall list of sustainability attributes    
.INCLUDESustainability Generic Fields    
.INCLUDEBasic data of the general structure    
VALIDITY_STARTValidity Start DateSSTN_VALIDITY_START_DATEDATUM
VALIDITY_ENDValidity End DateSSTN_VALIDITY_END_DATEDATUM
AUDIT_AGENCYAudit AgencySSTN_AUDIT_AGENCY  
AUDIT_CONDUCT_ONAudit DateSSTN_AUDIT_CONDUCTED_ONDATUM
SUPP_COCSupplier Code of Conduct IndicatorSSTN_SUPP_COCSSTN_CODE_OF_CONDUCT_INDICATOR
SUPP_COC_DATESupplier Code of Conduct DateSSTN_SUPP_COC_DATEDATUM
SUST_REPORTSustainability Reporting StandardSSTN_SUST_REPORT  
SUST_RPT_RATINGSustainability Reporting Standard RatingSSTN_REPORT_RATINGSSTN_SCORE
SUST_REPORT_DATELast Publication Date of Sustainability ReportSSTN_SUST_REPORT_DATEDATS
DEL_FLAGCheckboxXFELDXFELD
.INCLUDEScore related part of the general structure    
OVERALL_SCOREOverall ScoreSSTN_OVERALL_SCORESSTN_SCORE
TOT_RESP_SCORESocial Responsibility Compliance ScoreSSTN_TOTAL_SOC_RESPONSIBILITYSSTN_SCORE
TOT_ENV_SCORETotal Environmental Compliance ScoreSSTN_TOTAL_ENVIRONMENTALSSTN_SCORE
TOT_ECO_SCORETotal Economic Compliance ScoreSSTN_TOTAL_ECONOMICSSTN_SCORE
.INCLUDESocial compliance attributes of a supplier    
SOC_COMMENTSCommentsSSTN_COMMENTSTEXT255
.INCLUDESocial compliance    
SOC_PROC_SYSSocial Compliance Regarding Processes and SystemsSSTN_SOCIAL_PROCESSES_SYSTEMSSSTN_COMPLIANCE_CODE
HUMAN_RIGHTSHuman Rights Compliance CodeSSTN_HUMAN_RIGHTSSTN_COMPLIANCE_CODE
HEALTH_SAFETYHealth and Safety Compliance CodeSSTN_HEALTH_SAFETYSSTN_COMPLIANCE_CODE
SOC_FINESFines Paid for Non-Compliance with Social StandardsSSTN_SOCIAL_FINEWERT7
SOC_FINES_CURRCurrencySSTN_SUPPLIER_CURRENCYWAERS
.INCLUDELabour Standards Compliance    
DISCRIMINATIONNon-Discrimination Compliance CodeSSTN_DISCRIMINATIONSSTN_COMPLIANCE_CODE
CHILD_LABOURChild Labor Compliance CodeSSTN_CHILD_LABOURSSTN_COMPLIANCE_CODE
FORCED_LABOURForced Labor Compliance CodeSSTN_FORCED_LABOURSSTN_COMPLIANCE_CODE
COL_BARGAININGRight to Collective Bargaining Compliance CodeSSTN_COLLECTIVE_BARGAININGSSTN_COMPLIANCE_CODE
.INCLUDEOther social compliance attributes    
ANTI_CORRUPTIONAnti-Corruption Compliance CodeSSTN_ANTICORRUPTIONSSTN_COMPLIANCE_CODE
WOMEN_OWNEDWomen-Owned Business (WBE-Certified)SSTN_WOMEN_OWNEDSSTN_CERTIFIED_COMPANY
WOM_OWNED_EXPExpiration Date of a Certificate (WBE/MBE, for ex.)SSTN_CERTIFICATE_EXPIRE_DATEDATS
MINORITY_OWNEDMinority-Owned Business (MBE-Certified)SSTN_MINORITY_OWNEDSSTN_CERTIFIED_COMPANY
MIN_OWNED_EXPExpiration Date of a Certificate (WBE/MBE, for ex.)SSTN_CERTIFICATE_EXPIRE_DATEDATS
.INCLUDEEnvironmental Compliance    
ENV_COMMENTSCommentsSSTN_COMMENTSTEXT255
.INCLUDEEnvironmental compliance attributes    
ENV_PROTECTIONEnvironmental Protection Compliance CodeSSTN_ENVIRONMENT_PROTECTIONSSTN_COMPLIANCE_CODE
ENV_INITIATIVESEnvironmental Initiatives Compliance CodeSSTN_ENVIRONMENTAL_INITIATIVESSSTN_COMPLIANCE_CODE
ENV_TECHNOLOGYClean Technology Compliance CodeSSTN_CLEAN_TECHNOLOGYSSTN_COMPLIANCE_CODE
ENV_PROC_SYSEnvironmental Compliance Regarding Processes and SystemsSSTN_ENVIRON_PROCESSES_SYSTEMSSSTN_COMPLIANCE_CODE
ENV_FINESEnvironmental FineSSTN_ENVIRONMENT_FINEWERT7
ENV_FINES_CURRCurrencySSTN_SUPPLIER_CURRENCYWAERS
.INCLUDESustainability Energy Attributes    
TTL_ENR_CONSTotal Energy ConsumptionSSTN_TOTAL_ENERGY_CONSUMEDMENG13
TTL_ENR_CONS_UNTotal Energy Consumption UnitSSTN_TOTAL_ENERGY_CONSUMED_UNMEINS
RENEWABLE_ENERGYRenewable EnergySSTN_RENEWABLE_ENERGYMENG13
RENEW_ENERGY_UNRenewable Energy UnitSSTN_RENEWABLE_ENERGY_UNITMEINS
TTL_WATER_CONSTotal Water ConsumptionSSTN_WATER_CONSUMPTIONMENG13
TTL_WATER_CON_UNTotal Water Consumption UnitSSTN_WATER_CONSUMPTION_UNMEINS
RECYCLED_WATERAmount of Water RecycledSSTN_WATER_RECYCLEDMENG13
RECYCL_WATER_UNWater Recycled UnitSSTN_WATER_RECYCLED_UNMEINS
.INCLUDESustainability Fields Related to GHG scope attributes    
GHG_SCOPE1Direct EmissionsSSTN_GHG_SCOPE1MENG13
GHG_SCOPE1_UNDirect Emissions UnitSSTN_GHG_SCOPE1_UNMEINS
GHG_SCOPE2Indirect EmissionsSSTN_GHG_SCOPE2MENG13
GHG_SCOPE2_UNIndirect Emissions UnitSSTN_GHG_SCOPE2_UNMEINS
GHG_SCOPE3Third-Party EmissionsSSTN_GHG_SCOPE3MENG13
GHG_SCOPE3_UNThird-Party Emissions UnitSSTN_GHG_SCOPE3_UNMEINS
.INCLUDESustainability Fields Related to waste abd recycled products    
WASTE_NON_HZDTotal Non-Hazardous WasteSSTN_WASTE_NON_HZDMENG13
WASTE_NON_HZD_UNTotal Non-Hazardous Waste UnitSSTN_WASTE_NON_HZD_UNITMEINS
WASTE_HZDTotal Hazardous WasteSSTN_WASTE_HZDMENG13
WASTE_HZD_UNITTotal Hazardous Waste UnitSSTN_WASTE_HZD_UNITMEINS
WASTE_RECYCLEDTotal Waste RecycledSSTN_WASTE_RECYCLEDMENG13
WASTE_RECYCLD_UNTotal Waste Recycled UnitSSTN_WASTE_RECYCLED_UNMEINS
.INCLUDESuppliers sustainability attributes: economic & risk related    
.INCLUDECompany related part of the economic and risk data    
TOTAL_SPENDTotal Spend with SupplierSSTN_SUPPLIER_TOTAL_SPENDWERT15
TOTAL_SPEND_CURRCurrencySSTN_SUPPLIER_CURRENCYWAERS
TOTAL_REVENUETotal Revenue of SupplierSSTN_SUPPLIER_TOTAL_REVENUEWERT15
TOT_REVENUE_CURRCurrencySSTN_SUPPLIER_CURRENCYWAERS
EMPLOYEE_COUNTNumber of EmployeesSSTN_EMP_COUNTSSTN_EMP_COUNT
.INCLUDESupply Risk    
TOTAL_RISKTotal Supply Risk CodeSSTN_TOTAL_SUPPLY_RISKSSTN_SUPPLY_RISK
FINANCIAL_RISKFinancial Supply Risk CodeSSTN_FINANCIAL_SUPPLY_RISKSSTN_SUPPLY_RISK
LOGISTICAL_RISKLogistics Supply Risk CodeSSTN_LOGISTICAL_SUPPLY_RISKSSTN_SUPPLY_RISK
QUALITY_RISKQuality Supply Risk CodeSSTN_QUALITY_SUPPLY_RISKSSTN_SUPPLY_RISK
POLITICAL_RISKPolitical Supply Risk CodeSSTN_POLITICAL_SUPPLY_RISKSSTN_SUPPLY_RISK
.INCLUDEExtension Include for Sustainability / Classification Data    
DUMMY_EEW_SSTNDummy function in length 1DUMMYDUMMY
.INCLUDE   

LFSSTN related tables

TableNote
LFSSTNSustainability details for Vendor
LFSSTN_CERTVendor sustainability certificates
MGIR_SSTN_ECOLBLMaterial / Vendor Sustainability Eco-Label table
MGIR_SSTNMaterial / Info Record Sustainability table
A109Vendor hierarchy: vendor sub-range
BBP_SD_LOGVendor's Entries in Vendor List
KOTE012Vendor Hierarchy: Vendor Sub-Range Rebate
MSIDVendor Stock with Vendor
MSIDHVendor Stock with Vendor - History
MSISVendor Stock with Vendor - Total
VEN001Business Partner: Vendor - Our Number at Vendor
WSVD_DB_VNDR_PLTSRS Vendor Master: Maint. Authorization for Store-Vendor
LFBKVendor Master (Bank Details)
RSDMTPN_VENDORDataMining Vendor Details
TFREPReports with Form Details and Sender Details
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com