The ALDBSPERF table in SAP ERP or S/4HANA stores CCMS Monitoring Arch.: Database Segment: Performance MTE data. There are total 15 fields in ALDBSPERF table. The CCMS Monitoring Arch.: Database Segment: Performance MTE table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ALDBSPERF table. It is in CCMS: Monitoring Architecture (SMOI) ABAP package and is part of the CCMS Monitoring & Alerting (BC-CCM-MON) module.
SAP ALDBSPERF Table Fields
Following is the list of fields that are available in SAP ALDBSPERF table. The primary key fields of the table are MTSYSID (Name of SAP System), MTMCNAME (Alert: Name of Monitoring Context), MTNUMRANGE (Alert: monitoring type number range (perm., temp, …)), MTUID (ALert: Unique Identifier for Monitoring Types (used in TID)), MTCLASS (Alert: monitoring type class (perf., single msg.,…)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MTSYSID | Name of SAP System | SYSYSID | CHAR (8) | |
| MTMCNAME | Alert: Name of Monitoring Context | ALMCNAME | CHAR (40) | |
| MTNUMRANGE | Alert: monitoring type number range (perm., temp, …) | ALTIDNUMRG | CHAR (3) | |
| MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | ALTIDUID | CHAR (10) | |
| MTCLASS | Alert: monitoring type class (perf., single msg.,…) | ALTIDMTCL | CHAR (3) | |
| MSGCLASS | XMI logging: company name of external management tool | XMILOGCOMP | CHAR (16) | |
| MSGID | Message ID for an XMI log entry | XMILOGMID | CHAR (30) | |
| CUSGRPNAME | Alert: Customization: Name of Customization Group | ALCUSGROUP | CHAR (40) | |
| VALUNIT | ALert: Unit for Perfomance Values | ALUNIT | CHAR (4) | |
| ALRELVALDT | Alert: date | ALDATE | DATS (8) | |
| ALRELVALTI | Alert: Time value in timeformat | ALTIME | TIMS (6) | |
| MAXPFDATE | Alert: date | ALDATE | DATS (8) | |
| MAXPFTIME | Alert: Time value in timeformat | ALTIME | TIMS (6) | |
| MINPFDATE | Alert: date | ALDATE | DATS (8) | |
| MINPFTIME | Alert: Time value in timeformat | ALTIME | TIMS (6) |
