ESH_QL_REORG - Query Log Reorg
Query Log Reorg information is stored in SAP table ESH_QL_REORG.
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_REORG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| QL_REORG_KEY | Reorganization Key | X | ESH_E_QL_REORG_KEY | CHAR | 64 | |
| LAST_QL | Execution Timestamp | ESH_E_QL_EXEC_TSTP | DEC | 11 | ||
| CURR_VOLUME | Current Log Volume (kB) (Approx.) | ESH_E_QL_CURR_VOL | INT4 | 4 | ||
| LAST_REORG | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| REORG_FREQUENCY | Reorganization Frequency (Hours) | ESH_E_QL_REORG_FREQUENCY | INT4 | 4 | ||
| KEEPTIM_QL_CONT | Keep Time (Retention Time) for Query Log Content (Days) | ESH_E_QL_KEEPTIM_QL_CONT | INT4 | 4 | ||
| MAX_REC_COUNT | Max. Record Count for Query Log | ESH_E_QL_MAX_REC_COUNT | INT4 | 4 | ||
| MAX_DATA_VOL | Max. Data Volume for Query Log (in KB) - Deprecated | ESH_E_QL_MAX_DATA_VOL | INT4 | 4 | ||
| LAST_MOD_TSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| LAST_MOD_USR | User Name | SYUNAME | CHAR | 24 |