The ALMSETS table in SAP ERP or S/4HANA stores Alerts: Monitor Sets and Corresponding Attributes data. There are total 13 fields in ALMSETS table. The Alerts: Monitor Sets and Corresponding Attributes table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ALMSETS table. It is in CCMS: Monitoring Architecture (SMOI) ABAP package and is part of the CCMS Monitoring & Alerting (BC-CCM-MON) module.
SAP ALMSETS Table Fields
Following is the list of fields that are available in SAP ALMSETS table. The primary key fields of the table are MSETGUID (UUID in character form).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MSETGUID | UUID in character form | SYSUUID_C | CHAR (32) | |
| MONISET | Alerts: Name of a monitor set | ALMONISET | CHAR (60) | |
| OWNER | User Name | SYUNAME | CHAR (12) | |
| FORMATVERS | Alert: Version of Monitoring Infrastructure | ALMONIVERS | CHAR (10) | |
| MANDT | Client ID | SYMANDT | * | CLNT (3) |
| PUBLICSET | Alerts: public monitor set yes/no | ALMSETPUB | CHAR (1) | |
| MBUSRONLY | Alerts: monitor set modifiable only by user | ALMSMBUSO | CHAR (1) | |
| MBYUSRAADM | Alerts: monitor set modifiable by users and administrator | ALMSMBUAA | CHAR (1) | |
| MBYOTHERS | Alerts: monitor set modifiable by other users yes/no | ALMSETMBO | CHAR (1) | |
| CREABYADM | Alerts: monitor set created by administrator yes/no | ALMSCRBA | CHAR (1) | |
| CHUSER | User Name | SYUNAME | CHAR (12) | |
| CHTIMESTMP | Alert: UTC Time Stamp in Format |
ALTMSTPUTC | DEC (15) | |
| V2CONFINFO | Single-Character Flag | CHAR1 | CHAR (1) |
