SAP ESH_QL_QLOG Query Log Table data and field list

ESH_QL_QLOG is a standard SAP Table which is used to store Query Log data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_QL_QLOG table consists of various fields, each holding specific information or linking keys about Query Log data available in SAP. These include EXEC_ID (Search Execution ID), SESSION_ID (Search Session ID), QUERY_TYPE (Internal Query Type (Sync, Async, Bulk, Delegated)), EXEC_MODE (Search Execution Mode (Functional/Special))... 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_QL_QLOG table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_QL_QLOG table 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_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 table ESH_QL_QLOG using ABAP code

The following ABAP code Example will allow you to do a basic selection on ESH_QL_QLOG to SELECT all data from the table
DATA: WA_ESH_QL_QLOG TYPE ESH_QL_QLOG.

SELECT SINGLE *
FROM ESH_QL_QLOG
INTO CORRESPONDING FIELDS OF WA_ESH_QL_QLOG
WHERE...

How to access SAP table ESH_QL_QLOG

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