FIN_AR_QRY_CACHE - FIN-AR: Cache for CPU-Intensive Database Queries
FIN-AR: Cache for CPU-Intensive Database Queries information is stored in SAP table FIN_AR_QRY_CACHE.
It is part of development package FIN_APAR_HDB_LISTS in software component FI-AR-AR. This development package consists of objects that can be grouped under "Reports Based on SAP HANA DB Views".
It is part of development package FIN_APAR_HDB_LISTS in software component FI-AR-AR. This development package consists of objects that can be grouped under "Reports Based on SAP HANA DB Views".
Fields for table FIN_AR_QRY_CACHE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| RELID | Relation ID | X | RELID | CHAR | 4 | |
| METHOD_NAME | Name of a Method for BAdI FIN_APAR_HDB_DBSYS_OPT | X | FIN_AR_DBSYS_OPT_BADI_METHOD | CHAR | 122 | |
| QUERY_ID | Hash Value for a Database Query | X | FIN_AR_QUERY_HASH_VALUE | CHAR | 64 | |
| SRTF2 | Cluster sort field | X | RSSRTF | INT4 | 4 | |
| PROGNAME | ABAP Program Name | PROGNAME | CHAR | 80 | ||
| CODEPAGE | SAP Character Set ID | CPCODEPAGE | NUMC | 8 | * | |
| LAST_REFRESH | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| REFRESH_REQUESTED | Checkbox | XFELD | CHAR | 2 | ||
| NUM_USAGES | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| CLUSTR | BIN2 data element for SYST | SYBIN2 | INT2 | 2 | ||
| CLUSTD | Data field for IMPORT/EXPORT database tables | INDX_CLUST | LRAW | 2886 |