LFS_VE_SSTN SAP (Vendor Master Sustainability Fields) Structure details

Dictionary Type: Structure
Description: Vendor Master Sustainability Fields




ABAP Code to SELECT data from LFS_VE_SSTN
Related tables to LFS_VE_SSTN
Access table LFS_VE_SSTN




Structure field list including key, data, relationships and ABAP select examples

LFS_VE_SSTN is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Vendor Master Sustainability Fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_LFS_VE_SSTN TYPE LFS_VE_SSTN.

The LFS_VE_SSTN table consists of various fields, each holding specific information or linking keys about Vendor Master Sustainability Fields data available in SAP. These include EKORG (Purchasing Organization), BUKRS (Company Code), OVERALL_RATING (Overall Score), SOCIAL_RATING (Social Responsibility Compliance Score).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP LFS_VE_SSTN structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
OVERALL_RATINGOverall Score SSTN_OVERALL_SCOREINT13SSTN_SCORE
SOCIAL_RATINGSocial Responsibility Compliance Score SSTN_TOTAL_SOC_RESPONSIBILITYINT13SSTN_SCORE
ENVIRON_RATINGTotal Environmental Compliance Score SSTN_TOTAL_ENVIRONMENTALINT13SSTN_SCORE
ECONOMIC_RATINGTotal Economic Compliance Score SSTN_TOTAL_ECONOMICINT13SSTN_SCORE
VALIDITY_STARTValidity Start Date SSTN_VALIDITY_START_DATEDATS8DATUM
VALIDITY_ENDValidity End Date SSTN_VALIDITY_END_DATEDATS8DATUM
AUDIT_AGENCYAudit Agency SSTN_AUDIT_AGENCYCHAR20
AUDIT_CONDUCT_ONAudit Date SSTN_AUDIT_CONDUCTED_ONDATS8DATUM
COMMENTSComments SSTN_COMMENTSCHAR255TEXT255
ISO_CERTIISO Certification SSTN_ISO_CERTIFICATIONCHAR40TXT40
SUST_REPORTSustainability Reporting Standard SSTN_SUST_REPORTCHAR50
SUST_RPT_RATINGSustainability Reporting Standard Rating SSTN_REPORT_RATINGINT13SSTN_SCORE
SUPP_COCSupplier Code of Conduct Indicator SSTN_SUPP_COCCHAR1SSTN_CODE_OF_CONDUCT_INDICATOR
SUPP_COC_DATESupplier Code of Conduct Date SSTN_SUPP_COC_DATEDATS8DATUM
DEL_FLAGCheckbox XFELDCHAR1XFELD
HUMAN_RIGHTSHuman Rights Compliance Code SSTN_HUMAN_RIGHTCHAR1SSTN_COMPLIANCE_CODE
ANTI_CORRUPTIONAnti-Corruption Compliance Code SSTN_ANTICORRUPTIONCHAR1SSTN_COMPLIANCE_CODE
CMPL_LBR_DISCNon-Discrimination Compliance Code SSTN_DISCRIMINATIONCHAR1SSTN_COMPLIANCE_CODE
CMPL_LBR_POLICYLabor Standards Compliance Code SSTN_TOTAL_LABOUR_STANDARDSCHAR1SSTN_COMPLIANCE_CODE
CMPL_LBR_CHILDChild Labor Compliance Code SSTN_CHILD_LABOURCHAR1SSTN_COMPLIANCE_CODE
CMPL_LBR_FORCEDForced Labor Compliance Code SSTN_FORCED_LABOURCHAR1SSTN_COMPLIANCE_CODE
COL_BARGAINRight to Collective Bargaining Compliance Code SSTN_COLLECTIVE_BARGAININGCHAR1SSTN_COMPLIANCE_CODE
MINOR_OWNED_BUSIMinority-Owned Business (MBE-Certified) SSTN_MINORITY_OWNEDCHAR1SSTN_CERTIFIED_COMPANY
WOMEN_OWNED_BUSIWomen-Owned Business (WBE-Certified) SSTN_WOMEN_OWNEDCHAR1SSTN_CERTIFIED_COMPANY
EMP_COUNTNumber of Employees SSTN_EMP_COUNTNUMC12SSTN_EMP_COUNT
RAT_FIN_RISKFinancial Risk Rating SSTN_RATING_FIN_RISKCHAR1SSTN_SUPPLY_RISK
RAT_FIN_PROVIDERRating Provider SSTN_RATING_FIN_PROVIDERCHAR20
RAT_FIN_DATEFinancial Rating Date SSTN_RATING_FIN_DATEDATS8DATUM
SUPPLIER_RISKFinancial Supply Risk Code SSTN_FINANCIAL_SUPPLY_RISKCHAR1SSTN_SUPPLY_RISK
TTL_ENR_CONSTotal Energy Consumption SSTN_TOTAL_ENERGY_CONSUMEDQUAN13(3) MENG13
TTL_ENR_CONS_UNTotal Energy Consumption Unit SSTN_TOTAL_ENERGY_CONSUMED_UNUNIT3T006CUNITMEINS
RENEWABLE_ENERGYRenewable Energy SSTN_RENEWABLE_ENERGYQUAN13(3) MENG13
RENEW_ENERGY_UNRenewable Energy Unit SSTN_RENEWABLE_ENERGY_UNITUNIT3T006CUNITMEINS
WATER_CONSTotal Water Consumption SSTN_WATER_CONSUMPTIONQUAN13(3) MENG13
WATER_CONS_UNTotal Water Consumption Unit SSTN_WATER_CONSUMPTION_UNUNIT3T006CUNITMEINS
ENVI_FINEEnvironmental Fine SSTN_ENVIRONMENT_FINECURR13(2) WERT7
ENVI_FINE_UNLocal Currency HWAERCUKY5TCURCWAERS
EMISSION_REDUCEmission Reduction SSTN_EMISSION_REDUCTIONQUAN13(3) MENG13
EMISS_REDUC_UNEmission Reduction Unit SSTN_EMISSION_REDUCTION_UNUNIT3T006CUNITMEINS
GHG_SCOPE1Direct Emissions SSTN_GHG_SCOPE1QUAN13(3) MENG13
GHG_SCOPE1_UNDirect Emissions Unit SSTN_GHG_SCOPE1_UNUNIT3T006CUNITMEINS
GHG_SCOPE2Indirect Emissions SSTN_GHG_SCOPE2QUAN13(3) MENG13
GHG_SCOPE2_UNIndirect Emissions Unit SSTN_GHG_SCOPE2_UNUNIT3T006CUNITMEINS
GHG_SCOPE3Third-Party Emissions SSTN_GHG_SCOPE3QUAN13(3) MENG13
GHG_SCOPE3_UNThird-Party Emissions Unit SSTN_GHG_SCOPE3_UNUNIT3T006CUNITMEINS
WASTEWaste SSTN_WASTEQUAN13(3) MENG13
WASTE_UNITTotal Waste Unit SSTN_WASTE_UNITUNIT3T006CUNITMEINS
WASTE_RECYCLEDTotal Waste Recycled SSTN_WASTE_RECYCLEDQUAN13(3) MENG13
WASTE_RECYCLD_UNTotal Waste Recycled Unit SSTN_WASTE_RECYCLED_UNUNIT3Assigned to domainCUNITMEINS
ENV_PROTECTIONEnvironmental Protection Compliance Code SSTN_ENVIRONMENT_PROTECTIONCHAR1SSTN_COMPLIANCE_CODE
ENV_RESPEnvironmental Responsibility Compliance Code SSTN_ENVIRONMENTAL_RESPCHAR1SSTN_COMPLIANCE_CODE
CLEAN_TECHNOLOGYClean Technology Compliance Code SSTN_CLEAN_TECHNOLOGYCHAR1SSTN_COMPLIANCE_CODE
WASTE_HZDTotal Hazardous Waste SSTN_WASTE_HZDQUAN13(3) MENG13
WASTE_HZD_UNITTotal Hazardous Waste Unit SSTN_WASTE_HZD_UNITUNIT3T006CUNITMEINS
LAST_UPDATEDDate DATUMDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure LFS_VE_SSTN using ABAP code?

As LFS_VE_SSTN is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on LFS_VE_SSTN as there is no data to select.

How to access SAP table LFS_VE_SSTN

Within an ECC or HANA version of SAP you can also view further information about LFS_VE_SSTN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!