The ALDWNTIME table in SAP ERP or S/4HANA stores Downtime of systems for availability calculations data. There are total 16 fields in ALDWNTIME table. The Downtime of systems for availability calculations 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 ALDWNTIME table. It is in CCMS: Monitoring Architecture (SMOI) ABAP package and is part of the CCMS Monitoring & Alerting (BC-CCM-MON) module.
SAP ALDWNTIME Table Fields
Following is the list of fields that are available in SAP ALDWNTIME 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.,…)), MTINDEX (Alert: internal handle for TID), EXTINDEX (Alert: internal handle for TID), STARTDATE (Date), STARTTIME (Time), ENDDATE (Date), ENDTIME (Time).
| 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) | |
| MTINDEX | Alert: internal handle for TID | ALTIDINDEX | CHAR (10) | |
| EXTINDEX | Alert: internal handle for TID | ALTIDINDEX | CHAR (10) | |
| STARTDATE | Date | DATUM | DATS (8) | |
| STARTTIME | Time | UZEIT | TIMS (6) | |
| ENDDATE | Date | DATUM | DATS (8) | |
| ENDTIME | Time | UZEIT | TIMS (6) | |
| PER_FLAG | Single-Character Flag | CHAR1 | CHAR (1) | |
| AVSYSTEM | Name of SAP System | SYSYSID | CHAR (8) | |
| PER_COPIED | Single-Character Flag | CHAR1 | CHAR (1) | |
| NSGUID | GUID for access to a name server of a system | CSMNSGUID | CHAR (32) | |
| REASON | Work Area Length 128 | TEXT128 | CHAR (128) |
