SAP ESH_QL_QLOGC Query Log Content Index Table data and field list

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

The ESH_QL_QLOGC table consists of various fields, each holding specific information or linking keys about Query Log Content Index data available in SAP. These include EXEC_ID (Search Execution ID), CONTENT_TYPE (Query Log Content Type), HASHKEY (Query Log Content Hashkey), EXEC_TSTP (Execution Timestamp)... 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_QLOGC 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_QL_QLOGC 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_QLOGC 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
CONTENT_TYPEQuery Log Content Type ESH_E_QL_QLOGQ_CONTENT_TYPECHAR4ESH_D_QL_QLOGQ_CONTENT_TYPE
HASHKEYQuery Log Content Hashkey ESH_E_QL_HKYRAW20ESH_D_QL_HKY
EXEC_TSTPExecution Timestamp ESH_E_QL_EXEC_TSTPDEC21(7) TZNTSTMPL
QUERY_LANGULogon Language on Query Execution ESH_E_QL_QUERY_LANGULANG1Assigned to domainISOLASPRAS
USES_QUERY_PARTSUses Query Parts ESH_E_QL_USES_QUERY_PARTSCHAR1

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_QL_QLOGC
INTO CORRESPONDING FIELDS OF WA_ESH_QL_QLOGC
WHERE...

How to access SAP table ESH_QL_QLOGC

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

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