SAP Table ALALERTDB - Alert: alert database (general alert structure, raw message)

Field Key Data Element Type Offset Leng Decimals Check Table Text
ALSYSID X SYSYSID CHAR 0 8 0 Name of the SAP System
MSEGNAME X ALMSEGNAME CHAR 8 40 0 Alert: Name of Monitoring Segment
ALUNIQNUM X ALAIDUID CHAR 48 10 0 Alert: Unique Identifier to be used in AID (char10)
ALINDEX X ALINDEX CHAR 58 10 0 Alert: internal handle
ALERTDATE X ALDATE DATS 68 8 0 Alert: date
ALERTTIME X ALTIME TIMS 76 6 0 Alert: Time value in timeformat
DUMMYALIGN X ALDUMMYC2 CHAR 82 2 0 Alert: Dummy field. Purpose: Alignment of date/time 16 byte
MTSYSID SYSYSID CHAR 84 8 0 Name of the SAP System
MTMCNAME ALMCNAME CHAR 92 40 0 Alert: Name of Monitoring Context
MTNUMRANGE ALTIDNUMRG CHAR 132 3 0 Alert: monitoring type number range (perm., temp, ...)
MTUID ALTIDUID CHAR 135 10 0 ALert: Unique Identifier for Monitoring Types (used in TID)
MTCLASS ALTIDMTCL CHAR 145 3 0 Alert: monitoring type class (perf., single msg.,...)
MTINDEX ALTIDINDEX CHAR 148 10 0 Alert: internal handle for TID
EXTINDEX ALTIDINDEX CHAR 158 10 0 Alert: internal handle for TID
VALUE ALVALUE INT4 168 10 0 Alert: alert value (1 = green, 2 = yellow, ....)
SEVERITY ALSEVERITY INT4 172 10 0 Alert: severity (alerts, monitoring type custom..)
STATUS ALERTSTAT INT4 176 10 0 Alert: general status (alert, Customizing, ...)
OBJECTNAME ALMOBJECT CHAR 180 40 0 Alert: Name of Monitoring Object
FIELDNAME ALMFIELD CHAR 220 40 0 ALert: Name of Monitoring Field
GONEDATE ALDATE DATS 260 8 0 Alert: date
GONETIME ALTIME TIMS 268 6 0 Alert: Time value in timeformat
GONEDUMMY ALDUMMYC2 CHAR 274 2 0 Alert: Dummy field. Purpose: Alignment of date/time 16 byte
REPORTEDBY ALUSER16 CHAR 276 16 0 Alert: User (16 Char)
STATCHGDAT ALDATE DATS 292 8 0 Alert: date
STATCHGTIM ALTIME TIMS 300 6 0 Alert: Time value in timeformat
STATCHGDUM ALDUMMYC2 CHAR 306 2 0 Alert: Dummy field. Purpose: Alignment of date/time 16 byte
STATCHGBY ALSTACHGBY CHAR 308 16 0 Alert: Last Alert Status changed By
TIMEOUTDAT ALDATE DATS 324 8 0 Alert: date
TIMEOUTTIM ALTIME TIMS 332 6 0 Alert: Time value in timeformat
TIMEOUTDUM ALDUMMYC2 CHAR 338 2 0 Alert: Dummy field. Purpose: Alignment of date/time 16 byte
MSGCLASS XMILOGCOMP CHAR 340 16 0 XMI logging: company name of external management tool
MSGID XMILOGMID CHAR 356 30 0 Message ID for an XMI log entry
MSGARG1 XMIARGTXT CHAR 386 128 0 Argument string for an XMI log
ARGTYPE1 XMIARGTYP CHAR 514 1 0 Argument type of an XMI log entry
MSGARG2 XMIARGTXT CHAR 515 128 0 Argument string for an XMI log
ARGTYPE2 XMIARGTYP CHAR 643 1 0 Argument type of an XMI log entry
MSGARG3 XMIARGTXT CHAR 644 128 0 Argument string for an XMI log
ARGTYPE3 XMIARGTYP CHAR 772 1 0 Argument type of an XMI log entry
MSGARG4 XMIARGTXT CHAR 773 128 0 Argument string for an XMI log
ARGTYPE4 XMIARGTYP CHAR 901 1 0 Argument type of an XMI log entry
MSGTEXT XMIMSGTXT CHAR 902 128 0 Actual text of message
MANDT SYMANDT CLNT 1030 3 0 T000 Client ID of Current User
USERID SYUNAME CHAR 1033 12 0 User Name
MSCGLID ALMSCGLLID CHAR 1045 50 0 Alert: Message container: global external line ID

564435Additional information on CRM System copy
863834Converting the ALALERTDB table to Unicode
795779Solution Manager system copy