What is FIN_SEL_HIER_NODE_RELATION in SAP S/4HANA?

FIN_SEL_HIER_NODE_RELATION is a cds CDS view in SAP S/4HANA. Selection Hierarchy Node Relation It contains 15 fields.

Which tables does FIN_SEL_HIER_NODE_RELATION read from?

FIN_SEL_HIER_NODE_RELATION reads data from: FIN_SEL_HIER_NODE.

FIN_SEL_HIER_NODE_RELATION

DDL: FIN_SEL_HIER_NODE_RELATION SQL: FINSELHNR Type: view Package: FINS_GEN_SEL

15 Fields 1 Data Sources 2 Associations

Selection Hierarchy Node Relation

FIN_SEL_HIER_NODE_RELATION is a CDS View that provides data about "Selection Hierarchy Node Relation" in SAP S/4HANA. It reads from 1 data source (FIN_SEL_HIER_NODE) and exposes 15 fields with key fields HierarchyType, UniversalHierHierarchyID, HierarchyNode, ParentNode, HierarchyNodeClass. It has 2 associations to related views. Part of development package FINS_GEN_SEL.

Data Sources (1)

Source	Alias	Join Type
FIN_SEL_HIER_NODE	_HierarchyNode	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	FIN_SEL_HIER	_Hierarchy	`$projection.HierarchyType = _Hierarchy.HierarchyType and $projection.UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate`
[0..*]	FIN_SEL_HIER_NODE_RELATION	_ParentNode	`$projection.HierarchyType = _ParentNode.HierarchyType and $projection.UniversalHierHierarchyID = _ParentNode.UniversalHierHierarchyID and $projection.HierarchyNodeClass = _ParentNode.HierarchyNodeClass and $projection.ParentNode = _ParentNode.HierarchyNode and $projection.ValidityEndDate = _ParentNode.ValidityEndDate`

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	FINSELHNR	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#A	view

Fields (15)

Key	Field	Source Table	Source Field	Description
KEY	HierarchyType	FIN_SEL_HIER_NODE	HierarchyType	Hierarchy Type
KEY	UniversalHierHierarchyID	FIN_SEL_HIER_NODE	UniversalHierHierarchyID	Hierarchy ID
KEY	HierarchyNode	FIN_SEL_HIER_NODE	HierarchyNode	Node
KEY	ParentNode	FIN_SEL_HIER_NODE	ParentNode	Parent Node
KEY	HierarchyNodeClass	FIN_SEL_HIER_NODE	HierarchyNodeClass	Node Class
KEY	ValidityEndDate	FIN_SEL_HIER_NODE	ValidityEndDate	ValidTo
	ValidityStartDate	FIN_SEL_HIER_NODE	ValidityStartDate	Validity Start Date
	NodeType	FIN_SEL_HIER_NODE	NodeType	Object Type
	HierarchyNodeVal	FIN_SEL_HIER_NODE	HierarchyNodeVal	Value
	HierarchyNodeSequence	FIN_SEL_HIER_NODE	HierarchyNodeSequence	Sequence Number
	HierarchyNodeLevel	FIN_SEL_HIER_NODE	HierarchyNodeLevel	Hierarchy Node Level
	UnivHierarchyBusinessEntity	FIN_SEL_HIER_NODE	UnivHierarchyBusinessEntity	Business Entity
	HierarchyNodeText
	_Hierarchy		_Hierarchy
	_ParentNode		_ParentNode

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 FIN_SEL_HIER_NODE_RELATION.
-- 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: FINSELHNR

CREATE VIEW FIN_SEL_HIER_NODE_RELATION AS
SELECT
  _HierarchyNode.HierarchyType AS HierarchyType,
  _HierarchyNode.UniversalHierHierarchyID AS UniversalHierHierarchyID,
  _HierarchyNode.HierarchyNode AS HierarchyNode,
  _HierarchyNode.ParentNode AS ParentNode,
  _HierarchyNode.HierarchyNodeClass AS HierarchyNodeClass,
  _HierarchyNode.ValidityEndDate AS ValidityEndDate,
  _HierarchyNode.ValidityStartDate AS ValidityStartDate,
  _HierarchyNode.NodeType AS NodeType,
  _HierarchyNode.HierarchyNodeVal AS HierarchyNodeVal,
  _HierarchyNode.HierarchyNodeSequence AS HierarchyNodeSequence,
  _HierarchyNode.HierarchyNodeLevel AS HierarchyNodeLevel,
  _HierarchyNode.UnivHierarchyBusinessEntity AS UnivHierarchyBusinessEntity,
  _HierarchyNode._Text[1: Language = $session.system_language].HierarchyNodeText AS HierarchyNodeText
FROM FIN_SEL_HIER_NODE AS _HierarchyNode
LEFT OUTER JOIN FIN_SEL_HIER AS _Hierarchy ON HierarchyType = _Hierarchy.HierarchyType AND UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN FIN_SEL_HIER_NODE_RELATION AS _ParentNode ON HierarchyType = _ParentNode.HierarchyType AND UniversalHierHierarchyID = _ParentNode.UniversalHierHierarchyID AND HierarchyNodeClass = _ParentNode.HierarchyNodeClass AND ParentNode = _ParentNode.HierarchyNode AND ValidityEndDate = _ParentNode.ValidityEndDate  -- association [0..*]
;

Depth:

FIN_SEL_HIER_NODE_RELATION view

FIN_SEL_HIER_NODE view