SAP ALALERTX CCMS Monitoring: Cache for Alerts Already Read Table
Overview
ALALERTX is a standard SAP S/4HANA table that stores CCMS Monitoring: Cache for Alerts Already Read data. There are total 49 fields in the ALALERTX table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ALALERTX 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 ALALERTX to other SAP tables and standard CDS views available based on ALALERTX table in S/4HANA 2020.
Techincal Settings of ALALERTX
Below are technical details of the table ALALERTX
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of ALALERTX Fields
The following table gives you an overview of the fields available in ALALERTX
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| C_ALSYSID | Name of SAP System | SYSYSID | CHAR | 8 | |
| C_MSEGNAME | Alert: Name of Monitoring Segment | ALMSEGNAME | CHAR | 40 | |
| C_ALUID | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | CHAR | 10 | |
| C_ALDATE | Alert: date | ALDATE | DATS | 8 | |
| C_ALTIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| LANGU | Language Key | SYLANGU | LANG | 1 | |
| CACHETIMST | Alert: UTC Time Stamp in Format <YYYYMMDDhhmmss> | ALTMSTPUTC | DEC | 15 | |
| 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 | |
| ALINDEX | Alert: internal handle | ALINDEX | CHAR | 10 | |
| ALERTDATE | Alert: date | ALDATE | DATS | 8 | |
| ALERTTIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| DUMMYALIGN | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | |
| 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 | |
| OBJECTNAME | Alert: Name of Monitoring Object | ALMOBJECT | CHAR | 40 | |
| FIELDNAME | ALert: Name of Monitoring Field | ALMFIELD | CHAR | 40 | |
| GONEDATE | Alert: date | ALDATE | DATS | 8 | |
| GONETIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| GONEDUMMY | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | |
| REPORTEDBY | Alert: User (16 Char) | ALUSER16 | CHAR | 16 | |
| STATCHGDAT | Alert: date | ALDATE | DATS | 8 | |
| STATCHGTIM | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| STATCHGDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | |
| STATCHGBY | Alert: Last Alert Status changed By | ALSTACHGBY | CHAR | 16 | |
| TIMEOUTDAT | Alert: date | ALDATE | DATS | 8 | |
| TIMEOUTTIM | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| TIMEOUTDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | |
| MSGCLASS | XMI logging: company name of external management tool | XMILOGCOMP | CHAR | 16 | |
| MSGID | Message ID for an XMI log entry | XMILOGMID | CHAR | 30 | |
| MSGARG1 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | |
| ARGTYPE1 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | |
| MSGARG2 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | |
| ARGTYPE2 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | |
| MSGARG3 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | |
| ARGTYPE3 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | |
| MSGARG4 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | |
| ARGTYPE4 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | |
| MSGTEXT | Actual text of message | XMIMSGTXT | CHAR | 128 | |
| MANDT | Client ID | SYMANDT | * | CLNT | 3 |
| USERID | User Name | SYUNAME | CHAR | 12 | |
| MSCGLID | Alert: Message container: global external line ID | ALMSCGLLID | CHAR | 50 | |
| MSG | The expanded (translated) message for ext. tools | XMIEXTMSG | CHAR | 255 |
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 ALALERTX