SAP ALPFDBVAR PFDB: Report Variants Table

Overview

ALPFDBVAR is a standard SAP S/4HANA table that stores PFDB: Report Variants data. There are total 18 fields in the ALPFDBVAR table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ALPFDBVAR belongs to CCMS Monitoring & Alerting (BC-CCM-MON) module and is located in the package English version of Dev Class SMOI (SMOI_EN).

In addition, following links provide an overview of foreign key relationships, if any, that link ALPFDBVAR to other SAP tables and standard CDS views available based on ALPFDBVAR table in S/4HANA 2020.

Techincal Settings of ALPFDBVAR

Below are technical details of the table ALPFDBVAR

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ALPFDBVAR Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
RELIDRegion in IMPORT/EXPORT Data TableINDX_RELIDCHAR2
RVARIDPFDB: GUID for report variantsALPFDBRVARCHAR32
SRTF2Next record counter in EXPORT/IMPORT data tablesINDX_SRTF2INT410
CREAUSERPFDB: Changed by user nameALPFDBUSERCHAR12
CREADATEAlert: dateALDATEDATS8
UPDTUSERPFDB: Changed by user nameALPFDBUSERCHAR12
UPDTDATEAlert: dateALDATEDATS8
UPDTTIMEAlert: Time value in timeformatALTIMETIMS6
VERSIONVersion of the dictionary objects defined for the perf. DBALPFDBVERSCHAR6
WITH_ESTPFDB: Status flagALPFDBVSTACHAR1
AGG_GRANAggregation and Resolution of a CPH Data RecordALPDBRTYPCHAR6
FIRSTDAYAlert: dateALDATEDATS8
LASTDAYAlert: dateALDATEDATS8
RANGEUNITPFDB: Status flagALPFDBVSTACHAR1
PASTINT4 Byte Signed IntegerINT4INT410
FUTUREINT4 Byte Signed IntegerINT4INT410
CLUSTRLength field for user data in EXPORT/IMPORT tablesINDX_CLSTRINT25
CLUSTDData field for IMPORT/EXPORT database tablesINDX_CLUSTLRAW2886

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 ALPFDBVAR

Other References