SAP ABAP Table ESH_S_QL_QLOG_DATA_PROVIDER (DataProvider Structure for ESH_QUERY_LOG Root Node 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	INTTAB	Structure
Structure	ESH_S_QL_QLOG_DATA_PROVIDER	Table Relationship Diagram
Short Description	DataProvider Structure for ESH_QUERY_LOG Root Node QUERY_LOG

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 Header
2	.INCLUDE	☐				0	0	Query Log
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	EXEC_ID	☐	ESH_E_IF_SEARCH_EXEC_ID	ESH_D_IF_SEARCH_EXEC_ID	CHAR	32	0	Search Execution ID
5	SESSION_ID	☐	ESH_E_IF_SEARCH_SESSION_ID		CHAR	32	0	Search Session ID
6	QUERY_TYPE	☐	ESH_E_QL_QUERY_TYPE	ESH_D_QL_QUERY_TYPE	CHAR	4	0	Internal Query Type (Sync, Async, Bulk, Delegated)
7	EXEC_MODE	☐	ESH_E_IF_SEARCH_EXEC_MODE	ESH_D_IF_SEARCH_EXEC_MODE	CHAR	1	0	Search Execution Mode (Functional/Special)
8	EXEC_TSTP	☐	ESH_E_QL_EXEC_TSTP	TZNTSTMPL	DEC	21	7	Execution Timestamp
9	EXEC_USER	☐	ESH_E_CO_EXEC_USER	UNAME	CHAR	12	0	Execution User
10	REF_TYPE	☐	ESH_E_QL_REF_TYPE	ESH_D_QL_REF_TYPE	CHAR	4	0	Parent Query Reference Type
11	REF_ID	☐	ESH_E_IF_SEARCH_EXEC_ID	ESH_D_IF_SEARCH_EXEC_ID	CHAR	32	0	Search Execution ID
12	INTERVAL_FROM	☐	ESH_E_CO_START_IDX		INT4	10	0	Search Start Index
13	INTERVAL_TO	☐	ESH_E_CO_END_IDX		INT4	10	0	Search End Index
14	TIMEOUT	☐	ESH_E_FED_TIMEOUT	INT4	INT4	10	0	Search Timeout (secs)
15	VALIDITY_DATE	☐	ESH_E_CO_SEARCH_DATE	DATUM	DATS	8	0	Search Date (Date-Specific Search)
16	SEARCH_LANGU	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
17	SEARCH_MODE	☐	ESH_E_CO_TERM_ACTION	CHAR01	CHAR	1	0	Term Action (Search Mode, e.g. Denoting Fuzzy Search)
18	FUZZY_SIMILARITY	☐	ESH_E_FED_FUZZY_SIMILARITY		INT4	10	0	Fuzzy Similarity 0..10000
19	HITS	☐	ESH_E_QL_HITS		INT4	10	0	Number of Hits
20	TOTAL_HITS	☐	ESH_E_QL_TOTAL_HITS		INT4	10	0	Total Number of Hits
21	ENDED_WITH_EXC	☐	ESH_E_QL_ENDED_WITH_EXC		CHAR	1	0	Ended with Exception
22	STAT_CONN_ALL	☐	ESH_E_QL_STAT_CONN_ALL		INT4	10	0	Response Statistics: Number of Connectors in Query
23	STAT_CONN_SUCC	☐	ESH_E_QL_STAT_CONN_SUCC		INT4	10	0	Response Statistics: Number of Connectors Returning Results
24	STAT_CONN_NORES	☐	ESH_E_QL_STAT_CONN_NORES		INT4	10	0	Response Statistics: Number of Connectors Not Returning Res.
25	STAT_CONN_ERROR	☐	ESH_E_QL_STAT_CONN_ERROR		INT4	10	0	Response Statistics: Number of Connectors with Errors
26	STAT_ACTIONS	☐	ESH_E_QL_STAT_ACTIONS		INT4	10	0	Click Registrator Statistics: Number of Actions
27	RUNTIME_TOTAL	☐	ESH_E_QL_RUNTIME_TOTAL		INT4	10	0	Search Execution Runtime - Total
28	SCOPE_ITEM_TYPE	☐	ESH_E_QL_SCOPE_ITEM_TYPE	ESH_D_CM_SCOPE_ITEM_TYPE	CHAR	1	0	Query Log Scope Item Type
29	SCOPE_ELEMENT	☐	ESH_E_QL_SCOPE_ELEMENT		SSTR	360	0	Query Log Scope Element
30	QUERY_LANGU	☐	ESH_E_QL_QUERY_LANGU	SPRAS	LANG	1	0	Logon Language on Query Execution	*
31	SEARCH_STRING	☐	ESH_E_FED_SEARCH_STRING		STRG	0	0	Search String
32	USES_ATTRIBUTE_CONDITIONS	☐	CHAR01	CHAR1	CHAR	1	0	Character Field Length 1
33	USES_QUERY_PARTS	☐	ESH_E_QL_USES_QUERY_PARTS		CHAR	1	0	Uses Query Parts

History

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