A_FundedProgramHierNode

DDL: A_FUNDEDPROGRAMHIERNODE Type: view CONSUMPTION

Funded Program Hierarchy Node

A_FundedProgramHierNode is a Consumption CDS View that provides data about "Funded Program Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_FundedProgramHierarchyNode) and exposes 12 fields with key fields FinancialManagementArea, FundedProgramHierarchy, HierarchyNode, ValidityEndDate. It is exposed through 1 OData service (API_FUNDEDPROGRAMHIERARCHY).

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

Data Sources (1)

SourceAliasJoin Type
I_FundedProgramHierarchyNode I_FundedProgramHierarchyNode from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AFUNDEDPROGHN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Funded Program Hierarchy Node view
VDM.viewType #CONSUMPTION 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_FundedProgramHierNode_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_FUNDEDPROGRAMHIERARCHY API_FUNDEDPROGRAMHIERARCHY V2 C2 C1

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_FundedProgramHierarchyNode FinancialManagementArea
KEY FundedProgramHierarchy I_FundedProgramHierarchyNode FundedProgramHierarchy
KEY HierarchyNode I_FundedProgramHierarchyNode HierarchyNode
KEY ValidityEndDate I_FundedProgramHierarchyNode ValidityEndDate
ParentNode I_FundedProgramHierarchyNode ParentNode
HierarchyVersion I_FundedProgramHierarchyNode HierarchyVersion
ValidityStartDate I_FundedProgramHierarchyNode ValidityStartDate
FundedProgram I_FundedProgramHierarchyNode FundedProgram
HierarchyNodeSequence I_FundedProgramHierarchyNode HierarchyNodeSequence
HierarchyNodeLevel I_FundedProgramHierarchyNode HierarchyNodeLevel
NodeType I_FundedProgramHierarchyNode NodeType
_FundedProgramHierarchy _FundedProgramHierarchy 
@AbapCatalog: {
  sqlViewName: 'AFUNDEDPROGHN',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Funded Program Hierarchy Node'
@VDM.viewType:#CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #XL
  }
}
@OData.entityType.name: 'A_FundedProgramHierNode_Type'
@Metadata.ignorePropagatedAnnotations:true

define view A_FundedProgramHierNode
  as select from I_FundedProgramHierarchyNode
  //  association [0..*] to A_FundCoreHierarchyNodeText as _FundCoreHierarchyNodeText on  $projection.FundHierarchy   = _FundCoreHierarchyNodeText.FundHierarchy

  //                                                                                  and $projection.ValidityEndDate = _FundCoreHierarchyNodeText.ValidityEndDate

  //                                                                                  and $projection.HierarchyNode   = _FundCoreHierarchyNodeText.HierarchyNode

  association to parent A_FundedProgramHierarchy as _FundedProgramHierarchy on  $projection.FinancialManagementArea = _FundedProgramHierarchy.FinancialManagementArea
                                                                            and $projection.FundedProgramHierarchy  = _FundedProgramHierarchy.FundedProgramHierarchy
                                                                            and $projection.ValidityEndDate         = _FundedProgramHierarchy.ValidityEndDate
{
  key I_FundedProgramHierarchyNode.FinancialManagementArea,
  key I_FundedProgramHierarchyNode.FundedProgramHierarchy,
  key I_FundedProgramHierarchyNode.HierarchyNode,
  key I_FundedProgramHierarchyNode.ValidityEndDate,
      I_FundedProgramHierarchyNode.ParentNode,
      I_FundedProgramHierarchyNode.HierarchyVersion,
      I_FundedProgramHierarchyNode.ValidityStartDate,
      I_FundedProgramHierarchyNode.FundedProgram,
      I_FundedProgramHierarchyNode.HierarchyNodeSequence,
      I_FundedProgramHierarchyNode.HierarchyNodeLevel,
      I_FundedProgramHierarchyNode.NodeType,
      /* Associations */
      _FundedProgramHierarchy
      //      I_FundedProgramHierarchyNodeT

}

Learn More