ESH_QL_QLCUST - Customizing Settings for Query Logging
Customizing Settings for Query Logging information is stored in SAP table ESH_QL_QLCUST.
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_QLCUST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| QLCUST_ID | Character field, length 32 | X | CHAR32 | CHAR | 64 | |
| VALIDITY_USER | User Name | USERNAME | CHAR | 24 | ||
| LOG_QUERIES | Custom Settings: Log Queries | ESH_E_QL_CUST_LOG_QUERIES | CHAR | 2 | ||
| LOG_PERFORMANCE | Custom Settings: Log Performance Times | ESH_E_QL_CUST_LOG_PERFORMANCE | CHAR | 2 | ||
| ANONYMIZATION | Anonymization Level | ESH_E_QL_CUST_ANONYMIZATION | CHAR | 2 | ||
| LAST_LQAID_RESET_USER | User Name | USERNAME | CHAR | 24 | ||
| LAST_LQAID_RESET_TSP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| ALLOW_PERS | Allow Personalization | ESH_E_QL_CUST_ALLOW_PERS | CHAR | 2 | ||
| REQ_USER_CONSENT | Require User Consent for Logging: Opt-In / Opt-Out | ESH_E_QL_CUST_REQ_USER_CONSENT | CHAR | 2 | ||
| LOG_LOG_ACCESSES | Record Log Accesses | ESH_E_QL_CUST_LOG_LOG_ACCESSES | CHAR | 2 | ||
| QL_AGGREG | Aggregate Query Log (Searchterm Statistics for Type-Ahead) | ESH_E_QL_CUST_QL_AGGREG | CHAR | 2 | ||
| QL_AGGREG_INTERV | Query Log Aggregation Interval (Aggregate last ... days) | ESH_E_QL_CUST_QL_AGGREG_INTERV | NUMC | 8 | ||
| QL_AGGREG_FREQ | Query Log Aggregation Frequency (Aggregate all ... hours) | ESH_E_QL_CUST_QL_AGGREG_FREQ | NUMC | 8 | ||
| QL_AGGREG_CRSUSR | Cross-User Query Log Aggregation | ESH_E_QL_CUST_QL_AGGREG_CRSUSR | CHAR | 2 | ||
| QL_AGGREG_USRBSD | Personalized Query Log Aggregation | ESH_E_QL_CUST_QL_AGGREG_USRBSD | CHAR | 2 | ||
| QL_AGGREG_AUTO | Activate Auto-Aggregation | ESH_E_QL_CUST_QL_AGGREG_AUTO | CHAR | 2 | ||
| LAST_UPD_USER | User Name | USERNAME | CHAR | 24 | ||
| LAST_UPD_TSP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 |