ALALERTX SAP (CCMS Monitoring: Cache for Alerts Already Read) Table details

Dictionary Type: Table
Description: CCMS Monitoring: Cache for Alerts Already Read




ABAP Code to SELECT data from ALALERTX
Related tables to ALALERTX
Access table ALALERTX




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 empty
Display/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_ALSYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
C_MSEGNAMEAlert: Name of Monitoring Segment ALMSEGNAMECHAR40TEXT40
C_ALUIDAlert: Unique Identifier to be used in AID (char10) ALAIDUIDCHAR10CHAR10
C_ALDATEAlert: date ALDATEDATS8DATUM
C_ALTIMEAlert: Time value in timeformat ALTIMETIMS6TIME
LANGULanguage Key SYLANGULANG1ISOLASYLANGU
CACHETIMSTAlert: UTC Time Stamp in Format ALTMSTPUTCDEC15TZNTSTMPS
ALSYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
MSEGNAMEAlert: Name of Monitoring Segment ALMSEGNAMECHAR40TEXT40
ALUNIQNUMAlert: Unique Identifier to be used in AID (char10) ALAIDUIDCHAR10CHAR10
ALINDEXAlert: internal handle ALINDEXCHAR10CHAR10
ALERTDATEAlert: date ALDATEDATS8DATUM
ALERTTIMEAlert: Time value in timeformat ALTIMETIMS6TIME
DUMMYALIGNAlert: Dummy field. Purpose: Alignment of date/time 16 byte ALDUMMYC2CHAR2CHAR2
MTSYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
MTMCNAMEAlert: Name of Monitoring Context ALMCNAMECHAR40TEXT40
MTNUMRANGEAlert: monitoring type number range (perm., temp, ...) ALTIDNUMRGCHAR3CHAR3
MTUIDALert: Unique Identifier for Monitoring Types (used in TID) ALTIDUIDCHAR10CHAR10
MTCLASSAlert: monitoring type class (perf., single msg.,...) ALTIDMTCLCHAR3CHAR3
MTINDEXAlert: internal handle for TID ALTIDINDEXCHAR10CHAR10
EXTINDEXAlert: internal handle for TID ALTIDINDEXCHAR10CHAR10
VALUEAlert: alert value (1 = green, 2 = yellow, ....) ALVALUEINT410
SEVERITYAlert: severity (alerts, monitoring type custom..) ALSEVERITYINT410
STATUSAlert: general status (alert, Customizing, ...) ALERTSTATINT410
OBJECTNAMEAlert: Name of Monitoring Object ALMOBJECTCHAR40CHAR40
FIELDNAMEALert: Name of Monitoring Field ALMFIELDCHAR40CHAR40
GONEDATEAlert: date ALDATEDATS8DATUM
GONETIMEAlert: Time value in timeformat ALTIMETIMS6TIME
GONEDUMMYAlert: Dummy field. Purpose: Alignment of date/time 16 byte ALDUMMYC2CHAR2CHAR2
REPORTEDBYAlert: User (16 Char) ALUSER16CHAR16CHAR16
STATCHGDATAlert: date ALDATEDATS8DATUM
STATCHGTIMAlert: Time value in timeformat ALTIMETIMS6TIME
STATCHGDUMAlert: Dummy field. Purpose: Alignment of date/time 16 byte ALDUMMYC2CHAR2CHAR2
STATCHGBYAlert: Last Alert Status changed By ALSTACHGBYCHAR16CHAR16
TIMEOUTDATAlert: date ALDATEDATS8DATUM
TIMEOUTTIMAlert: Time value in timeformat ALTIMETIMS6TIME
TIMEOUTDUMAlert: Dummy field. Purpose: Alignment of date/time 16 byte ALDUMMYC2CHAR2CHAR2
MSGCLASSXMI logging: company name of external management tool XMILOGCOMPCHAR16TEXT16
MSGIDMessage ID for an XMI log entry XMILOGMIDCHAR30XMSGID
MSGARG1Argument string for an XMI log XMIARGTXTCHAR128CHAR128
ARGTYPE1Argument type of an XMI log entry XMIARGTYPCHAR1XMIARGTYPE
MSGARG2Argument string for an XMI log XMIARGTXTCHAR128CHAR128
ARGTYPE2Argument type of an XMI log entry XMIARGTYPCHAR1XMIARGTYPE
MSGARG3Argument string for an XMI log XMIARGTXTCHAR128CHAR128
ARGTYPE3Argument type of an XMI log entry XMIARGTYPCHAR1XMIARGTYPE
MSGARG4Argument string for an XMI log XMIARGTXTCHAR128CHAR128
ARGTYPE4Argument type of an XMI log entry XMIARGTYPCHAR1XMIARGTYPE
MSGTEXTActual text of message XMIMSGTXTCHAR128CHAR128
MANDTClient ID SYMANDTCLNT3Assigned to domainMANDT
USERIDUser Name SYUNAMECHAR12SYCHAR12
MSCGLIDAlert: Message container: global external line ID ALMSCGLLIDCHAR50CHAR50
MSGThe expanded (translated) message for ext. tools XMIEXTMSGCHAR255CHAR255

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!