Field
Type
Length
Data element
Description
EXEC_ID
CHAR
000032
Search Execution ID
SESSION_ID
CHAR
000032
Search Session ID
QUERY_TYPE
CHAR
000004
Internal Query Type (Sync, Async, Bulk, Delegated)
EXEC_MODE
CHAR
000001
Search Execution Mode
EXEC_TSTP
DEC
000021
Execution Timestamp
EXEC_USER
CHAR
000012
Execution User
REF_TYPE
CHAR
000004
Parent Query Reference Type
REF_ID
CHAR
000032
Search Execution ID
INTERVAL_FROM
INT4
000010
Search Start Index
INTERVAL_TO
INT4
000010
Search End Index
TIMEOUT
INT4
000010
Search Timeout (secs)
VALIDITY_DATE
DATS
000008
Search Date (Date-Specific Search)
SEARCH_LANGU
CHAR
000002
2-Character SAP Language Code
SEARCH_MODE
CHAR
000001
Term Action (Search Mode, e.g. Denoting Fuzzy Search)
FUZZY_SIMILARITY
INT4
000010
Fuzzy Similarity 0..10000
HITS
INT8
000019
Number of Hits
TOTAL_HITS
INT8
000019
Total Number of Hits
ENDED_WITH_EXC
CHAR
000001
Ended with Exception
STAT_CONN_ALL
INT4
000010
Response Statistics: Number of Connectors in Query
STAT_CONN_SUCC
INT4
000010
Response Statistics: Number of Connectors Returning Results
STAT_CONN_NORES
INT4
000010
Response Statistics: Number of Connectors Not Returning Res.
STAT_CONN_ERROR
INT4
000010
Response Statistics: Number of Connectors with Errors
STAT_ACTIONS
INT4
000010
Click Registrator Statistics: Number of Actions
RUNTIME_TOTAL
INT4
000010
Search Execution Runtime - Total
RUNTIME_HANA
INT4
000010
Search Execution Runtime - HANA Search Engine
RUNTIME_HANA_CPU
INT4
000010
Search Execution Runtime - HANA CPU (only CDS-Based Queries)
MAX_RANK_VALUE
INT4
000010
Maximum Rank Value in Response
SEARCH_SERVICE
CHAR
000064
Search Service
EVENT_CLTSP
DEC
000021
Client-Side Event Timestamp
LQAID
CHAR
000032
Query Log LQA ID
DISCARDED
CHAR
000001
Query Log Entry: Discarded Flag
HASHKEY
RAW
000020
Query Log Content Hashkey
CONTENT_TYPE
CHAR
000004
Query Log Content Type
FREESTYLE_TERMS
CHAR
000128
Freestyle Terms (up to char128)
IS_GET_ALL
CHAR
000001
Freestyle Query: Is Get-All Condition ('' or *-Query)
IS_SINGLE_TERM
CHAR
000001
Freestyle Query: Is Single Term
IS_MULTI_TERM
CHAR
000001
Freestyle Query: Is Multiple-Term Condition
IS_NUMERIC
CHAR
000001
Freestyle Term: Is Numeric
CONTAINS_TERM_W_WILDC
CHAR
000001
Freestyle Query: Contains Term with Wildcard
CONTAINS_OR_CONJ
CHAR
000001
Freestyle Query: Contains OR-Conjunction
CONTAINS_NEGATION
CHAR
000001
Freestyle Query: Contains Negation
CONTAINS_PHRASE
CHAR
000001
Freestyle Query: Contains Phrase
CONTAINS_QL_EXPR
CHAR
000001
Freestyle Query: Contains Query Language Expression
SEARCH_MODE
CHAR
000001
Search Mode
FUZZY_SIMILARITY
INT4
000010
Fuzzy Similarity 0..10000
IS_LONG_TERM
CHAR
000001
Is Long Term (longer than 128 characters -> string)
FREESTYLE_TERMS_STRG
STRG
000000
Freestyle Terms (long terms - string)
SESSION_ID
CHAR
000032
Search Session ID
TRANSACTION_ID
CHAR
000032
Search Transaction ID
EVENT_FROM
INT4
000010
Session Event Sequence Number - Transaction Start
EVENT_TO
INT4
000010
Session Event Sequence Number - Transaction End
TR_DET_SERVICE
CHAR
000032
Transaction Determination Service
TR_DET_USER
CHAR
000012
Transaction Determination Job User
TR_DET_TSP
DEC
000021
Transaction Determination Timestamp
TR_DET_JOBID
CHAR
000032
Transaction Determination Job ID
SESSION_ID
CHAR
000032
Search Session ID
EVENT_SEQNO
INT4
000010
Session Event Sequence Number
EVENT_ID
CHAR
000040
Session Event ID
EVENT_CLTSP
DEC
000021
Client-Side Event Timestamp
EVENT_RELTSP
DEC
000021
Event Relative Timestamp (Relative to Session Start)
REF_EXEC_ID
CHAR
000032
Search Execution ID
Length: 20864 Date: 20240420 Time: 025408 sap01-206 ( 37 ms )
