I_ProdUniversalHierarchy

DDL: I_PRODUNIVERSALHIERARCHY Type: view COMPOSITE
4 Fields 1 Data Sources 1 Associations

Product Hierarchy Directory

I_ProdUniversalHierarchy is a Composite CDS View (Dimension) that provides data about "Product Hierarchy Directory" in SAP S/4HANA. It reads from 1 data source (I_ProdUnivHierarchyBasic) and exposes 4 fields with key fields ProductHierarchy, ProdHierarchyValidityEndDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdUnivHierarchyBasic dir from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProdUniversalHierarchyText_2 _Text $projection.ProductHierarchy = _Text.ProdUnivHierarchy and $projection.ProdHierarchyValidityEndDate = _Text.ProdHierarchyValidityEndDate

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPRDUNIVHRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
EndUserText.label Product Hierarchy Directory view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ProductHierarchy view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProductHierarchy I_ProdUnivHierarchyBasic ProdUnivHierarchy
KEY ProdHierarchyValidityEndDate I_ProdUnivHierarchyBasic ProdHierarchyValidityEndDate
ProdHierarchyValidityStartDate I_ProdUnivHierarchyBasic ProdHierarchyValidityStartDate
ProdUnivHierarchyText

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_ProdUniversalHierarchy.
-- 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_ProdUniversalHierarchy AS
SELECT
  dir.ProdUnivHierarchy AS ProductHierarchy,
  dir.ProdHierarchyValidityEndDate AS ProdHierarchyValidityEndDate,
  dir.ProdHierarchyValidityStartDate AS ProdHierarchyValidityStartDate,
  _Text[1: Language = $session.system_language ].ProdUnivHierarchyText AS ProdUnivHierarchyText
FROM I_ProdUnivHierarchyBasic AS dir
LEFT OUTER JOIN I_ProdUniversalHierarchyText_2 AS _Text ON ProductHierarchy = _Text.ProdUnivHierarchy AND ProdHierarchyValidityEndDate = _Text.ProdHierarchyValidityEndDate  -- association [0..*]
;

Learn More