SAP AMDT Control Table for Application Monitor / DB Storage Table

Overview

AMDT is a standard SAP S/4HANA table that stores Control Table for Application Monitor / DB Storage data. There are total 7 fields in the AMDT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AMDT 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 AMDT to other SAP tables and standard CDS views available based on AMDT table in S/4HANA 2020.

Techincal Settings of AMDT

Below are technical details of the table AMDT

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of AMDT Fields

The following table gives you an overview of the fields available in AMDT

FieldDescriptionData ElementCheck TableData TypeLength
DBOBJName of Database ObjectAM_DBOBJCHAR30
DOTYPType of Database ObjectAM_DOTYPCHAR2
OBJECIdentification of EDM clusterUDCLUIDCHAR10
ACTIVActivation flag for application monitor / memory location DBAM_ACTIVCHAR2
AEDATChange/Insert Date in Control TableAM_AENDDATDATS8
AMETHAnalysis Method for Collecting StatisticsAM_AMETHCHAR4
OPTIOSample Size for Collection of StatisticsAM_OPTIOCHAR5

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 AMDT

Other References