SAP ALPERFDB Alert: Performance database Table
Overview
ALPERFDB is a standard SAP S/4HANA table that stores Alert: Performance database data. There are total 18 fields in the ALPERFDB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ALPERFDB 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 ALPERFDB to other SAP tables and standard CDS views available based on ALPERFDB table in S/4HANA 2020.
Techincal Settings of ALPERFDB
Below are technical details of the table ALPERFDB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ALPERFDB Fields
The following table gives you an overview of the fields available in ALPERFDB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| RELID | Region in IMPORT/EXPORT Data Table | INDX_RELID | 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 | |
| RECTYPE | Aggregation and Resolution of a CPH Data Record | ALPDBRTYP | CHAR | 6 | |
| AVERAGEFOR | Monitoring infra. perform. DB av. value for object or class | ALPDBAFOR | CHAR | 1 | |
| FIRSTDAY | Alert: date | ALDATE | DATS | 8 | |
| LASTDAY | Alert: date | ALDATE | DATS | 8 | |
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INDX_SRTF2 | INT4 | 10 | |
| STATUSFLAG | Monitoring infra. perf DB record status | ALPDBRSTAT | CHAR | 1 | |
| DATAFORMAT | Monitoring infra. perf. DB data format version | ALPDBVERS | CHAR | 3 | |
| LASTCHG | Alert: date | ALDATE | DATS | 8 | |
| COLL_TIMEZONE | Time Zone | TIMEZONE | * | CHAR | 6 |
| DELFLAG | Monitoring infra. perf DB record status | ALPDBRSTAT | CHAR | 1 | |
| CLUSTR | Length field for user data in EXPORT/IMPORT tables | INDX_CLSTR | INT2 | 5 | |
| CLUSTD | Data field for IMPORT/EXPORT database tables | INDX_CLUST | LRAW | 2886 |
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 ALPERFDB