I_FunctionalAreaHierarchy

DDL: I_FUNCTIONALAREAHIERARCHY SQL: IFIFUNCAREAH Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Functional Area Hierarchy

I_FunctionalAreaHierarchy (Basic)

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

Functional Area Hierarchy · Accounting and Financial Close

I_FunctionalAreaHierarchy is a Basic CDS View (Dimension) that provides data about "Functional Area Hierarchy" in SAP S/4HANA. It reads from 1 data source (hrrp_dir_n) and exposes 8 fields with key fields FunctionalAreaHierarchy, ValidityEndDate. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Data CategoryDimension
Purpose
This CDS view is designed to represent the hierarchy of functional areas within an organization. It provides a structured view of functional area data, including validity dates and change tracking information, which can be used for analytical purposes and data extraction. This CDS view provides the data to answer the following business questions: What are the hierarchical relationships between different functional areas within the organization? What are the validity periods for each functional area hierarchy? Who last changed the functional area hierarchy data, and when was it changed? How can the functional area hierarchy be used for analytical reporting and data extraction purposes? 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
Important Fields Important fields in this view include the following: Field Name Description LastChangedByUser Last Changed By FunctionalAreaHierarchy Func. Area Hierarchy HierarchyShortID Hierarchy ID ValidityStartDate Validity Start Date ValidityEndDate Validity End Date LastChangeDateTime Updated At

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

Deprecated Fields
Note At least one element of this CDS view is deprecated. We recommend that you switch to the following successor elements: Deprecated Element Successor Element LastChangeTime LastChangeDateTime For more information about the deprecation process for CDS views, see Deprecated and Decommissioned CDS Views .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-A
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction, Analytical Dimension
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
hrrp_dir_n hrrp_dir_n from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_FunctionalAreaHierarchyT _Text $projection.FunctionalAreaHierarchy = _Text.FunctionalAreaHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (15)

NameValueLevelField
EndUserText.label Functional Area Hierarchy view
ObjectModel.representativeKey FunctionalAreaHierarchy view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFIFUNCAREAH view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name FunctionalAreaHierarchy view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FunctionalAreaHierarchy Functional Area Hierarchy
KEY ValidityEndDate Validity End Date
ValidityStartDate Validity Start Date
LastChangedByUser hrrp_dir_n upduser Last Changed By
LastChangeDateTime hrrp_dir_n updtime Last Updated At (Timestamp)
LastChangeTime hrrp_dir_n updtime Last Updated At (Timestamp)
HierarchyShortID hrrp_dir_n hrysid Hierarchy ID
_Text _Text

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_FunctionalAreaHierarchy.
-- 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: IFIFUNCAREAH

CREATE VIEW I_FunctionalAreaHierarchy AS
SELECT
  cast ( hrrp_dir_n.hryid_42 as fis_hryid_functionalarea_42 preserving type ) AS FunctionalAreaHierarchy,
  cast(hrrp_dir_n.hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  cast(hrrp_dir_n.hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  hrrp_dir_n.upduser AS LastChangedByUser,
  hrrp_dir_n.updtime AS LastChangeDateTime,
  hrrp_dir_n.updtime AS LastChangeTime,
  hrrp_dir_n.hrysid AS HierarchyShortID
FROM hrrp_dir_n
LEFT OUTER JOIN I_FunctionalAreaHierarchyT AS _Text ON FunctionalAreaHierarchy = _Text.FunctionalAreaHierarchy AND ValidityEndDate = _Text.ValidityEndDate  -- association [1..*]
;

Learn More