SAP ESH_S_QL_QLCUST Query Log Customizing Table data and field list

ESH_S_QL_QLCUST 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 "Query Log Customizing" 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_QLCUST TYPE ESH_S_QL_QLCUST.

The ESH_S_QL_QLCUST table consists of various fields, each holding specific information or linking keys about Query Log Customizing data available in SAP. These include MANDT (Client), QLCUST_ID (Character field, length 32), VALIDITY_USER (User name), LOG_QUERIES (Custom Settings: Log Queries)... 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_QLCUST 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_QLCUST 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_QLCUST 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
QLCUST_ID	Character field, length 32	CHAR32	CHAR	32			CHAR32
VALIDITY_USER	User name	USERNAME	CHAR	12			USERNAME
LOG_QUERIES	Custom Settings: Log Queries	ESH_E_QL_CUST_LOG_QUERIES	CHAR	1
LOG_PERFORMANCE	Custom Settings: Log Performance Times	ESH_E_QL_CUST_LOG_PERFORMANCE	CHAR	1
ANONYMIZATION	Anonymization Level	ESH_E_QL_CUST_ANONYMIZATION	CHAR	1			ESH_D_QL_CUST_ANONYMIZATION
ALLOW_PERS	Allow Personalization	ESH_E_QL_CUST_ALLOW_PERS	CHAR	1
REQ_USER_CONSENT	Require User Consent for Logging	ESH_E_QL_CUST_REQ_USER_CONSENT	CHAR	1
LOG_LOG_ACCESSES	Record Log Accesses	ESH_E_QL_CUST_LOG_LOG_ACCESSES	CHAR	1			ESH_D_QL_CUST_LOG_LOG_ACCESSES
QL_AGGREG	Aggregate Query Log (Searchterm Statistics for Type-Ahead)	ESH_E_QL_CUST_QL_AGGREG	CHAR	1			ESH_D_QL_CUST_QL_AGGREG
QL_AGGREG_INTERV	Query Log Aggregation Interval (Aggregate last ... days)	ESH_E_QL_CUST_QL_AGGREG_INTERV	NUMC	4			ESH_D_QL_CUST_QL_AGGREG_INTERV
QL_AGGREG_FREQ	Query Log Aggregation Frequency (Aggregate all ... hours)	ESH_E_QL_CUST_QL_AGGREG_FREQ	NUMC	4			ESH_D_QL_CUST_QL_AGGREG_FREQ
LAST_UPD_USER	User name	USERNAME	CHAR	12			USERNAME
LAST_UPD_TSP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS

Key field

Non-key field

< ESH_S_QL_LOG_RESPONSES - Log Responses Aggregated ESH_S_QL_QLOG - Query Log Header >

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

As ESH_S_QL_QLCUST 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_QLCUST as there is no data to select.

How to access SAP table ESH_S_QL_QLCUST

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

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