SAP ESH_QL_ST_STAT Searchterm Statistics Table for Indexing of Statistics Data Table data and field list

ESH_QL_ST_STAT is a standard SAP Table which is used to store Searchterm Statistics Table for Indexing of Statistics Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_QL_ST_STAT table consists of various fields, each holding specific information or linking keys about Searchterm Statistics Table for Indexing of Statistics Data data available in SAP. These include CONTENT_HKY (Query Log Content Hashkey), CONTENT_MGR_APPL (Content Manager Application (Classname)), SCOPE_ITEM_TYPE (Query Log Scope Item Type), SCOPE_ELEMENT (Query Log Scope Element)... 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_QL_ST_STAT table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP ESH_QL_ST_STAT table 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_QL_ST_STAT 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
CONTENT_HKY	Query Log Content Hashkey	ESH_E_QL_HKY	RAW	20			ESH_D_QL_HKY
CONTENT_MGR_APPL	Content Manager Application (Classname)	ESH_E_CM_CONTENT_MGR_APPL	CHAR	30			CLASSNAME
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	Term Language (ISO Format)	ESH_E_CM_TERM_LANGU	CHAR	2			LAISO
SEARCH_STRING	Term	ESH_E_CM_TERM	SSTR	360			ESH_D_CM_TERM
RANK_ORIG	Rank Value (Original)	ESH_E_CM_RANK_ORIG	INT4	10
RANK_WEIGHTED	Rank Value (Weighted)	ESH_E_CM_RANK_WEIGHTED	INT4	10
MANUAL_ENTRY	Manual Entry	ESH_E_CM_MANUAL_ENTRY	CHAR	10			ESH_D_CM_MANUAL_ENTRY
UPD_TIMESTAMP	Timestamp (Last Update)	ESH_E_CM_TIMESTAMP	DEC	21(7)			TZNTSTMPL
UPD_USER	User Name	ESH_E_CM_USER	CHAR	12			USERNAME

Key field

Non-key field

< ESH_QL_ST_EXCL - Searchterm Exclusions Table ESH_QP_QUE_DESC - Query Description >

How do I retrieve data from SAP table ESH_QL_ST_STAT using ABAP code

The following ABAP code Example will allow you to do a basic selection on ESH_QL_ST_STAT to SELECT all data from the table
DATA: WA_ESH_QL_ST_STAT TYPE ESH_QL_ST_STAT.

SELECT SINGLE *
FROM ESH_QL_ST_STAT
INTO CORRESPONDING FIELDS OF WA_ESH_QL_ST_STAT
WHERE...

How to access SAP table ESH_QL_ST_STAT

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

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