ESH_QL_QLOG - Query Log
Query Log information is stored in SAP table ESH_QL_QLOG.
It is part of development package S_ESH_ENG_QUERY_LOGGING in software component BC-EIM-ESH. This development package consists of objects that can be grouped under "Query Logging".
It is part of development package S_ESH_ENG_QUERY_LOGGING in software component BC-EIM-ESH. This development package consists of objects that can be grouped under "Query Logging".
Fields for table ESH_QL_QLOG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| EXEC_ID | Search Execution ID | X | ESH_E_IF_SEARCH_EXEC_ID | CHAR | 64 | |
| SESSION_ID | Search Session ID | ESH_E_IF_SEARCH_SESSION_ID | CHAR | 64 | ||
| QUERY_TYPE | Internal Query Type (Sync, Async, Bulk, Delegated) | ESH_E_QL_QUERY_TYPE | CHAR | 8 | ||
| EXEC_MODE | Search Execution Mode | ESH_E_IF_SEARCH_EXEC_MODE | CHAR | 2 | ||
| EXEC_TSTP | Execution Timestamp | ESH_E_QL_EXEC_TSTP | DEC | 11 | ||
| EXEC_USER | Execution User | ESH_E_CO_EXEC_USER | CHAR | 24 | ||
| REF_TYPE | Parent Query Reference Type | ESH_E_QL_REF_TYPE | CHAR | 8 | ||
| REF_ID | Search Execution ID | ESH_E_IF_SEARCH_EXEC_ID | CHAR | 64 | ||
| INTERVAL_FROM | Search Start Index | ESH_E_CO_START_IDX | INT4 | 4 | ||
| INTERVAL_TO | Search End Index | ESH_E_CO_END_IDX | INT4 | 4 | ||
| TIMEOUT | Search Timeout (secs) | ESH_E_FED_TIMEOUT | INT4 | 4 | ||
| VALIDITY_DATE | Search Date (Date-Specific Search) | ESH_E_CO_SEARCH_DATE | DATS | 16 | ||
| SEARCH_LANGU | 2-Character SAP Language Code | LAISO | CHAR | 4 | ||
| SEARCH_MODE | Term Action (Search Mode, e.g. Denoting Fuzzy Search) | ESH_E_CO_TERM_ACTION | CHAR | 2 | ||
| FUZZY_SIMILARITY | Fuzzy Similarity 0..10000 | ESH_E_FED_FUZZY_SIMILARITY | INT4 | 4 | ||
| HITS | Number of Hits | ESH_E_QL_HITS | INT8 | 8 | ||
| TOTAL_HITS | Total Number of Hits | ESH_E_QL_TOTAL_HITS | INT8 | 8 | ||
| ENDED_WITH_EXC | Ended with Exception | ESH_E_QL_ENDED_WITH_EXC | CHAR | 2 | ||
| STAT_CONN_ALL | Response Statistics: Number of Connectors in Query | ESH_E_QL_STAT_CONN_ALL | INT4 | 4 | ||
| STAT_CONN_SUCC | Response Statistics: Number of Connectors Returning Results | ESH_E_QL_STAT_CONN_SUCC | INT4 | 4 | ||
| STAT_CONN_NORES | Response Statistics: Number of Connectors Not Returning Res. | ESH_E_QL_STAT_CONN_NORES | INT4 | 4 | ||
| STAT_CONN_ERROR | Response Statistics: Number of Connectors with Errors | ESH_E_QL_STAT_CONN_ERROR | INT4 | 4 | ||
| STAT_ACTIONS | Click Registrator Statistics: Number of Actions | ESH_E_QL_STAT_ACTIONS | INT4 | 4 | ||
| RUNTIME_TOTAL | Search Execution Runtime - Total | ESH_E_QL_RUNTIME_TOTAL | INT4 | 4 | ||
| RUNTIME_HANA | Search Execution Runtime - HANA Search Engine | ESH_E_QL_RUNTIME_HANA | INT4 | 4 | ||
| RUNTIME_HANA_CPU | Search Execution Runtime - HANA CPU (only CDS-Based Queries) | ESH_E_QL_RUNTIME_HANA_CPU | INT4 | 4 | ||
| MAX_RANK_VALUE | Maximum Rank Value in Response | ESH_E_QL_MAX_RANK_VALUE | INT4 | 4 | ||
| SEARCH_SERVICE | Search Service | ESH_E_IF_SEARCH_SERVICE | CHAR | 128 | ||
| EVENT_CLTSP | Client-Side Event Timestamp | ESH_E_QL_EVENT_CLTSP | DEC | 11 | ||
| LQAID | Query Log LQA ID | ESH_E_QL_LQAID | CHAR | 64 | ||
| CALLER | Caller of ESH Search API | ESH_E_QL_CALLER | CHAR | 256 | ||
| CALLER_APPL_COMP | Caller Application Component | ESH_E_QL_CALLER_APPL_COMP | CHAR | 48 | ||
| DISCARDED | Query Log Entry: Discarded Flag | ESH_E_QL_DISCARDED | CHAR | 2 |