SAP ESH_S_SCOPE_DISTRIBUTION_UI Scope distribution for Narrow down in UI format Table data and field list

ESH_S_SCOPE_DISTRIBUTION_UI 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 "Scope distribution for Narrow down in UI format" 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_ESH_S_SCOPE_DISTRIBUTION_UI TYPE ESH_S_SCOPE_DISTRIBUTION_UI.

The ESH_S_SCOPE_DISTRIBUTION_UI table consists of various fields, each holding specific information or linking keys about Scope distribution for Narrow down in UI format data available in SAP. These include CATEGORY_ID (Category ID), CONNECTOR_ID (Search Connector ID), REQUEST_TYPE_ID (Request Type ID), PARENT (Readable Name)... 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. .

ESH_S_SCOPE_DISTRIBUTION_UI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ESH_S_SCOPE_DISTRIBUTION_UI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CATEGORY_IDCategory ID ESH_E_IF_CATEGORY_IDCHAR30ESH_D_OM_CATEGORY
CONNECTOR_IDSearch Connector ID ESH_E_IF_SEARCH_CONNECTOR_IDCHAR120ESH_D_IF_IDENTIFIER_LONG
REQUEST_TYPE_IDRequest Type ID ESH_E_IF_REQUEST_TYPE_IDCHAR32ESH_D_IF_IDENTIFIER_SHORT
PARENTReadable Name ESH_E_IF_NAMECHAR80ESH_D_IF_NAME
DESCRIPTIONReadable Name ESH_E_IF_NAMECHAR80ESH_D_IF_NAME
NUMBER_OF_HITSTotal Number of Results ESH_E_IF_NO_OF_TOTAL_RESULTSINT410INT4
ATTRIBUTE_NAMEAttribute Name ESH_E_IF_ATTRIBUTE_NAMESTRG0ESH_D_IF_ATTR_NAME_LONG
ATTRIBUTE_VALUEAttribute Value ESH_E_IF_ATTRIBUTE_VALUESTRG0
ATTRIBUTE_VALUE2Attribute Value ESH_E_IF_ATTRIBUTE_VALUESTRG0
DISTRIBUTION_TYPEDistribution Type ESH_E_IF_DISTRIBUTION_TYPECHAR1ESH_D_IF_DISTRIBUTION_TYPE
IS_COMMON_ATTRIBUTEData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
ATTRIBUTE_VALUE_EXTAttribute Value ESH_E_IF_ATTRIBUTE_VALUESTRG0
ATTRIBUTE_VALUE_EXT2Attribute Value ESH_E_IF_ATTRIBUTE_VALUESTRG0
IS_RANGEData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE

Key field Non-key field



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

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

How to access SAP table ESH_S_SCOPE_DISTRIBUTION_UI

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

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