C_FunctionalAreaHierNode

DDL: C_FUNCTIONALAREAHIERNODE SQL: CFIFNCAREAHN Type: view CONSUMPTION
12 Fields 2 Data Sources 1 Associations

API Functional Area Hierarchy Node

C_FunctionalAreaHierNode is a Consumption CDS View that provides data about "API Functional Area Hierarchy Node" in SAP S/4HANA. It reads from 2 data sources (I_FunctionalAreaHierarchy, I_FunctionalAreaHierNode) and exposes 12 fields with key fields FunctionalAreaHierarchy, HierarchyNode, ValidityEndDate. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_FunctionalAreaHierarchy _Hierarchy inner
I_FunctionalAreaHierNode I_FunctionalAreaHierNode from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_FunctionalAreaHierNodeT _Text $projection.FunctionalAreaHierarchy = _Text.FunctionalAreaHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.FunctionalArea = ''

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CFIFNCAREAHN view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label API Functional Area Hierarchy Node view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FunctionalAreaHierarchy I_FunctionalAreaHierNode FunctionalAreaHierarchy
KEY HierarchyNode HierarchyNode Node
KEY ValidityEndDate I_FunctionalAreaHierNode ValidityEndDate ValidTo
ValidityStartDate I_FunctionalAreaHierNode ValidityStartDate Validity Start Date
ParentNode ParentNode Parent Node
HierarchyVersion HierarchyVersion Version
FunctionalArea FunctionalArea Sendr Fctl Area
SequenceNumber SequenceNumber Sort sequence
HierarchyNodeSequence HierarchyNodeSequence Sequence Number
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
NodeType NodeType Object Type
_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 C_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: CFIFNCAREAHN

CREATE VIEW C_FunctionalAreaHierNode AS
SELECT
  I_FunctionalAreaHierNode.FunctionalAreaHierarchy AS FunctionalAreaHierarchy,
  HierarchyNode,
  I_FunctionalAreaHierNode.ValidityEndDate AS ValidityEndDate,
  I_FunctionalAreaHierNode.ValidityStartDate AS ValidityStartDate,
  ParentNode,
  HierarchyVersion,
  FunctionalArea,
  SequenceNumber,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  NodeType
FROM I_FunctionalAreaHierNode
INNER JOIN I_FunctionalAreaHierarchy AS _Hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_FunctionalAreaHierNodeT AS _Text ON FunctionalAreaHierarchy = _Text.FunctionalAreaHierarchy AND HierarchyNode = _Text.HierarchyNode AND FunctionalArea = ''  -- association [0..*]
;

Learn More