SAP ABAP Table ESH_QL_QLOG (Query Log)

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	TRANSP	Transparent table
Transparent table	ESH_QL_QLOG	Table Relationship Diagram
Short Description	Query Log

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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