FINCS_UH_HANA_HRY_NODE_REL

DDL: FINCS_UH_HANA_HRY_NODE_REL SQL: FINCSUHHRYNODERL Type: view Package: FIN_CS_UH_INTEGRATION
16 Fields 1 Data Sources 2 Associations

Consolidation Hierarchy Node Relation

FINCS_UH_HANA_HRY_NODE_REL is a CDS View that provides data about "Consolidation Hierarchy Node Relation" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnUnivHierNode) and exposes 16 fields with key fields UniversalHierHierarchyID, HierarchyVersion, HierarchyNodeClass, HierarchyNode, ParentNode. It has 2 associations to related views. Part of development package FIN_CS_UH_INTEGRATION.

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnUnivHierNode P_CnsldtnUnivHierNode from

Parameters (2)

NameTypeDefault
P_HierarchyType hrytype
P_MasterDataType fieldname

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_CnsldtnUnivHierarchy _Hierarchy $projection.UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate
[0..*] FINCS_UH_HANA_HRY_NODE_REL _ParentNode $projection.UniversalHierHierarchyID = _ParentNode.UniversalHierHierarchyID and $projection.HierarchyVersion = _ParentNode.HierarchyVersion and $projection.HierarchyNodeClass = _ParentNode.HierarchyNodeClass and $projection.ParentNode = _ParentNode.HierarchyNode and $projection.ValidityEndDate = _ParentNode.ValidityEndDate

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINCSUHHRYNODERL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierHierarchyID UniversalHierHierarchyID
KEY HierarchyVersion HierarchyVersion Version
KEY HierarchyNodeClass HierarchyNodeClass
KEY HierarchyNode HierarchyNode Node
KEY ParentNode ParentNode Parent Node
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
NodeType NodeType Object Type
HierarchyNodeVal HierarchyNodeVal
HierarchyNodeSequence HierarchyNodeSequence
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
HierarchyType HierarchyType Hierarchy Type
LeafValue LeafValue Value
_ParentNode _ParentNode
_Hierarchy _Hierarchy
HierarchyNodeText

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 FINCS_UH_HANA_HRY_NODE_REL.
-- 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: FINCSUHHRYNODERL
-- Parameters: P_HierarchyType : hrytype, P_MasterDataType : fieldname

CREATE VIEW FINCS_UH_HANA_HRY_NODE_REL AS
SELECT
  UniversalHierHierarchyID,
  HierarchyVersion,
  HierarchyNodeClass,
  HierarchyNode,
  ParentNode,
  ValidityEndDate,
  ValidityStartDate,
  NodeType,
  HierarchyNodeVal,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  HierarchyType,
  LeafValue,
  _HierarchyNode._Text(P_HierarchyType : :P_HierarchyType, P_MasterDataType : :P_MasterDataType )[1: Language = $session.system_language].HierarchyNodeText AS HierarchyNodeText
FROM P_CnsldtnUnivHierNode
LEFT OUTER JOIN P_CnsldtnUnivHierarchy AS _Hierarchy ON UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN FINCS_UH_HANA_HRY_NODE_REL AS _ParentNode ON UniversalHierHierarchyID = _ParentNode.UniversalHierHierarchyID AND HierarchyVersion = _ParentNode.HierarchyVersion AND HierarchyNodeClass = _ParentNode.HierarchyNodeClass AND ParentNode = _ParentNode.HierarchyNode AND ValidityEndDate = _ParentNode.ValidityEndDate  -- association [0..*]
;

Learn More