ESH_QL_SESSTRL - Search Transaction - Link to Events and Related Query Execs
Search Transaction - Link to Events and Related Query Execs information is stored in SAP table ESH_QL_SESSTRL.
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_SESSTRL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| SESSION_ID | Search Session ID | X | ESH_E_IF_SEARCH_SESSION_ID | CHAR | 64 | |
| TRANSACTION_ID | Search Transaction ID | X | ESH_E_IF_SEARCH_TRANSACTION_ID | CHAR | 64 | |
| SESSTRL_GUID | Session Analysis: Transaction Link GUID | X | ESH_E_QL_SESSTRL_GUID | CHAR | 64 | |
| EVENT_SEQNO | Session Event Sequence Number | ESH_E_QL_EVENT_SEQNO | INT4 | 4 | ||
| EXEC_ID_TRIGGERED | Search Execution ID | ESH_E_IF_SEARCH_EXEC_ID | CHAR | 64 | ||
| TERM_SIMILARITY | Term Similarity | ESH_E_QL_TERM_SIMILARITY | INT4 | 4 | ||
| TERM_EVOLVEMENT | Term Evolvement | ESH_E_QL_TERM_EVOLVEMENT | SSTR | 8 | ||
| SIGNIFICANT_CHANGE | Character Field of Length 1 | CHAR01 | CHAR | 2 | ||
| SCOPE_CHANGE | Character Field of Length 1 | CHAR01 | CHAR | 2 | ||
| LARGE_TIME_GAP | Character Field of Length 1 | CHAR01 | CHAR | 2 | ||
| TR_DET_USER | Transaction Determination Job User | ESH_E_QL_TR_DET_USER | CHAR | 24 | ||
| TR_DET_TSP | Transaction Determination Timestamp | ESH_E_QL_TR_DET_TSP | DEC | 11 |