SAP AFWCH_PHDEFALT Alternative Portfolio Hierarchy Definition Table
Overview
AFWCH_PHDEFALT is a standard SAP S/4HANA table that stores Alternative Portfolio Hierarchy Definition data. There are total 8 fields in the AFWCH_PHDEFALT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFWCH_PHDEFALT belongs to Analyzer (FIN-FSCM-TRM-AN) module and is located in the package RDB: Analyzer Characteristic Management (CFM_AFWCH).
In addition, following links provide an overview of foreign key relationships, if any, that link AFWCH_PHDEFALT to other SAP tables and standard CDS views available based on AFWCH_PHDEFALT table in S/4HANA 2020.
Techincal Settings of AFWCH_PHDEFALT
Below are technical details of the table AFWCH_PHDEFALT
- Buffering switched on
- Full table is passed to buffer
- Storage type is Not Defined
List of AFWCH_PHDEFALT Fields
The following table gives you an overview of the fields available in AFWCH_PHDEFALT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SICHTID | View of an Analysis Structure | JBRSICHTID | JBRSI | CHAR | 3 |
| PHID | Portfolio Hierarchy | JBRPHID | JBRPH | NUMC | 3 |
| FIENM_ALT | Characteristic With Branch (Portfolio Hierarchy) | AFWCH_FIENM_ALT | JBRPHDEF | CHAR | 30 |
| FIENM | Characteristic | JBRMERKML | JBRSIM | CHAR | 30 |
| VARIANTE | Characteristics Hierarchy | JBRMRKHIER | CHAR | 3 | |
| HIERTYPE | Category of Characteristic Hierarchy | JBRMHTYPE | CHAR | 1 | |
| SORT | Sort Order of Characteristic Group | JBRSORT | NUMC | 3 |
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 AFWCH_PHDEFALT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFWCH_PHDEFALT | FIENM | : | JBRSIM |
| AFWCH_PHDEFALT | FIENM_ALT | : | JBRPHDEF |
| AFWCH_PHDEFALT | MANDT | : | T000 |
| AFWCH_PHDEFALT | PHID | : | JBRPH |
| AFWCH_PHDEFALT | SICHTID | : | JBRSI |