The ALPFDBVAR table in SAP ERP or S/4HANA stores PFDB: Report Variants data. There are total 18 fields in ALPFDBVAR table. The PFDB: Report Variants table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ALPFDBVAR table. It is in English version of Dev Class SMOI (SMOI_EN) ABAP package and is part of the CCMS Monitoring & Alerting (BC-CCM-MON) module.
SAP ALPFDBVAR Table Fields
Following is the list of fields that are available in SAP ALPFDBVAR table. The primary key fields of the table are RELID (Region in IMPORT/EXPORT Data Table), RVARID (PFDB: GUID for report variants), SRTF2 (Next record counter in EXPORT/IMPORT data tables).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RELID | Region in IMPORT/EXPORT Data Table | INDX_RELID | CHAR (2) | |
| RVARID | PFDB: GUID for report variants | ALPFDBRVAR | CHAR (32) | |
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INDX_SRTF2 | INT4 (10) | |
| CREAUSER | PFDB: Changed by user name | ALPFDBUSER | CHAR (12) | |
| CREADATE | Alert: date | ALDATE | DATS (8) | |
| UPDTUSER | PFDB: Changed by user name | ALPFDBUSER | CHAR (12) | |
| UPDTDATE | Alert: date | ALDATE | DATS (8) | |
| UPDTTIME | Alert: Time value in timeformat | ALTIME | TIMS (6) | |
| VERSION | Version of the dictionary objects defined for the perf. DB | ALPFDBVERS | CHAR (6) | |
| WITH_EST | PFDB: Status flag | ALPFDBVSTA | CHAR (1) | |
| AGG_GRAN | Aggregation and Resolution of a CPH Data Record | ALPDBRTYP | CHAR (6) | |
| FIRSTDAY | Alert: date | ALDATE | DATS (8) | |
| LASTDAY | Alert: date | ALDATE | DATS (8) | |
| RANGEUNIT | PFDB: Status flag | ALPFDBVSTA | CHAR (1) | |
| PASTINT | 4 Byte Signed Integer | INT4 | INT4 (10) | |
| FUTUREINT | 4 Byte Signed Integer | INT4 | INT4 (10) | |
| 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) |
