ADACACHE is a standard SAP table in SAP ECC (or) S/4HANA which stores Information About SAP DB Cache Access data. There are total 13 fields in ADACACHE table.This blog post provides key technical details of SAP table ADACACHE, including its availability across SAP S/4HANA versions and the list of CDS views for ADACACHE table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Porting and CCMS SAP DB (SADA) |
| Technical Component | MaxDB (BC-DB-SDB) |
SAP ADACACHE Table Fields
The following is the list of fields that are available in SAP ADACACHE table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| ENTRY_NO | 4 Byte Signed Integer | INT4 | INT4 | INT4 (10) | |
| DA_ACC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| DA_SUCC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| DA_USUCC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| DA_HIT | SDB: Hit Rate for Performance Database | ADA_HIT | HITRATE | INT4 (10) | |
| CA_ACC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| CA_SUCC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| CA_USUCC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| CA_HIT | SDB: Hit Rate for Performance Database | ADA_HIT | HITRATE | INT4 (10) | |
| CO_ACC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| CO_SUCC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| CO_USUCC | SYSDBA.MONITOR.VALUE | ADA_VALUE | DEC20 | DEC (20) | |
| CO_HIT | SDB: Hit Rate for Performance Database | ADA_HIT | HITRATE | INT4 (10) |
Availability
The SAP table ADACACHE is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADACACHE table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
