SAP ESH_S_QL_QLOG Query Log Header Table data and field list

ESH_S_QL_QLOG 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 "Query Log Header" 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_QL_QLOG TYPE ESH_S_QL_QLOG.

The ESH_S_QL_QLOG table consists of various fields, each holding specific information or linking keys about Query Log Header data available in SAP. These include MANDT (Client), EXEC_ID (Search Execution ID), SESSION_ID (Search Session ID), QUERY_TYPE (Internal Query Type (Sync, Async, Bulk, Delegated))... 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_QL_QLOG 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_QL_QLOG 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_QL_QLOG 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
EXEC_IDSearch Execution ID ESH_E_IF_SEARCH_EXEC_IDCHAR32ESH_D_IF_SEARCH_EXEC_ID
SESSION_IDSearch Session ID ESH_E_IF_SEARCH_SESSION_IDCHAR32
QUERY_TYPEInternal Query Type (Sync, Async, Bulk, Delegated) ESH_E_QL_QUERY_TYPECHAR4ESH_D_QL_QUERY_TYPE
EXEC_MODESearch Execution Mode (Functional/Special) ESH_E_IF_SEARCH_EXEC_MODECHAR1ESH_D_IF_SEARCH_EXEC_MODE
EXEC_TSTPExecution Timestamp ESH_E_QL_EXEC_TSTPDEC21(7) TZNTSTMPL
EXEC_USERExecution User ESH_E_CO_EXEC_USERCHAR12UNAME
REF_TYPEParent Query Reference Type ESH_E_QL_REF_TYPECHAR4ESH_D_QL_REF_TYPE
REF_IDSearch Execution ID ESH_E_IF_SEARCH_EXEC_IDCHAR32ESH_D_IF_SEARCH_EXEC_ID
INTERVAL_FROMSearch Start Index ESH_E_CO_START_IDXINT410
INTERVAL_TOSearch End Index ESH_E_CO_END_IDXINT410
TIMEOUTSearch Timeout (secs) ESH_E_FED_TIMEOUTINT410INT4
VALIDITY_DATESearch Date (Date-Specific Search) ESH_E_CO_SEARCH_DATEDATS8DATUM
SEARCH_LANGU2-Character SAP Language Code LAISOCHAR2LAISO
SEARCH_MODETerm Action (Search Mode, e.g. Denoting Fuzzy Search) ESH_E_CO_TERM_ACTIONCHAR1CHAR01
FUZZY_SIMILARITYFuzzy Similarity 0..10000 ESH_E_FED_FUZZY_SIMILARITYINT410
HITSNumber of Hits ESH_E_QL_HITSINT410
TOTAL_HITSTotal Number of Hits ESH_E_QL_TOTAL_HITSINT410
ENDED_WITH_EXCEnded with Exception ESH_E_QL_ENDED_WITH_EXCCHAR1
STAT_CONN_ALLResponse Statistics: Number of Connectors in Query ESH_E_QL_STAT_CONN_ALLINT410
STAT_CONN_SUCCResponse Statistics: Number of Connectors Returning Results ESH_E_QL_STAT_CONN_SUCCINT410
STAT_CONN_NORESResponse Statistics: Number of Connectors Not Returning Res. ESH_E_QL_STAT_CONN_NORESINT410
STAT_CONN_ERRORResponse Statistics: Number of Connectors with Errors ESH_E_QL_STAT_CONN_ERRORINT410
STAT_ACTIONSClick Registrator Statistics: Number of Actions ESH_E_QL_STAT_ACTIONSINT410
RUNTIME_TOTALSearch Execution Runtime - Total ESH_E_QL_RUNTIME_TOTALINT410

Key field Non-key field



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

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

How to access SAP table ESH_S_QL_QLOG

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

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