SAP ESH_S_MU_SEARCH_PATTERN Search Pattern Table data and field list

ESH_S_MU_SEARCH_PATTERN 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 "Search Pattern" 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_MU_SEARCH_PATTERN TYPE ESH_S_MU_SEARCH_PATTERN.

The ESH_S_MU_SEARCH_PATTERN table consists of various fields, each holding specific information or linking keys about Search Pattern data available in SAP. These include SYS_GROUP (Model), BO_NAME (Object Type), NAME (Request), NAME_READONLY (Marker for Check Field)... 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_MU_SEARCH_PATTERN 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_MU_SEARCH_PATTERN 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_MU_SEARCH_PATTERN 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
SWCVSoftware Component ESH_E_OM_SYSRELCHAR32
SYS_GROUPModel ESH_E_OM_MODELCHAR32
BO_NAMEObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
NAMERequest ESH_E_OM_REQUESTCHAR20
NAME_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
DESCRDescriptions ESH_E_OM_DESCRIPTIONCHAR60ESH_D_OM_DESCRIPTION
DESCR_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
IS_DEFAULTFlag: Default Request ESH_E_OM_DEFAULT_REQUESTCHAR1XFELD
IS_DEFAULT_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQUEST_GUIDRequest GUID ESH_E_OM_REQUEST_GUIDCHAR32SYSUUID_C
MOD_STATUSModification Status of Node Fields ESH_E_OM_MOD_STATUS_OTYPNFCHAR1ESH_D_OM_MOD_STATUS_OTYPNF
BACKEND_NAMEBackend Name ESH_E_OM_BACKEND_NAMECHAR255ESH_D_OM_BACKEND_NAME
ORG_SYSREL_GUIDSoftware Component GUID ESH_E_OM_SYSREL_GUIDCHAR32SYSUUID_C
IS_SWITCHEDMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQ_RELV_INTFlag: Request Relevant Internally ESH_E_OM_REQ_RELV_INTERNALCHAR1XFELD
REQ_RELV_ATTRFlag: Request Relevant for Attribute Search ESH_E_OM_REQ_RELV_ATTRSEARCHCHAR1XFELD
REQ_RELV_VALHELPFlag: Request Relevant for Value Help ESH_E_OM_REQ_RELV_VALHELPCHAR1XFELD
REQ_RELV_RELREQFlag: Request Relevant for Related Requests ESH_E_OM_REQ_RELV_RELREQCHAR1XFELD
REQ_RELV_ODPFlag: Request Relevant for ODP (Navigation Request) ESH_E_OM_REQ_RELV_ODPCHAR1XFELD
REQ_DEF_ODPFlag: Default ODP-Request (Navigation Request) ESH_E_OM_DEFAULT_REQUEST_ODPCHAR1XFELD
REQ_RELV_INT_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQ_RELV_ATTR_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQ_RELV_VALHELP_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQ_RELV_RELREQ_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQ_RELV_ODP_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REQ_DEF_ODP_READONLYMarker for Check Field ESH_E_MU_CHECKEDCHAR1SAP_BOOL
REL_BO_NAMEObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
REL_BO_DESCRDescriptions ESH_E_OM_DESCRIPTIONCHAR60ESH_D_OM_DESCRIPTION
REL_NODE_NAMENode Name ESH_E_OM_NODE_NAMECHAR20ESH_D_OM_NODE_NAME

Key field Non-key field



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

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

How to access SAP table ESH_S_MU_SEARCH_PATTERN

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

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