ALPERFDB (Alert: Performance database) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ALPERFDB to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
RELID
Region in IMPORT/EXPORT Data Table
|
INDX_RELID |
CHAR
|
2 | 0 | ||
|
MTSYSID
Name of SAP System
|
SYSYSID |
CHAR
|
8 | 0 | ||
|
MTMCNAME
Alert: Name of Monitoring Context
|
ALMCNAME |
CHAR
|
40 | 0 | ||
|
MTNUMRANGE
Alert: monitoring type number range (perm., temp, ...)
|
ALTIDNUMRG |
CHAR
|
3 | 0 | ||
|
MTUID
ALert: Unique Identifier for Monitoring Types (used in TID)
|
ALTIDUID |
CHAR
|
10 | 0 | ||
|
MTCLASS
Alert: monitoring type class (perf., single msg.,...)
|
ALTIDMTCL |
CHAR
|
3 | 0 | ||
|
RECTYPE
Aggregation and Resolution of a CPH Data Record
|
ALPDBRTYP |
CHAR
|
6 | 0 | ||
|
AVERAGEFOR
Monitoring infra. perform. DB av. value for object or class
|
ALPDBAFOR |
CHAR
|
1 | 0 | ||
|
FIRSTDAY
Alert: date
|
ALDATE |
DATS
|
8 | 0 | ||
|
LASTDAY
Alert: date
|
ALDATE |
DATS
|
8 | 0 | ||
|
SRTF2
Next record counter in EXPORT/IMPORT data tables
|
INDX_SRTF2 |
INT4
|
10 | 0 | ||
|
STATUSFLAG
Monitoring infra. perf DB record status
|
ALPDBRSTAT |
CHAR
|
1 | 0 | ||
|
DATAFORMAT
Monitoring infra. perf. DB data format version
|
ALPDBVERS |
CHAR
|
3 | 0 | ||
|
LASTCHG
Alert: date
|
ALDATE |
DATS
|
8 | 0 | ||
|
COLL_TIMEZONE
Time Zone
|
TIMEZONE |
CHAR
|
6 | 0 | ||
|
DELFLAG
Monitoring infra. perf DB record status
|
ALPDBRSTAT |
CHAR
|
1 | 0 | ||
|
CLUSTR
Length field for user data in EXPORT/IMPORT tables
|
INDX_CLSTR |
INT2
|
5 | 0 | ||
|
CLUSTD
Data field for IMPORT/EXPORT database tables
|
INDX_CLUST |
LRAW
|
2886 | 0 |