SAP AMDS Effective size of tables and indexes in the database Table
Overview
AMDS is a standard SAP S/4HANA table that stores Effective size of tables and indexes in the database data. There are total 14 fields in the AMDS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AMDS belongs to Workload Monitoring Tool (BC-CCM-MON-TUN) module and is located in the package SAP Monitoring Tools (STUN).
In addition, following links provide an overview of foreign key relationships, if any, that link AMDS to other SAP tables and standard CDS views available based on AMDS table in S/4HANA 2020.
Techincal Settings of AMDS
Below are technical details of the table AMDS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AMDS Fields
The following table gives you an overview of the fields available in AMDS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| TNAME | Table name | TNAME | * | CHAR | 30 |
| ANDAT | Analysis date for application monitor | AM_ANDAT | DATS | 8 | |
| ACTIV | Activation flag Application monitor | AM_ACTIVS | CHAR | 2 | |
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 4 | |
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | |
| NROWS | Number of rows in a table | OROWS | DEC | 15 | |
| OCCBL | Used blocks of an Oracle table | OU_BLOCKS | DEC | 11 | |
| EMPBL | Empty blocks allocated for an Oracle table | OE_BLOCKS | DEC | 11 | |
| AFREE | Avg. freespace in a used data base block | OAVG_BFREE | INT4 | 10 | |
| CHAIN | Number of rows requiring block chaining | OCHAINED | DEC | 15 | |
| AROWL | Average row length (Oracle result) | OAVG_ROW_L | DEC | 7 | |
| INDBL | Allocated blocks for an Oracle index | OIND_ALLBL | DEC | 11 | |
| INDBS | Total space allocated in the B tree (ORACLE) | OBTREE_SPC | DEC | 15 | |
| INDUS | Total space used in B tree (ORACLE) | OBTREE_USE | DEC | 15 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AMDS