SAP ALPFREP_CAT PerfDB Reporting Catalog Table
Overview
ALPFREP_CAT is a standard SAP S/4HANA table that stores PerfDB Reporting Catalog data. There are total 20 fields in the ALPFREP_CAT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ALPFREP_CAT 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 ALPFREP_CAT to other SAP tables and standard CDS views available based on ALPFREP_CAT table in S/4HANA 2020.
Techincal Settings of ALPFREP_CAT
Below are technical details of the table ALPFREP_CAT
- Buffering allowed but switched off
- Single entries of table were buffered
- Storage type is Column Store
List of ALPFREP_CAT Fields
The following table gives you an overview of the fields available in ALPFREP_CAT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| REPDEFNAME | Name of a Central Performance History Report Definition | ALPFREPNAM | CHAR | 40 | |
| REP_DATE | Alert: date | ALDATE | DATS | 8 | |
| REP_TIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| USERNAME | Background User Name for Authorization Check | BTCAUTHNAM | CHAR | 12 | |
| GROUPNAME | Name of a Group (Part of a CPH Report Definition) | ALPFREPGRP | CHAR | 40 | |
| OPERATION | Group Operation for Central Performance History Reporting | ALPFGRPOPR | CHAR | 1 | |
| START_DATE | Alert: date | ALDATE | DATS | 8 | |
| START_TIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| END_DATE | Alert: date | ALDATE | DATS | 8 | |
| END_TIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | |
| RECTYPE | Aggregation and Resolution of a CPH Data Record | ALPDBRTYP | CHAR | 6 | |
| TIME_ZONE | Time Zone | TIMEZONE | * | CHAR | 6 |
| SFTNAME | Name of a Central Performance History Day Schema | ALPFSFTKEY | CHAR | 40 | |
| CALNAME | Name of a Calendar Schema of the Central Performance History | ALPFCALKEY | CHAR | 40 | |
| VALTYPE | CPH Output Type: Total (T), Average (A), or Number (N) | ALPFVALTYPE | CHAR | 1 | |
| VALUNIT | ALert: Unit for Perfomance Values | ALUNIT | CHAR | 4 | |
| OUT_DIM | Single-Character Flag | CHAR1 | CHAR | 1 | |
| REPDEF | Name of a Central Performance History Report Definition | ALPFREPNAM | CHAR | 40 | |
| REPDESCR | Text (80 Characters) | TEXT80 | CHAR | 80 | |
| OBJ_IN_GRP | String of Variable Length | ALPFSTRING | STRG |
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 ALPFREP_CAT