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

Overview

ALALERTDB is a standard SAP S/4HANA table that stores Alert: alert database (general alert structure, raw message) data. There are total 41 fields in the ALALERTDB table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ALALERTDB 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 ALALERTDB to other SAP tables and standard CDS views available based on ALALERTDB table in S/4HANA 2020.

Techincal Settings of ALALERTDB

Below are technical details of the table ALALERTDB

Buffering not allowed
No buffering
Storage type is Column Store

List of ALALERTDB Fields

The following table gives you an overview of the fields available in ALALERTDB

Field	Description	Data Element	Check Table	Data Type	Length
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

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 ALALERTDB

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

Overview

Techincal Settings of ALALERTDB

List of ALALERTDB Fields

Foreign Key Relationships

Other References