ALALERTX SAP (CCMS Monitoring: Cache for Alerts Already Read) Table details
Dictionary Type: Table
Description: CCMS Monitoring: Cache for Alerts Already Read
Description: CCMS Monitoring: Cache for Alerts Already Read
Table field list including key, data, relationships and ABAP select examples
ALALERTX is a standard SAP Table which is used to store CCMS Monitoring: Cache for Alerts Already Read data and is available within R/3 SAP systems depending on the version and release level.
The ALALERTX table consists of various fields, each holding specific information or linking keys about CCMS Monitoring: Cache for Alerts Already Read data available in SAP. These include C_ALSYSID (Name of SAP System), C_MSEGNAME (Alert: Name of Monitoring Segment), C_ALUID (Alert: Unique Identifier to be used in AID (char10)), C_ALDATE (Alert: date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP ALALERTX table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
C_ALSYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
C_MSEGNAME | Alert: Name of Monitoring Segment | ALMSEGNAME | CHAR | 40 | TEXT40 | ||||
C_ALUID | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | CHAR | 10 | CHAR10 | ||||
C_ALDATE | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
C_ALTIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
LANGU | Language Key | SYLANGU | LANG | 1 | ISOLA | SYLANGU | |||
CACHETIMST | Alert: UTC Time Stamp in Format | ALTMSTPUTC | DEC | 15 | TZNTSTMPS | ||||
ALSYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
MSEGNAME | Alert: Name of Monitoring Segment | ALMSEGNAME | CHAR | 40 | TEXT40 | ||||
ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | CHAR | 10 | CHAR10 | ||||
ALINDEX | Alert: internal handle | ALINDEX | CHAR | 10 | CHAR10 | ||||
ALERTDATE | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
ALERTTIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
DUMMYALIGN | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
MTSYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
MTMCNAME | Alert: Name of Monitoring Context | ALMCNAME | CHAR | 40 | TEXT40 | ||||
MTNUMRANGE | Alert: monitoring type number range (perm., temp, ...) | ALTIDNUMRG | CHAR | 3 | CHAR3 | ||||
MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | ALTIDUID | CHAR | 10 | CHAR10 | ||||
MTCLASS | Alert: monitoring type class (perf., single msg.,...) | ALTIDMTCL | CHAR | 3 | CHAR3 | ||||
MTINDEX | Alert: internal handle for TID | ALTIDINDEX | CHAR | 10 | CHAR10 | ||||
EXTINDEX | Alert: internal handle for TID | ALTIDINDEX | CHAR | 10 | CHAR10 | ||||
VALUE | Alert: alert value (1 = green, 2 = yellow, ....) | ALVALUE | INT4 | 10 | |||||
SEVERITY | Alert: severity (alerts, monitoring type custom..) | ALSEVERITY | INT4 | 10 | |||||
STATUS | Alert: general status (alert, Customizing, ...) | ALERTSTAT | INT4 | 10 | |||||
OBJECTNAME | Alert: Name of Monitoring Object | ALMOBJECT | CHAR | 40 | CHAR40 | ||||
FIELDNAME | ALert: Name of Monitoring Field | ALMFIELD | CHAR | 40 | CHAR40 | ||||
GONEDATE | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
GONETIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
GONEDUMMY | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
REPORTEDBY | Alert: User (16 Char) | ALUSER16 | CHAR | 16 | CHAR16 | ||||
STATCHGDAT | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
STATCHGTIM | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
STATCHGDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
STATCHGBY | Alert: Last Alert Status changed By | ALSTACHGBY | CHAR | 16 | CHAR16 | ||||
TIMEOUTDAT | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
TIMEOUTTIM | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
TIMEOUTDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
MSGCLASS | XMI logging: company name of external management tool | XMILOGCOMP | CHAR | 16 | TEXT16 | ||||
MSGID | Message ID for an XMI log entry | XMILOGMID | CHAR | 30 | XMSGID | ||||
MSGARG1 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | CHAR128 | ||||
ARGTYPE1 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | XMIARGTYPE | ||||
MSGARG2 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | CHAR128 | ||||
ARGTYPE2 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | XMIARGTYPE | ||||
MSGARG3 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | CHAR128 | ||||
ARGTYPE3 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | XMIARGTYPE | ||||
MSGARG4 | Argument string for an XMI log | XMIARGTXT | CHAR | 128 | CHAR128 | ||||
ARGTYPE4 | Argument type of an XMI log entry | XMIARGTYP | CHAR | 1 | XMIARGTYPE | ||||
MSGTEXT | Actual text of message | XMIMSGTXT | CHAR | 128 | CHAR128 | ||||
MANDT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
USERID | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
MSCGLID | Alert: Message container: global external line ID | ALMSCGLLID | CHAR | 50 | CHAR50 | ||||
MSG | The expanded (translated) message for ext. tools | XMIEXTMSG | CHAR | 255 | CHAR255 |
Key field | Non-key field |
How do I retrieve data from SAP table ALALERTX using ABAP code
The following ABAP code Example will allow you to do a basic selection on ALALERTX to SELECT all data from the tableDATA: WA_ALALERTX TYPE ALALERTX.
SELECT SINGLE *
FROM ALALERTX
INTO CORRESPONDING FIELDS OF WA_ALALERTX
WHERE...
How to access SAP table ALALERTX
Within an ECC or HANA version of SAP you can also view further information about ALALERTX and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects