ESH_QL_USR_STAT - Personalized Search Term Statistics
Personalized Search Term Statistics information is stored in SAP table ESH_QL_USR_STAT.
It is part of development package S_ESH_ENG_QUERY_LOGGING in software component BC-EIM-ESH. This development package consists of objects that can be grouped under "Query Logging".
It is part of development package S_ESH_ENG_QUERY_LOGGING in software component BC-EIM-ESH. This development package consists of objects that can be grouped under "Query Logging".
Fields for table ESH_QL_USR_STAT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| EXEC_USER | Personalization User | X | ESH_E_CM_PERS_USER | CHAR | 24 | |
| CONTENT_HKY | Query Log Content Hashkey | X | ESH_E_QL_HKY | RAW | 20 | |
| CONTENT_MGR_APPL | Content Manager Application (Classname) | X | ESH_E_CM_CONTENT_MGR_APPL | CHAR | 60 | |
| SCOPE_ITEM_TYPE | Query Log Scope Item Type | ESH_E_QL_SCOPE_ITEM_TYPE | CHAR | 2 | ||
| SCOPE_ELEMENT | Query Log Scope Element | ESH_E_QL_SCOPE_ELEMENT | SSTR | 8 | ||
| QUERY_LANGU | Term Language (ISO Format) | ESH_E_CM_TERM_LANGU | CHAR | 4 | ||
| SEARCH_STRING | Term | ESH_E_CM_TERM | SSTR | 8 | ||
| LAST_EXEC_TSTP | Execution Timestamp | ESH_E_QL_EXEC_TSTP | DEC | 11 | ||
| RANK_ORIG | Rank Value (Original) | ESH_E_CM_RANK_ORIG | INT4 | 4 | ||
| RANK_WEIGHTED | Rank Value (Weighted) | ESH_E_CM_RANK_WEIGHTED | INT4 | 4 | ||
| MANUAL_ENTRY | Manual Entry | ESH_E_CM_MANUAL_ENTRY | CHAR | 20 | ||
| UPD_TIMESTAMP | Timestamp (Last Update) | ESH_E_CM_TIMESTAMP | DEC | 11 | ||
| UPD_USER | User Name | ESH_E_CM_USER | CHAR | 24 |