I_FunctionalAreaHierNode

DDL: I_FUNCTIONALAREAHIERNODE SQL: IFIFNCAREAHN Type: view BASIC
15 Fields 1 Data Sources 3 Associations

Functional Area Hierarchy Node

I_FunctionalAreaHierNode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

FunctionalAreaHierarchyNode · Accounting and Financial Close

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

SAP Help Documentation

CategoryCDS Views for Master Data
Purpose
This CDS view is designed to represent the hierarchy of functional areas within an organization. It provides a structured view of the relationships between different nodes in the hierarchy, including parent-child relationships, node sequences, and validity dates. The view is essential for analyzing and managing the organizational structure related to functional areas. This CDS view provides the data to answer the following business questions: What is the hierarchical structure of functional areas within the organization? How are different functional area nodes related in terms of parent-child relationships? What are the validity periods for each node in the functional area hierarchy? How can I access additional textual descriptions and details for specific hierarchy nodes? How can I identify the sequence and level of each node within the functional area hierarchy? What are the node types and values associated with each hierarchy node? 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 the following authorization objects assigned: Authorization Object ID Authorization Object Text F_UNI_HIER Universal Hierarchy Access

Structure
Fields Used for Filtering The main filters are as follows: Field Name Label FunctionalAreaHierarchy Func. Area Hierarchy ValidityEndDate Validity End Date Important Fields Important fields in this view include the following: Field Name Description HierarchyNode Node ParentNode Par. Node HierarchyNodeVal Value FunctionalArea Functional Area FunctionalAreaHierarchy Func. Area Hierarchy NodeType Node Type SequenceNumber ValidityStartDate Validity Start Date ValidityEndDate Validity End Date HierarchyNodeLevel Hierarchy Level HierarchyNodeSequence Sequence Number HierarchyVersion Version

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

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-A
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Hierarchies in Analytics, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
hrrp_node_n hrrp_node_n from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_FunctionalAreaHierNodeT _Text $projection.FunctionalAreaHierarchy = _Text.FunctionalAreaHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.FunctionalArea = ''
[0..1] I_FunctionalArea _FunctionalArea $projection.FunctionalArea = _FunctionalArea.FunctionalArea
[1..1] I_FunctionalAreaHierarchy _Hierarchy $projection.FunctionalAreaHierarchy = _Hierarchy.FunctionalAreaHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate

Annotations (19)

NameValueLevelField
EndUserText.label Functional Area Hierarchy Node view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFIFNCAREAHN 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
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #HIERARCHY view
ObjectModel.modelingPattern #ANALYTICAL_PARENT_CHILD_HIERARCHY_NODE view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY FunctionalAreaHierarchy Functional Area Hierarchy
KEY HierarchyNode hrrp_node_n hrynode Hierarchy node
KEY ValidityEndDate Validity End Date
ValidityStartDate Validity Start Date
ParentNode hrrp_node_n parnode Hierarchy parent node
HierarchyVersion Hierarchy version
FunctionalArea hrrp_node_n fkber Functional Area
SequenceNumber
HierarchyNodeSequence hrrp_node_n hryseqnbr Hierarchy Sequence Number
HierarchyNodeLevel hrrp_node_n hrylevel Hierarchy Level
NodeType hrrp_node_n nodetype Hierarchy node type
HierarchyNodeVal hrrp_node_n nodevalue Node value
_Text _Text
_FunctionalArea _FunctionalArea
_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_FunctionalAreaHierNode.
-- 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: IFIFNCAREAHN

CREATE VIEW I_FunctionalAreaHierNode AS
SELECT
  cast ( hrrp_node_n.hryid_42 as fis_hryid_functionalarea_42 preserving type ) AS FunctionalAreaHierarchy,
  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.fkber AS FunctionalArea,
  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,
  hrrp_node_n.nodevalue AS HierarchyNodeVal
FROM hrrp_node_n
LEFT OUTER JOIN I_FunctionalAreaHierNodeT AS _Text ON FunctionalAreaHierarchy = _Text.FunctionalAreaHierarchy AND HierarchyNode = _Text.HierarchyNode AND FunctionalArea = ''  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaHierarchy AS _Hierarchy ON FunctionalAreaHierarchy = _Hierarchy.FunctionalAreaHierarchy AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [1..1]
;

Learn More