The DBSTATTDB4 table in SAP ERP or S/4HANA stores Table Sizes in the Database data. There are total 22 fields in DBSTATTDB4 table. The Table 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 DBSTATTDB4 table. It is in CCMS / AS/400 (STU4) ABAP package and is part of the DB2 for AS/400 (BC-DB-DB4) module.
SAP DBSTATTDB4 Table Fields
Following is the list of fields that are available in SAP DBSTATTDB4 table. The primary key fields of Table Sizes in the Database table in SAP are TABNAME (Table name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TABNAME | Table name | TNAME | * | CHAR (30) |
| ANDAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR (12) | |
| VWTYP | Single-Character Flag | CHAR1 | CHAR (1) | |
| TABSIZE | Used blocks of a table in KB | UBLOCKS_KB | DEC (11) | |
| CURROWS | Number of rows in a table | OROWS | DEC (15) | |
| INDBS | Used blocks of an index-Btree (kb) | BBLOCKS_KB | DEC (15) | |
| DLTROWS | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMOPEN | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMCLOSE | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMINSERT | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMUPDATE | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMDELETE | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMLREAD | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMPREAD | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| NUMCST | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| CSTSIZE | iSeries: Number of rows / object size | DB4_ANZ15 | DEC (15) | |
| 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) |
