The ALPFASSIGN table in SAP ERP or S/4HANA stores Alert: Assignment of Reorg/Coll Schema to MTE (New Version) data. There are total 10 fields in ALPFASSIGN table. The Alert: Assignment of Reorg/Coll Schema to MTE (New Version) 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 ALPFASSIGN table. It is in CCMS: Monitoring Architecture (SMOI) ABAP package and is part of the CCMS Monitoring & Alerting (BC-CCM-MON) module.
SAP ALPFASSIGN Table Fields
Following is the list of fields that are available in SAP ALPFASSIGN table. The primary key fields of the table are MTSYSID (Name of SAP System), MTMCNAME (Alert: Name of Monitoring Context), MTNUMRANGE (Alert: monitoring type number range (perm., temp, …)), MTUID (ALert: Unique Identifier for Monitoring Types (used in TID)), MTCLASS (Alert: monitoring type class (perf., single msg.,…)), MTECLASS (CCMS Monitoring Architecture: Name of MTE class).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| 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) | |
| MTECLASS | CCMS Monitoring Architecture: Name of MTE class | ALMTECLASS | CHAR (40) | |
| MONI_DEF | Name of a monitor in the CCMS monitoring infrastructure | ALTRINNM | CHAR (60) | |
| MONI_SET | Alerts: Name of a monitor set | ALMONISET | CHAR (60) | |
| POLICYID | Name of a CPH Collection and Reorganization Schema | ALPFPOLKEY | CHAR (40) | |
| ASSIGID | 4 Byte Signed Integer | INT4 | INT4 (10) |
