Overview
ALDBSMTE is a standard SAP S/4HANA table that stores CCMS Monitoring Arch.: Database Segment: General MTE Data data. There are total 43 fields in the ALDBSMTE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ALDBSMTE belongs to CCMS Monitoring & Alerting (BC-CCM-MON) module and is located in the package CCMS: Monitoring Architecture (SMOI).
In addition, following links provide an overview of foreign key relationships, if any, that link ALDBSMTE to other SAP tables and standard CDS views available based on ALDBSMTE table in S/4HANA 2020.
Techincal Settings of ALDBSMTE
Below are technical details of the table ALDBSMTE
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of ALDBSMTE Fields
The following table gives you an overview of the fields available in ALDBSMTE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| 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 |
| P_MTSYSID | Name of SAP System | SYSYSID | | CHAR | 8 |
| P_MTMCNAME | Alert: Name of Monitoring Context | ALMCNAME | | CHAR | 40 |
| P_MTNUMRG | Alert: monitoring type number range (perm., temp, ...) | ALTIDNUMRG | | CHAR | 3 |
| P_MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | ALTIDUID | | CHAR | 10 |
| P_MTCLASS | Alert: monitoring type class (perf., single msg.,...) | ALTIDMTCL | | CHAR | 3 |
| SEGMENT | Alert: Name of Monitoring Segment | ALMSEGNAME | | CHAR | 40 |
| SHORTNAME | Alert: short name of MTE | ALNAMESHRT | | CHAR | 40 |
| MTECLASS | CCMS Monitoring Architecture: Name of MTE class | ALMTECLASS | | CHAR | 40 |
| MTESUBCLAS | Alert: Customization: Name of Customization Group | ALCUSGROUP | | CHAR | 40 |
| OBJECTNAME | Alert: Name of Monitoring Object | ALMOBJECT | | CHAR | 40 |
| DTEXTCLASS | XMI logging: company name of external management tool | XMILOGCOMP | | CHAR | 16 |
| DTEXTID | Message ID for an XMI log entry | XMILOGMID | | CHAR | 30 |
| ALSYSID | Name of SAP System | SYSYSID | | CHAR | 8 |
| MSEGNAME | Alert: Name of Monitoring Segment | ALMSEGNAME | | CHAR | 40 |
| ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | | CHAR | 10 |
| ALERTDATE | Alert: date | ALDATE | | DATS | 8 |
| ALERTTIME | Alert: Time value in timeformat | ALTIME | | TIMS | 6 |
| LASTVALDAT | Alert: date | ALDATE | | DATS | 8 |
| LASTVALTIM | Alert: Time value in timeformat | ALTIME | | TIMS | 6 |
| CUR_ASYSID | Name of SAP System | SYSYSID | | CHAR | 8 |
| CUR_AMSEG | Alert: Name of Monitoring Segment | ALMSEGNAME | | CHAR | 40 |
| CUR_AUID | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | | CHAR | 10 |
| CUR_ADATE | Alert: date | ALDATE | | DATS | 8 |
| CUR_ATIME | Alert: Time value in timeformat | ALTIME | | TIMS | 6 |
| TRGTDEFNAM | Alert: Logical Name of Tool | ALTOOLKEY | | CHAR | 40 |
| TRGTDEFDSP | Alert method dispatcher | ALTOOLDISP | | CHAR | 40 |
| ANATDEFNAM | Alert: Logical Name of Tool | ALTOOLKEY | | CHAR | 40 |
| ANATDEFDSP | Alert method dispatcher | ALTOOLDISP | | CHAR | 40 |
| ONATDEFNAM | Alert: Logical Name of Tool | ALTOOLKEY | | CHAR | 40 |
| ONATDEFDSP | Alert method dispatcher | ALTOOLDISP | | CHAR | 40 |
| TRGTRUNNAM | Alert: Logical Name of Tool | ALTOOLKEY | | CHAR | 40 |
| TRGTRUNDAT | Alert: date | ALDATE | | DATS | 8 |
| TRGTRUNTIM | Alert: Time value in timeformat | ALTIME | | TIMS | 6 |
| TRGTRUNDSP | Alert method dispatcher | ALTOOLDISP | | CHAR | 40 |
| ONATRUNNAM | Alert: Logical Name of Tool | ALTOOLKEY | | CHAR | 40 |
| ONATRUNDAT | Alert: date | ALDATE | | DATS | 8 |
| ONATRUNTIM | Alert: Time value in timeformat | ALTIME | | TIMS | 6 |
| ONATRUNDSP | Alert method dispatcher | ALTOOLDISP | | CHAR | 40 |
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 ALDBSMTE
Other References