ESH_CO_QLOG SAP (OBSOLETE: Search Request Log) Table details

Dictionary Type: Table
Description: OBSOLETE: Search Request Log




ABAP Code to SELECT data from ESH_CO_QLOG
Related tables to ESH_CO_QLOG
Access table ESH_CO_QLOG




Table field list including key, data, relationships and ABAP select examples

ESH_CO_QLOG is a standard SAP Table which is used to store OBSOLETE: Search Request Log data and is available within R/3 SAP systems 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. .

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

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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!