SAP ESH_CO_QLOG OBSOLETE: Search Request Log Table data and field list

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

The ESH_CO_QLOG table consists of various fields, each holding specific information or linking keys about OBSOLETE: Search Request Log data available in SAP. These include SEARCH_REQ_ID (OBSOLETE: Search Request ID), SUBQUERY_ID (Subquery ID), EXEC_TSTP (Execution Timestamp), EXEC_USER (Execution User)... 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_CO_QLOG table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_CO_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_CO_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
SEARCH_REQ_IDOBSOLETE: Search Request ID ESH_E_CO_REQ_IDCHAR32ESH_C_CO_REQ_ID
SUBQUERY_IDSubquery ID ESH_E_CO_SUBQ_IDCHAR32ESH_D_CO_SUBQ_ID
EXEC_TSTPExecution Timestamp ESH_E_CO_EXEC_TSTPDEC15TZNTSTMPS
EXEC_USERExecution User ESH_E_CO_EXEC_USERCHAR12UNAME
CONNECTOR_IDSearch Connector ID ESH_E_IF_SEARCH_CONNECTOR_IDCHAR120ESH_D_IF_IDENTIFIER_LONG
REQUESTRequest Type ID ESH_E_IF_REQUEST_TYPE_IDCHAR32ESH_D_IF_IDENTIFIER_SHORT
START_INDEXSearch Start Index ESH_E_CO_START_IDXINT410
END_INDEXSearch End Index ESH_E_CO_END_IDXINT410
SEARCH_DATESearch Date (Date-Specific Search) ESH_E_CO_SEARCH_DATEDATS8DATUM
TERM_ACTIONTerm Action (Search Mode, e.g. Denoting Fuzzy Search) ESH_E_CO_TERM_ACTIONCHAR1CHAR01
QUERY_HKYOBSOLETE: Query Hashkey ESH_E_CO_QUERY_HKYCHAR40ESH_D_CO_HKY
QUERY_EXT_HKYOBSOLETE: Query Hashkey - External Format ESH_E_CO_QUERY_EXT_HKYCHAR40ESH_D_CO_HKY
TIME_QUERY_GROSSProcessing Runtime - Query (Gross) ESH_E_CO_TIME_QUERY_GROSSDEC15ESH_E_CO_RUNTIME
TIME_TREX_GROSSProcessing Runtime - TREX (Gross) ESH_E_CO_TIME_TREX_GROSSDEC15ESH_E_CO_RUNTIME
TIME_KERNEL_NETProcessing Runtime - Kernel (Net) ESH_E_CO_TIME_KERNEL_NETDEC15ESH_E_CO_RUNTIME
HITSNatural Number INT4INT410INT4
HITS_ALLNatural Number INT4INT410INT4
TREX_EXC_RCCharacter Field Length = 10 CHAR10CHAR10CHAR10
TREX_EXC_TXTMessage Text BAPI_MSGCHAR220TEXT220
EXEC_MODEOBSOLETE: Execution Mode ESH_E_CO_EXEC_MODECHAR1ESH_D_CO_EXEC_MODE
CONNECTOR_COUNTNatural Number INT4INT410INT4
ASYNCOBSOLETE: Asynchronous Search Request ESH_E_CO_ASYNC_CALLCHAR1ESH_D_CO_ASYNC_CALL
HANDLE_NAMESearch Request Handle Name ESH_E_SE_HANDLE_NAMECHAR32
REFERENCE_QUERYOBSOLETE: Reference Query ID ESH_E_CO_REFERENCE_QUERYCHAR20ESH_D_CO_REFERENCE_QUERY
REFERENCE_HKYOBSOLETE: Reference Response Hash Key ESH_E_CO_REFERENCE_HKYCHAR40ESH_D_CO_HKY

Key field Non-key field



How do I retrieve data from SAP table ESH_CO_QLOG using ABAP code

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

SELECT SINGLE *
FROM ESH_CO_QLOG
INTO CORRESPONDING FIELDS OF WA_ESH_CO_QLOG
WHERE...

How to access SAP table ESH_CO_QLOG

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