SAP ABAP Table ESH_QL_QLCUST (Customizing Settings for Query Logging)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-EIM-ESH (Application Component) NetWeaver Enterprise Search
     ⤷ S_ESH_ENG_QUERY_LOGGING (Package) Query Logging

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ESH_QL_QLCUST	Table Relationship Diagram
Short Description	Customizing Settings for Query Logging

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	QLCUST_ID	☑	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
3	VALIDITY_USER	☐	USERNAME	USERNAME	CHAR	12	0	User name
4	LOG_QUERIES	☐	ESH_E_QL_CUST_LOG_QUERIES		CHAR	1	0	Custom Settings: Log Queries
5	LOG_PERFORMANCE	☐	ESH_E_QL_CUST_LOG_PERFORMANCE		CHAR	1	0	Custom Settings: Log Performance Times
6	ANONYMIZATION	☐	ESH_E_QL_CUST_ANONYMIZATION	ESH_D_QL_CUST_ANONYMIZATION	CHAR	1	0	Anonymization Level
7	ALLOW_PERS	☐	ESH_E_QL_CUST_ALLOW_PERS		CHAR	1	0	Allow Personalization
8	REQ_USER_CONSENT	☐	ESH_E_QL_CUST_REQ_USER_CONSENT		CHAR	1	0	Require User Consent for Logging
9	LOG_LOG_ACCESSES	☐	ESH_E_QL_CUST_LOG_LOG_ACCESSES	ESH_D_QL_CUST_LOG_LOG_ACCESSES	CHAR	1	0	Record Log Accesses
10	QL_AGGREG	☐	ESH_E_QL_CUST_QL_AGGREG	ESH_D_QL_CUST_QL_AGGREG	CHAR	1	0	Aggregate Query Log (Searchterm Statistics for Type-Ahead)
11	QL_AGGREG_INTERV	☐	ESH_E_QL_CUST_QL_AGGREG_INTERV	ESH_D_QL_CUST_QL_AGGREG_INTERV	NUMC	4	0	Query Log Aggregation Interval (Aggregate last ... days)
12	QL_AGGREG_FREQ	☐	ESH_E_QL_CUST_QL_AGGREG_FREQ	ESH_D_QL_CUST_QL_AGGREG_FREQ	NUMC	4	0	Query Log Aggregation Frequency (Aggregate all ... hours)
13	LAST_UPD_USER	☐	USERNAME	USERNAME	CHAR	12	0	User name
14	LAST_UPD_TSP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

Last changed by/on	SAP	20110908
SAP Release Created in	730