SAP ABAP Table ESH_S_QL_QLOG_DISPLAY (Query Log Display Structure)

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_DISPLAY	Table Relationship Diagram
Short Description	Query Log Display Structure

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	ITEM_TYPE	☐	CHAR01	CHAR1	CHAR	1	0	Character Field Length 1
2	FLDICON	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64
3	STATUSICON	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64
4	STATUS	☐	ESH_E_QL_STATUS	ESH_D_QL_STATUS	CHAR	1	0	Query Item Status
5	EXEC_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
6	EXEC_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
7	QUERY_TYPE_INFO	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64
8	QUERY_LANGU	☐	ESH_E_QL_QUERY_LANGU	SPRAS	LANG	1	0	Logon Language on Query Execution	*
9	QUERY_EXCERPT	☐	ESH_E_QL_QUERY_EXCERPT		CHAR	120	0	Query Text / Query Excerpt
10	ITEM_COUNT	☐	NUM4	NUM04	NUMC	4	0	Four-digit number
11	CONNECTOR_ID	☐	ESH_E_IF_SEARCH_CONNECTOR_ID	ESH_D_IF_IDENTIFIER_LONG	CHAR	120	0	Search Connector ID
12	QUERY_SYS	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
13	QUERY_CLT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
14	QUERY_SYS_EXT	☐	ESH_E_ADM_EXTERNAL_SYSTEM_ID	CHAR6	CHAR	6	0	Identifier for an External System
15	OBJ_TYPE	☐	CHAR22	CHAR22	CHAR	22	0	Text string 22 characters
16	CONNECTION_GUID	☐	ESH_E_ADM_CONNECTION_GUID	SYSUUID_C	CHAR	32	0	Connection GUID
17	CONNECTION_TYPE	☐	ESH_E_ADM_CONNECTION_TYPE	ESH_D_ADM_CONNECTION_TYPE	CHAR	10	0	Connection Type
18	ACTIONICON	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64
19	.INCLUDE	☐				0	0	Query Log Header
20	.INCLUDE	☐				0	0	Query Log
21	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
22	EXEC_ID	☐	ESH_E_IF_SEARCH_EXEC_ID	ESH_D_IF_SEARCH_EXEC_ID	CHAR	32	0	Search Execution ID
23	SESSION_ID	☐	ESH_E_IF_SEARCH_SESSION_ID		CHAR	32	0	Search Session ID
24	QUERY_TYPE	☐	ESH_E_QL_QUERY_TYPE	ESH_D_QL_QUERY_TYPE	CHAR	4	0	Internal Query Type (Sync, Async, Bulk, Delegated)
25	EXEC_MODE	☐	ESH_E_IF_SEARCH_EXEC_MODE	ESH_D_IF_SEARCH_EXEC_MODE	CHAR	1	0	Search Execution Mode (Functional/Special)
26	EXEC_TSTP	☐	ESH_E_QL_EXEC_TSTP	TZNTSTMPL	DEC	21	7	Execution Timestamp
27	EXEC_USER	☐	ESH_E_CO_EXEC_USER	UNAME	CHAR	12	0	Execution User
28	REF_TYPE	☐	ESH_E_QL_REF_TYPE	ESH_D_QL_REF_TYPE	CHAR	4	0	Parent Query Reference Type
29	REF_ID	☐	ESH_E_IF_SEARCH_EXEC_ID	ESH_D_IF_SEARCH_EXEC_ID	CHAR	32	0	Search Execution ID
30	INTERVAL_FROM	☐	ESH_E_CO_START_IDX		INT4	10	0	Search Start Index
31	INTERVAL_TO	☐	ESH_E_CO_END_IDX		INT4	10	0	Search End Index
32	TIMEOUT	☐	ESH_E_FED_TIMEOUT	INT4	INT4	10	0	Search Timeout (secs)
33	VALIDITY_DATE	☐	ESH_E_CO_SEARCH_DATE	DATUM	DATS	8	0	Search Date (Date-Specific Search)
34	SEARCH_LANGU	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
35	SEARCH_MODE	☐	ESH_E_CO_TERM_ACTION	CHAR01	CHAR	1	0	Term Action (Search Mode, e.g. Denoting Fuzzy Search)
36	FUZZY_SIMILARITY	☐	ESH_E_FED_FUZZY_SIMILARITY		INT4	10	0	Fuzzy Similarity 0..10000
37	HITS	☐	ESH_E_QL_HITS		INT4	10	0	Number of Hits
38	TOTAL_HITS	☐	ESH_E_QL_TOTAL_HITS		INT4	10	0	Total Number of Hits
39	ENDED_WITH_EXC	☐	ESH_E_QL_ENDED_WITH_EXC		CHAR	1	0	Ended with Exception
40	STAT_CONN_ALL	☐	ESH_E_QL_STAT_CONN_ALL		INT4	10	0	Response Statistics: Number of Connectors in Query
41	STAT_CONN_SUCC	☐	ESH_E_QL_STAT_CONN_SUCC		INT4	10	0	Response Statistics: Number of Connectors Returning Results
42	STAT_CONN_NORES	☐	ESH_E_QL_STAT_CONN_NORES		INT4	10	0	Response Statistics: Number of Connectors Not Returning Res.
43	STAT_CONN_ERROR	☐	ESH_E_QL_STAT_CONN_ERROR		INT4	10	0	Response Statistics: Number of Connectors with Errors
44	STAT_ACTIONS	☐	ESH_E_QL_STAT_ACTIONS		INT4	10	0	Click Registrator Statistics: Number of Actions
45	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