SSTN_S_OVERALL SAP (Overall list of sustainability attributes) Structure details

Dictionary Type: Structure
Description: Overall list of sustainability attributes




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




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

SSTN_S_OVERALL 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 "Overall list of sustainability attributes" 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_SSTN_S_OVERALL TYPE SSTN_S_OVERALL.

The SSTN_S_OVERALL table consists of various fields, each holding specific information or linking keys about Overall list of sustainability attributes data available in SAP. These include VALIDITY_START (Validity Start Date), VALIDITY_END (Validity End Date), AUDIT_AGENCY (Audit Agency), AUDIT_CONDUCT_ON (Audit Date).. 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 (character-type or numeric)


SAP SSTN_S_OVERALL 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
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
SUPP_COCSupplier Code of Conduct Indicator SSTN_SUPP_COCCHAR1SSTN_CODE_OF_CONDUCT_INDICATOR
SUPP_COC_DATESupplier Code of Conduct Date SSTN_SUPP_COC_DATEDATS8DATUM
SUST_REPORTSustainability Reporting Standard SSTN_SUST_REPORTCHAR50
SUST_RPT_RATINGSustainability Reporting Standard Rating SSTN_REPORT_RATINGINT13SSTN_SCORE
SUST_REPORT_DATELast Publication Date of Sustainability Report SSTN_SUST_REPORT_DATEDATS8DATS
DEL_FLAGCheckbox XFELDCHAR1XFELD
OVERALL_SCOREOverall Score SSTN_OVERALL_SCOREINT13SSTN_SCORE
TOT_RESP_SCORESocial Responsibility Compliance Score SSTN_TOTAL_SOC_RESPONSIBILITYINT13SSTN_SCORE
TOT_ENV_SCORETotal Environmental Compliance Score SSTN_TOTAL_ENVIRONMENTALINT13SSTN_SCORE
TOT_ECO_SCORETotal Economic Compliance Score SSTN_TOTAL_ECONOMICINT13SSTN_SCORE
SOC_COMMENTSSocial Comments SSTN_SOC_COMMENTSCHAR255TEXT255
SOC_PROC_SYSSocial Compliance Regarding Processes and Systems SSTN_SOCIAL_PROCESSES_SYSTEMSCHAR1SSTN_COMPLIANCE_CODE
HUMAN_RIGHTSHuman Rights Compliance Code SSTN_HUMAN_RIGHTCHAR1SSTN_COMPLIANCE_CODE
HEALTH_SAFETYHealth and Safety Compliance Code SSTN_HEALTH_SAFETYCHAR1SSTN_COMPLIANCE_CODE
SOC_FINESFines Paid for Non-Compliance with Social Standards SSTN_SOCIAL_FINECURR13(2) WERT7
SOC_FINES_CURRSocial Fine Currency SSTN_SOCIAL_FINE_CURCUKY5Assigned to domainWAERS
DISCRIMINATIONNon-Discrimination Compliance Code SSTN_DISCRIMINATIONCHAR1SSTN_COMPLIANCE_CODE
CHILD_LABOURChild Labor Compliance Code SSTN_CHILD_LABOURCHAR1SSTN_COMPLIANCE_CODE
FORCED_LABOURForced Labor Compliance Code SSTN_FORCED_LABOURCHAR1SSTN_COMPLIANCE_CODE
COL_BARGAININGRight to Collective Bargaining Compliance Code SSTN_COLLECTIVE_BARGAININGCHAR1SSTN_COMPLIANCE_CODE
ANTI_CORRUPTIONAnti-Corruption Compliance Code SSTN_ANTICORRUPTIONCHAR1SSTN_COMPLIANCE_CODE
WOMEN_OWNEDWomen-Owned Business (WBE-Certified) SSTN_WOMEN_OWNEDCHAR1SSTN_CERTIFIED_COMPANY
WOM_OWNED_EXPWomen Owned Expiration Date of a Certificate SSTN_WOM_CERT_EXPIRE_DATEDATS8DATS
MINORITY_OWNEDMinority-Owned Business (MBE-Certified) SSTN_MINORITY_OWNEDCHAR1SSTN_CERTIFIED_COMPANY
MIN_OWNED_EXPExpiration Date of a Certificate (WBE/MBE, for ex.) SSTN_CERTIFICATE_EXPIRE_DATEDATS8DATS
ENV_COMMENTSEnvironmental Comments SSTN_ENV_COMMENTSCHAR255TEXT255
ENV_PROTECTIONEnvironmental Protection Compliance Code SSTN_ENVIRONMENT_PROTECTIONCHAR1SSTN_COMPLIANCE_CODE
ENV_INITIATIVESEnvironmental Initiatives Compliance Code SSTN_ENVIRONMENTAL_INITIATIVESCHAR1SSTN_COMPLIANCE_CODE
ENV_TECHNOLOGYClean Technology Compliance Code SSTN_CLEAN_TECHNOLOGYCHAR1SSTN_COMPLIANCE_CODE
ENV_PROC_SYSEnvironmental Compliance Regarding Processes and Systems SSTN_ENVIRON_PROCESSES_SYSTEMSCHAR1SSTN_COMPLIANCE_CODE
ENV_FINESEnvironmental Fine SSTN_ENVIRONMENT_FINECURR13(2) WERT7
ENV_FINES_CURREnvironmental Fine Currency SSTN_ENV_FINE_CURCUKY5Assigned to domainWAERS
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
TTL_WATER_CONSTotal Water Consumption SSTN_WATER_CONSUMPTIONQUAN13(3) MENG13
TTL_WATER_CON_UNTotal Water Consumption Unit SSTN_WATER_CONSUMPTION_UNUNIT3T006CUNITMEINS
RECYCLED_WATERAmount of Water Recycled SSTN_WATER_RECYCLEDQUAN13(3) MENG13
RECYCL_WATER_UNWater Recycled Unit SSTN_WATER_RECYCLED_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
WASTE_NON_HZDTotal Non-Hazardous Waste SSTN_WASTE_NON_HZDQUAN13(3) MENG13
WASTE_NON_HZD_UNTotal Non-Hazardous Waste Unit SSTN_WASTE_NON_HZD_UNITUNIT3Assigned to domainCUNITMEINS
WASTE_HZDTotal Hazardous Waste SSTN_WASTE_HZDQUAN13(3) MENG13
WASTE_HZD_UNITTotal Hazardous Waste Unit SSTN_WASTE_HZD_UNITUNIT3T006CUNITMEINS
WASTE_RECYCLEDTotal Waste Recycled SSTN_WASTE_RECYCLEDQUAN13(3) MENG13
WASTE_RECYCLD_UNTotal Waste Recycled Unit SSTN_WASTE_RECYCLED_UNUNIT3Assigned to domainCUNITMEINS
TOTAL_SPENDTotal Spend with Supplier SSTN_SUPPLIER_TOTAL_SPENDCURR15(2) WERT15
TOTAL_SPEND_CURRTotal Spend Currency SSTN_TOT_SPEND_CURRENCYCUKY5Assigned to domainWAERS
TOTAL_REVENUETotal Revenue of Supplier SSTN_SUPPLIER_TOTAL_REVENUECURR15(2) WERT15
TOT_REVENUE_CURRCurrency SSTN_SUPPLIER_CURRENCYCUKY5Assigned to domainWAERS
EMPLOYEE_COUNTNumber of Employees SSTN_EMP_COUNTNUMC12SSTN_EMP_COUNT
TOTAL_RISKTotal Supply Risk Code SSTN_TOTAL_SUPPLY_RISKCHAR1SSTN_SUPPLY_RISK
FINANCIAL_RISKFinancial Supply Risk Code SSTN_FINANCIAL_SUPPLY_RISKCHAR1SSTN_SUPPLY_RISK
LOGISTICAL_RISKLogistics Supply Risk Code SSTN_LOGISTICAL_SUPPLY_RISKCHAR1SSTN_SUPPLY_RISK
QUALITY_RISKQuality Supply Risk Code SSTN_QUALITY_SUPPLY_RISKCHAR1SSTN_SUPPLY_RISK
POLITICAL_RISKPolitical Supply Risk Code SSTN_POLITICAL_SUPPLY_RISKCHAR1SSTN_SUPPLY_RISK
DUMMY_EEW_SSTNDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

As SSTN_S_OVERALL 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 SSTN_S_OVERALL as there is no data to select.

How to access SAP table SSTN_S_OVERALL

Within an ECC or HANA version of SAP you can also view further information about SSTN_S_OVERALL 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!