P_PortfolioHierarchyNode

DDL: P_PORTFOLIOHIERARCHYNODE SQL: PPORTHIERNODE Type: view COMPOSITE Package: FTR_IRM_CORE
16 Fields 2 Data Sources

Portfolio Hierarchy Node

P_PortfolioHierarchyNode is a Composite CDS View that provides data about "Portfolio Hierarchy Node" in SAP S/4HANA. It reads from 2 data sources (I_ActiveAnalysisStructureView, jbrphbaums) and exposes 16 fields with key fields RiskAnalyzerPortfolioHierarchy, PortfolioHierarchyNode. Part of development package FTR_IRM_CORE.

Data Sources (2)

SourceAliasJoin Type
I_ActiveAnalysisStructureView ActiveAnalysisStructureView inner
jbrphbaums PortfolioHierarchyNode from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPORTHIERNODE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY RiskAnalyzerPortfolioHierarchy jbrphbaums phid Portfolio Hierarchy
KEY PortfolioHierarchyNode jbrphbaums pknoten PH Node
PortfolioHierarchyName
NodeType jbrphbaums type Worklist Type
NodeName jbrphbaums name Zone name
IsLeafNode jbrphbaums leaf Page
IsLocked jbrphbaums tlock Trip locked
ParentHierarchyNode jbrphbaums parent UUID
ChildNode jbrphbaums child ID
NextSiblingNode jbrphbaums nextr ID
CharacteristicInternalID jbrphbaums fienm Field Name
CharacteristicValue jbrphbaums auspg Lower Limit
ControlFlag jbrphbaums nflag Control flag to read text hierarchy node
DataDomain jbrphbaums domnm Domain
DataElement jbrphbaums rolnm Data Element
RootNodeID jbrphbaums parent_dim ID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PortfolioHierarchyNode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PPORTHIERNODE

CREATE VIEW P_PortfolioHierarchyNode AS
SELECT
  PortfolioHierarchyNode.phid AS RiskAnalyzerPortfolioHierarchy,
  PortfolioHierarchyNode.pknoten AS PortfolioHierarchyNode,
  cast(concat(PortfolioHierarchyNode.sichtid,PortfolioHierarchyNode.phid ) as afw_phname) AS PortfolioHierarchyName,
  PortfolioHierarchyNode.type AS NodeType,
  PortfolioHierarchyNode.name AS NodeName,
  PortfolioHierarchyNode.leaf AS IsLeafNode,
  PortfolioHierarchyNode.tlock AS IsLocked,
  PortfolioHierarchyNode.parent AS ParentHierarchyNode,
  PortfolioHierarchyNode.child AS ChildNode,
  PortfolioHierarchyNode.nextr AS NextSiblingNode,
  PortfolioHierarchyNode.fienm AS CharacteristicInternalID,
  PortfolioHierarchyNode.auspg AS CharacteristicValue,
  PortfolioHierarchyNode.nflag AS ControlFlag,
  PortfolioHierarchyNode.domnm AS DataDomain,
  PortfolioHierarchyNode.rolnm AS DataElement,
  PortfolioHierarchyNode.parent_dim AS RootNodeID
FROM jbrphbaums AS PortfolioHierarchyNode
INNER JOIN I_ActiveAnalysisStructureView AS ActiveAnalysisStructureView ON /* join condition not captured in parsed metadata */
;

Learn More