The DBSTATIDB4 table in SAP ERP or S/4HANA stores Index Sizes in the Database data. There are total 11 fields in DBSTATIDB4 table. The Index Sizes in 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 DBSTATIDB4 table. It is in CCMS / AS/400 (STU4) ABAP package and is part of the DB2 for AS/400 (BC-DB-DB4) module.
SAP DBSTATIDB4 Table Fields
Following is the list of fields that are available in SAP DBSTATIDB4 table. The primary key fields of Index Sizes in the Database table in SAP are INDNAME (Database index).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| INDNAME | Database index | DBINDEX_D | CHAR (40) | |
| ANDAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR (12) | |
| VWTYP | Single-Character Flag | CHAR1 | CHAR (1) | |
| INDSIZE | Total blocks of an index (kb) | IBLOCKS_KB | DEC (11) | |
| CRTDATE | Date | DATUM | DATS (8) | |
| CRTTIME | Character field of length 6 | CHAR6 | CHAR (6) | |
| SAVDATE | Date | DATUM | DATS (8) | |
| SAVTIME | Character field of length 6 | CHAR6 | CHAR (6) | |
| RSTDATE | Date | DATUM | DATS (8) | |
| RSTTIME | Character field of length 6 | CHAR6 | CHAR (6) | |
| INDTABLE | Table name | TNAME | CHAR (30) |
