SAP ABAP Table ESH_S_QL_QLOG (Query Log Header)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-EIM-ESH (Application Component) NetWeaver Enterprise Search
     ⤷ S_ESH_ENG_QUERY_LOGGING (Package) Query Logging

Basic Data

Table Category	INTTAB	Structure
Structure	ESH_S_QL_QLOG	Table Relationship Diagram
Short Description	Query Log Header

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Query Log
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	EXEC_ID	☐	ESH_E_IF_SEARCH_EXEC_ID	ESH_D_IF_SEARCH_EXEC_ID	CHAR	32	0	Search Execution ID
4	SESSION_ID	☐	ESH_E_IF_SEARCH_SESSION_ID		CHAR	32	0	Search Session ID
5	QUERY_TYPE	☐	ESH_E_QL_QUERY_TYPE	ESH_D_QL_QUERY_TYPE	CHAR	4	0	Internal Query Type (Sync, Async, Bulk, Delegated)
6	EXEC_MODE	☐	ESH_E_IF_SEARCH_EXEC_MODE	ESH_D_IF_SEARCH_EXEC_MODE	CHAR	1	0	Search Execution Mode (Functional/Special)
7	EXEC_TSTP	☐	ESH_E_QL_EXEC_TSTP	TZNTSTMPL	DEC	21	7	Execution Timestamp
8	EXEC_USER	☐	ESH_E_CO_EXEC_USER	UNAME	CHAR	12	0	Execution User
9	REF_TYPE	☐	ESH_E_QL_REF_TYPE	ESH_D_QL_REF_TYPE	CHAR	4	0	Parent Query Reference Type
10	REF_ID	☐	ESH_E_IF_SEARCH_EXEC_ID	ESH_D_IF_SEARCH_EXEC_ID	CHAR	32	0	Search Execution ID
11	INTERVAL_FROM	☐	ESH_E_CO_START_IDX		INT4	10	0	Search Start Index
12	INTERVAL_TO	☐	ESH_E_CO_END_IDX		INT4	10	0	Search End Index
13	TIMEOUT	☐	ESH_E_FED_TIMEOUT	INT4	INT4	10	0	Search Timeout (secs)
14	VALIDITY_DATE	☐	ESH_E_CO_SEARCH_DATE	DATUM	DATS	8	0	Search Date (Date-Specific Search)
15	SEARCH_LANGU	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
16	SEARCH_MODE	☐	ESH_E_CO_TERM_ACTION	CHAR01	CHAR	1	0	Term Action (Search Mode, e.g. Denoting Fuzzy Search)
17	FUZZY_SIMILARITY	☐	ESH_E_FED_FUZZY_SIMILARITY		INT4	10	0	Fuzzy Similarity 0..10000
18	HITS	☐	ESH_E_QL_HITS		INT4	10	0	Number of Hits
19	TOTAL_HITS	☐	ESH_E_QL_TOTAL_HITS		INT4	10	0	Total Number of Hits
20	ENDED_WITH_EXC	☐	ESH_E_QL_ENDED_WITH_EXC		CHAR	1	0	Ended with Exception
21	STAT_CONN_ALL	☐	ESH_E_QL_STAT_CONN_ALL		INT4	10	0	Response Statistics: Number of Connectors in Query
22	STAT_CONN_SUCC	☐	ESH_E_QL_STAT_CONN_SUCC		INT4	10	0	Response Statistics: Number of Connectors Returning Results
23	STAT_CONN_NORES	☐	ESH_E_QL_STAT_CONN_NORES		INT4	10	0	Response Statistics: Number of Connectors Not Returning Res.
24	STAT_CONN_ERROR	☐	ESH_E_QL_STAT_CONN_ERROR		INT4	10	0	Response Statistics: Number of Connectors with Errors
25	STAT_ACTIONS	☐	ESH_E_QL_STAT_ACTIONS		INT4	10	0	Click Registrator Statistics: Number of Actions
26	RUNTIME_TOTAL	☐	ESH_E_QL_RUNTIME_TOTAL		INT4	10	0	Search Execution Runtime - Total

History

Last changed by/on	SAP	20140117
SAP Release Created in	730