The DBSTATIADA table in SAP ERP or S/4HANA stores Actual size of indices on the database data. There are total 6 fields in DBSTATIADA table. The Actual size of indices on the database table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DBSTATIADA table. It is in SAP Monitoring Tools (STUN) ABAP package and is part of the Workload Monitoring Tool (BC-CCM-MON-TUN) module.
SAP DBSTATIADA Table Fields
Following is the list of fields that are available in SAP DBSTATIADA table. The primary key fields of Actual size of indices on the database table in SAP are TNAME (Table name), INAME (Database index), ANDAT (Analysis date (yyyymmddhhmm)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TNAME | Table name | TNAME | CHAR (30) | |
| INAME | Database index | DBINDEX_D | CHAR (40) | |
| ANDAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR (12) | |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR (2) | |
| SIGNI | Significance for Collection of Statistics | AM_SIGNI | INT1 (3) | |
| OCCIX | Used blocks of a table in KB | UBLOCKS_KB | DEC (11) |
