The DBSTATTDB6 table in SAP ERP or S/4HANA stores DB6: Table Statistics for Application Monitor data. There are total 5 fields in DBSTATTDB6 table. The DB6: Table Statistics for Application Monitor 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 DBSTATTDB6 table. It is in DB6: Performance-Monitor (UNIX/Windows) (STU6) ABAP package and is part of the DB2 Universal Database for UNIX / NT (BC-DB-DB6) module.
SAP DBSTATTDB6 Table Fields
Following is the list of fields that are available in SAP DBSTATTDB6 table. The primary key fields of DB6: Table Statistics for Application Monitor table in SAP are TNAME (Table name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TNAME | Table name | TNAME | * | CHAR (30) |
| ANDAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR (12) | |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR (2) | |
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR (4) | |
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR (5) |
