I_CustUnivHierarchyNode

DDL: I_CUSTUNIVHIERARCHYNODE Type: view COMPOSITE
12 Fields 1 Data Sources 3 Associations

Customer Hierarchy Node

I_CustUnivHierarchyNode is a Composite CDS View that provides data about "Customer Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_CustUnivHierarchyNodeBase) and exposes 12 fields with key fields CustomerUniversalHierarchy, HierarchyNode, CustHierarchyValidityEndDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustUnivHierarchyNodeBase node from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CustUnivHierarchyBase _CustomerHierarchy $projection.CustomerUniversalHierarchy = _CustomerHierarchy.CustomerUniversalHierarchy and $projection.CustHierarchyValidityEndDate = _CustomerHierarchy.CustHierarchyValidityEndDate
[0..*] I_CustUnivHierNodeText _Text $projection.CustomerUniversalHierarchy = _Text.CustomerUniversalHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.Customer = ''
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTUHFND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Customer Hierarchy Node view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #HIERARCHY 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 _CustomerHierarchy view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CustomerUniversalHierarchy I_CustUnivHierarchyNodeBase CustomerUniversalHierarchy Hierarchy ID
KEY HierarchyNode I_CustUnivHierarchyNodeBase HierarchyNode Customer Hierarchy Node
KEY CustHierarchyValidityEndDate I_CustUnivHierarchyNodeBase CustHierarchyValidityEndDate
CustHierarchyValidityStartDate I_CustUnivHierarchyNodeBase CustHierarchyValidityStartDate
ParentNode I_CustUnivHierarchyNodeBase ParentNode Parent Node
Customer I_CustUnivHierarchyNodeBase Customer Sold-to Party
HierarchyNodeSequence I_CustUnivHierarchyNodeBase HierarchyNodeSequence Sequence Number
NodeType I_CustUnivHierarchyNodeBase NodeType Object Type
HierarchyNodeLevel I_CustUnivHierarchyNodeBase HierarchyNodeLevel Hierarchy Node Level
_CustomerHierarchy _CustomerHierarchy
_Text _Text
_Customer _Customer

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_CustUnivHierarchyNode.
-- 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.

CREATE VIEW I_CustUnivHierarchyNode AS
SELECT
  node.CustomerUniversalHierarchy AS CustomerUniversalHierarchy,
  node.HierarchyNode AS HierarchyNode,
  node.CustHierarchyValidityEndDate AS CustHierarchyValidityEndDate,
  node.CustHierarchyValidityStartDate AS CustHierarchyValidityStartDate,
  node.ParentNode AS ParentNode,
  node.Customer AS Customer,
  node.HierarchyNodeSequence AS HierarchyNodeSequence,
  node.NodeType AS NodeType,
  node.HierarchyNodeLevel AS HierarchyNodeLevel
FROM I_CustUnivHierarchyNodeBase AS node
LEFT OUTER JOIN I_CustUnivHierarchyBase AS _CustomerHierarchy ON CustomerUniversalHierarchy = _CustomerHierarchy.CustomerUniversalHierarchy AND CustHierarchyValidityEndDate = _CustomerHierarchy.CustHierarchyValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_CustUnivHierNodeText AS _Text ON CustomerUniversalHierarchy = _Text.CustomerUniversalHierarchy AND HierarchyNode = _Text.HierarchyNode AND Customer = ''  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;

Learn More