SAP ALPFTHRHIST_TB Performance Threshold History Table

Overview

ALPFTHRHIST_TB is a standard SAP S/4HANA table that stores Performance Threshold History data. There are total 14 fields in the ALPFTHRHIST_TB table. The following is a list of the fields that make up this table. Key fields are marked in blue.

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

Techincal Settings of ALPFTHRHIST_TB

Below are technical details of the table ALPFTHRHIST_TB

  • Buffering switched on
  • Full buffering as specified by generic key
  • Storage type is Column Store

List of ALPFTHRHIST_TB Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MTSYSIDName of SAP SystemSYSYSIDCHAR8
MTMCNAMEAlert: Name of Monitoring ContextALMCNAMECHAR40
MTNUMRANGEAlert: monitoring type number range (perm., temp, ...)ALTIDNUMRGCHAR3
MTUIDALert: Unique Identifier for Monitoring Types (used in TID)ALTIDUIDCHAR10
MTCLASSAlert: monitoring type class (perf., single msg.,...)ALTIDMTCLCHAR3
VALFR_DATEAlert: Date of last changeALCHGDATEDATS8
VALFR_TIMEAlert: Time of last changeALCHGTIMETIMS6
TIME_ZONETime ZoneSYSTZONLOCHAR6
MSGCLASSXMI logging: company name of external management toolXMILOGCOMPCHAR16
MSGIDMessage ID for an XMI log entryXMILOGMIDCHAR30
CUSGRPNAMEAlert: Customization: Name of Customization GroupALCUSGROUPCHAR40
VALUNITALert: Unit for Perfomance ValuesALUNITCHAR4
CHG_USERAlert: Last Changed ByALCHGUSERCHAR12
TSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)RSTIMESTMPDEC15

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 ALPFTHRHIST_TB

Other References