I_SegmentHierNode

DDL: I_SEGMENTHIERNODE SQL: IFISEGMENTHN Type: view BASIC
14 Fields 1 Data Sources 3 Associations

Segment Hierarchy Node

I_SegmentHierNode is a Basic CDS View that provides data about "Segment Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (hrrp_node_n) and exposes 14 fields with key fields SegmentHierarchy, HierarchyNode, ValidityEndDate. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Purpose
This CDS view represents the hierarchical structure of segments in financial accounting, providing a parent-child hierarchy node structure. It enables the organization and navigation of segments in a tree-like hierarchy with validity periods, supporting both analytical and reporting requirements for segment-based financial analysis. This CDS view provides the data to answer the following business questions: What is the complete hierarchical structure of segments within a specific segment hierarchy? Which segments are organized under which parent nodes in the segment hierarchy? What is the sequence and level of each node within the segment hierarchy? Which segment hierarchies are valid for a specific date or time period? What are the parent-child relationships between different segments in the organizational structure? How are segments ordered within their hierarchy level (sibling order)? Which segments belong to a specific hierarchy node at a given validity date? What is the depth (hierarchy level) of each segment node in the organizational structure? Which segment hierarchies were active during a specific time range based on validity start and end dates? What are the textual descriptions associated with each hierarchy node across different languages? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Restriction Type ID Restriction Type HRYTYPE_HRYID_OH Hierarchy Type/ID for Overhead Accounting HRYTYPE_HRYID_LI Hierarchy Type/ID for Liquidity Item HRYTYPE_HRYID_BS Hierarchy Type/ID for Budget Specialist HRYTYPE_HRYID_SA Hierarchy Type/ID for Sales Accounting HRYTYPE_HRYID Hierarchy Type/ID HRYTYPE_HRYID_BAM Hierarchy Type/ID for Bank Account Management HRYTYPE_HRYID_CS Hierarchy Type/ID for Consolidation HRYTYPE_HRYID_DV Hierarchy Type/ID for Profit Center Accounting HRYTYPE_HRYID_GL Hierarchy Type/ID for General Ledger Accounting HRYTYPE_HRYID_GM Hierarchy Type/ID for Grants Management HRYTYPE_HRYID_FA Hierarchy Type/ID for Fund Accounting HRYTYPE_HRYID_FFS Hierarchy Type/ID for Financial Services Enhancements HRYTYPE_HRYID_PM Hierarchy Type/ID for Master Data - Product Master HRYTYPE_HRYID_CIT Hierarchy Type/ID for Corporate Income Tax HRYTYPE_HRYID_CS_AND_REF Hierarchy Type/ID for Consolidation including references You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Fields Used for Filtering The main filters are as follows: Field Name Label SegmentHierarchy segm hryid ValidityEndDate Validity End Date Important Fields Important fields in this view include the following: Field Name Label SegmentHierarchy segm hryid HierarchyNode Node ValidityEndDate Validity End Date ValidityStartDate Validity Start Date ParentNode Par. Node HierarchyVersion Version Segment Segment SequenceNumber HierarchyNodeSequence Sequence Number HierarchyNodeLevel Hierarchy Level NodeType Node Type

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
hrrp_node_n hrrp_node_n from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_SegmentHierNodeT _Text $projection.SegmentHierarchy = _Text.SegmentHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.Segment = ''
[0..1] I_Segment _Segment $projection.Segment = _Segment.Segment
[1..1] I_SegmentHierarchy _Hierarchy $projection.SegmentHierarchy = _Hierarchy.SegmentHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate

Annotations (21)

NameValueLevelField
EndUserText.label Segment Hierarchy Node view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFISEGMENTHN view
Hierarchy.parentChild.recurse.parent ParentNode view
Hierarchy.parentChild.recurse.child HierarchyNode view
Hierarchy.parentChild.siblingsOrder.by HierarchyNodeSequence view
Hierarchy.parentChild.siblingsOrder.direction ASC view
Hierarchy.parentChild.directory _Hierarchy view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey HierarchyNode view
ObjectModel.modelingPattern #ANALYTICAL_PARENT_CHILD_HIERARCHY_NODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #HIERARCHY view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name SegmentHierarchyNode view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SegmentHierarchy
KEY HierarchyNode hrrp_node_n hrynode Node
KEY ValidityEndDate
ValidityStartDate
ParentNode hrrp_node_n parnode Par. Node
HierarchyVersion
Segment hrrp_node_n segment Segment number
SequenceNumber
HierarchyNodeSequence hrrp_node_n hryseqnbr Sequence Number
HierarchyNodeLevel hrrp_node_n hrylevel Hierarchy Level
NodeType hrrp_node_n nodetype Object Type
_Text _Text
_Segment _Segment
_Hierarchy _Hierarchy

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 I_SegmentHierNode.
-- 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: IFISEGMENTHN

CREATE VIEW I_SegmentHierNode AS
SELECT
  cast(hrrp_node_n.hryid as fis_hryid_segment preserving type ) AS SegmentHierarchy,
  hrrp_node_n.hrynode AS HierarchyNode,
  cast(hrrp_node_n.hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  hrrp_node_n.parnode AS ParentNode,
  cast( '000000000000001' as hryversn ) AS HierarchyVersion,
  hrrp_node_n.segment AS Segment,
  concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode) AS SequenceNumber,
  hrrp_node_n.hryseqnbr AS HierarchyNodeSequence,
  hrrp_node_n.hrylevel AS HierarchyNodeLevel,
  hrrp_node_n.nodetype AS NodeType
FROM hrrp_node_n
LEFT OUTER JOIN I_SegmentHierNodeT AS _Text ON SegmentHierarchy = _Text.SegmentHierarchy AND HierarchyNode = _Text.HierarchyNode AND Segment = ''  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentHierarchy AS _Hierarchy ON SegmentHierarchy = _Hierarchy.SegmentHierarchy AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [1..1]
;

Learn More