A_GrantCoreHierNode

DDL: A_GRANTCOREHIERNODE SQL: AGRANTCOREHRYNOD Type: view COMPOSITE

Grant Hierarchy Node

A_GrantCoreHierNode is a Composite CDS View that provides data about "Grant Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_GrantHierarchyNode) and exposes 12 fields with key fields GrantHierarchy, HierarchyNode, ValidityEndDate. It has 1 association to related views. It is exposed through 1 OData service (API_GRANTCOREHIERARCHY).

1 data source(s) Exposed by 1 service(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_GrantHierarchyNode I_GrantHierarchyNode from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_GrantCoreHierarchyNodeText _GrantCoreHierarchyNodeText $projection.GrantHierarchy = _GrantCoreHierarchyNodeText.GrantHierarchy and $projection.ValidityEndDate = _GrantCoreHierarchyNodeText.ValidityEndDate and $projection.HierarchyNode = _GrantCoreHierarchyNodeText.HierarchyNode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AGRANTCOREHRYNOD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Grant Hierarchy Node 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 A_GrantCoreHierNode_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_GRANTCOREHIERARCHY API_GRANTCOREHIERARCHY V2 C2 C1

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY GrantHierarchy GrantHierarchy
KEY HierarchyNode HierarchyNode
KEY ValidityEndDate ValidityEndDate
ParentNode ParentNode
HierarchyVersion HierarchyVersion
ValidityStartDate ValidityStartDate
GrantID GrantID
HierarchyNodeSequence HierarchyNodeSequence
HierarchyNodeLevel HierarchyNodeLevel
NodeType NodeType
_GrantCoreHierarchy _GrantCoreHierarchy
_GrantCoreHierarchyNodeText _GrantCoreHierarchyNodeText 
@AbapCatalog.sqlViewName: 'AGRANTCOREHRYNOD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Grant Hierarchy Node'
@VDM.viewType:#COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #XL
  }
}
@OData.entityType.name: 'A_GrantCoreHierNode_Type'
@Metadata.ignorePropagatedAnnotations:true

define view A_GrantCoreHierNode
  as select from I_GrantHierarchyNode
  association [0..*] to A_GrantCoreHierarchyNodeText as _GrantCoreHierarchyNodeText on  $projection.GrantHierarchy  = _GrantCoreHierarchyNodeText.GrantHierarchy
                                                                                    and $projection.ValidityEndDate = _GrantCoreHierarchyNodeText.ValidityEndDate
                                                                                    and $projection.HierarchyNode   = _GrantCoreHierarchyNodeText.HierarchyNode
  association        to parent A_GrantCoreHierarchy  as _GrantCoreHierarchy         on  $projection.GrantHierarchy  = _GrantCoreHierarchy.GrantHierarchy
                                                                                    and $projection.ValidityEndDate = _GrantCoreHierarchy.ValidityEndDate
{
  key GrantHierarchy,
  key HierarchyNode,
  key ValidityEndDate,
      ParentNode,
      HierarchyVersion,
      ValidityStartDate,
      GrantID,
      HierarchyNodeSequence,
      HierarchyNodeLevel,
      NodeType,
      /* Associations */
      _GrantCoreHierarchy,
      _GrantCoreHierarchyNodeText
}

Learn More