SAP ESH_S_QL_QLOG_DATA_PROVIDER DataProvider Structure for ESH_QUERY_LOG Root Node QUERY_LOG Table data and field list

ESH_S_QL_QLOG_DATA_PROVIDER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DataProvider Structure for ESH_QUERY_LOG Root Node QUERY_LOG" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ESH_S_QL_QLOG_DATA_PROVIDER TYPE ESH_S_QL_QLOG_DATA_PROVIDER.

The ESH_S_QL_QLOG_DATA_PROVIDER table consists of various fields, each holding specific information or linking keys about DataProvider Structure for ESH_QUERY_LOG Root Node QUERY_LOG data available in SAP. These include MANDT (Client), EXEC_ID (Search Execution ID), SESSION_ID (Search Session ID), QUERY_TYPE (Internal Query Type (Sync, Async, Bulk, Delegated))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ESH_S_QL_QLOG_DATA_PROVIDER structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP ESH_S_QL_QLOG_DATA_PROVIDER structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ESH_S_QL_QLOG_DATA_PROVIDER table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
EXEC_ID	Search Execution ID	ESH_E_IF_SEARCH_EXEC_ID	CHAR	32			ESH_D_IF_SEARCH_EXEC_ID
SESSION_ID	Search Session ID	ESH_E_IF_SEARCH_SESSION_ID	CHAR	32
QUERY_TYPE	Internal Query Type (Sync, Async, Bulk, Delegated)	ESH_E_QL_QUERY_TYPE	CHAR	4			ESH_D_QL_QUERY_TYPE
EXEC_MODE	Search Execution Mode (Functional/Special)	ESH_E_IF_SEARCH_EXEC_MODE	CHAR	1			ESH_D_IF_SEARCH_EXEC_MODE
EXEC_TSTP	Execution Timestamp	ESH_E_QL_EXEC_TSTP	DEC	21(7)			TZNTSTMPL
EXEC_USER	Execution User	ESH_E_CO_EXEC_USER	CHAR	12			UNAME
REF_TYPE	Parent Query Reference Type	ESH_E_QL_REF_TYPE	CHAR	4			ESH_D_QL_REF_TYPE
REF_ID	Search Execution ID	ESH_E_IF_SEARCH_EXEC_ID	CHAR	32			ESH_D_IF_SEARCH_EXEC_ID
INTERVAL_FROM	Search Start Index	ESH_E_CO_START_IDX	INT4	10
INTERVAL_TO	Search End Index	ESH_E_CO_END_IDX	INT4	10
TIMEOUT	Search Timeout (secs)	ESH_E_FED_TIMEOUT	INT4	10			INT4
VALIDITY_DATE	Search Date (Date-Specific Search)	ESH_E_CO_SEARCH_DATE	DATS	8			DATUM
SEARCH_LANGU	2-Character SAP Language Code	LAISO	CHAR	2			LAISO
SEARCH_MODE	Term Action (Search Mode, e.g. Denoting Fuzzy Search)	ESH_E_CO_TERM_ACTION	CHAR	1			CHAR01
FUZZY_SIMILARITY	Fuzzy Similarity 0..10000	ESH_E_FED_FUZZY_SIMILARITY	INT4	10
HITS	Number of Hits	ESH_E_QL_HITS	INT4	10
TOTAL_HITS	Total Number of Hits	ESH_E_QL_TOTAL_HITS	INT4	10
ENDED_WITH_EXC	Ended with Exception	ESH_E_QL_ENDED_WITH_EXC	CHAR	1
STAT_CONN_ALL	Response Statistics: Number of Connectors in Query	ESH_E_QL_STAT_CONN_ALL	INT4	10
STAT_CONN_SUCC	Response Statistics: Number of Connectors Returning Results	ESH_E_QL_STAT_CONN_SUCC	INT4	10
STAT_CONN_NORES	Response Statistics: Number of Connectors Not Returning Res.	ESH_E_QL_STAT_CONN_NORES	INT4	10
STAT_CONN_ERROR	Response Statistics: Number of Connectors with Errors	ESH_E_QL_STAT_CONN_ERROR	INT4	10
STAT_ACTIONS	Click Registrator Statistics: Number of Actions	ESH_E_QL_STAT_ACTIONS	INT4	10
RUNTIME_TOTAL	Search Execution Runtime - Total	ESH_E_QL_RUNTIME_TOTAL	INT4	10
SCOPE_ITEM_TYPE	Query Log Scope Item Type	ESH_E_QL_SCOPE_ITEM_TYPE	CHAR	1			ESH_D_CM_SCOPE_ITEM_TYPE
SCOPE_ELEMENT	Query Log Scope Element	ESH_E_QL_SCOPE_ELEMENT	SSTR	360
QUERY_LANGU	Logon Language on Query Execution	ESH_E_QL_QUERY_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
SEARCH_STRING	Search String	ESH_E_FED_SEARCH_STRING	STRG	0
USES_ATTRIBUTE_CONDITIONS	Character Field Length 1	CHAR01	CHAR	1			CHAR1
USES_QUERY_PARTS	Uses Query Parts	ESH_E_QL_USES_QUERY_PARTS	CHAR	1

Key field

Non-key field

< ESH_S_QL_QLOGS - Query Log Scope ESH_S_QL_QLOG_DISPLAY - Query Log Display Structure >

How do I retrieve data from SAP structure ESH_S_QL_QLOG_DATA_PROVIDER using ABAP code?

As ESH_S_QL_QLOG_DATA_PROVIDER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ESH_S_QL_QLOG_DATA_PROVIDER as there is no data to select.

How to access SAP table ESH_S_QL_QLOG_DATA_PROVIDER

Within an ECC or HANA version of SAP you can also view further information about ESH_S_QL_QLOG_DATA_PROVIDER and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).