A_GrantCoreHierarchy

DDL: A_GRANTCOREHIERARCHY SQL: AGRANTCOREHRY Type: view COMPOSITE Package: PSM_S4C_API
5 Fields 1 Data Sources 2 Associations 1 OData Services

Grant Hierarchy

A_GrantCoreHierarchy is a Composite CDS View that provides data about "Grant Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_GrantHierarchy) and exposes 5 fields with key fields GrantHierarchy, ValidityEndDate. It has 2 associations to related views. It is exposed through 1 OData service (API_GRANTCOREHIERARCHY). Part of development package PSM_S4C_API.

Data Sources (1)

SourceAliasJoin Type
I_GrantHierarchy I_GrantHierarchy from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_GrantCoreHierarchyText _GrantCoreHierarchyText $projection.GrantHierarchy = _GrantCoreHierarchyText.GrantHierarchy and $projection.ValidityEndDate = _GrantCoreHierarchyText.ValidityEndDate
[0..*] A_GrantCoreHierNode _GrantCoreHierNode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AGRANTCOREHRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Grant Hierarchy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name GrantCoreHierarchy_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_GRANTCOREHIERARCHY API_GRANTCOREHIERARCHY V2 C2 C1

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY GrantHierarchy GrantHierarchy
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
_GrantCoreHierarchyText _GrantCoreHierarchyText
_GrantCoreHierNode _GrantCoreHierNode

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 A_GrantCoreHierarchy.
-- 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: AGRANTCOREHRY

CREATE VIEW A_GrantCoreHierarchy AS
SELECT
  GrantHierarchy,
  ValidityEndDate,
  ValidityStartDate
FROM I_GrantHierarchy
LEFT OUTER JOIN A_GrantCoreHierarchyText AS _GrantCoreHierarchyText ON GrantHierarchy = _GrantCoreHierarchyText.GrantHierarchy AND ValidityEndDate = _GrantCoreHierarchyText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN A_GrantCoreHierNode AS _GrantCoreHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More