P_PORTFOLIOHIERARCHYNODE

CDS View
7 Fields 5 CDS Views

P_PORTFOLIOHIERARCHYNODE is a CDS View in S/4HANA. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_HierclBasisPointValueVal view left_outer COMPOSITE
P_HierclMacaulayDurationVal view left_outer COMPOSITE
P_HierclModifiedDurationVal view inner COMPOSITE
P_MRHierarchicalAdditiveKFVal view from COMPOSITE
P_MRHierarchicalNonAddKFVal view from COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ParentHierarchyNode ParentHierarchyNode 2
KEY PortfolioHierarchyNode PortfolioHierarchyNode 2
KEY RiskAnalyzerPortfolioHierarchy RiskAnalyzerPortfolioHierarchy 2
CharacteristicInternalID CharacteristicInternalID,Level1Characteristic 5
CharacteristicValue CharacteristicValue,Level1HierarchyNodeValue 5
DataElement DataElement,Level1DataElement 5
NodeType NodeType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PORTFOLIOHIERARCHYNODE (
    PARENTHIERARCHYNODE,
    PORTFOLIOHIERARCHYNODE,
    RISKANALYZERPORTFOLIOHIERARCHY,
    CHARACTERISTICINTERNALID,
    CHARACTERISTICVALUE,
    DATAELEMENT,
    NODETYPE,
    PRIMARY KEY (PARENTHIERARCHYNODE, PORTFOLIOHIERARCHYNODE, RISKANALYZERPORTFOLIOHIERARCHY)
);

Learn More