A_CNSLDTNPROJECTHIER

CDS View

Combined Project Hierarchy

A_CNSLDTNPROJECTHIER is a CDS View in S/4HANA. Combined Project Hierarchy. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CnsldtnProjectHierT view inner BASIC Combined Project Hierarchy Text

Fields (1)

KeyField CDS FieldsUsed in Views
NodeType NodeType 1 
@AbapCatalog.sqlViewName: 'ACSPROJECTHIER'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #XL}
  }
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@OData.entitySet.name: 'ProjectHier'
@EndUserText.label: 'Combined Project Hierarchy'

define view A_CnsldtnProjectHier
  as select from I_CnsldtnProjectHierNode as _HierarchyNode

  association [0..1] to A_CnsldtnProject      as _CnsldtnProject        on  $projection.Project = _CnsldtnProject.Project

  association [0..*] to A_CnsldtnProjectHierT as _CnsldtnProjectHierT   on  $projection.AdditionalMasterDataHierarchy = _CnsldtnProjectHierT.AdditionalMasterDataHierarchy
                                                                        and $projection.HierarchyNode                 = _CnsldtnProjectHierT.HierarchyNode
                                                                        and $projection.Project                       = ''

  association [0..*] to A_CnsldtnProjectHierT as _CnsldtnProjectHierT_2 on  $projection.AdditionalMasterDataHierarchy = _CnsldtnProjectHierT_2.AdditionalMasterDataHierarchy
                                                                        and $projection.HierarchyNode                 = _CnsldtnProjectHierT_2.HierarchyNode
                                                                        and $projection.ValidityEndDate               = _CnsldtnProjectHierT_2.ValidityEndDate
                                                                        and $projection.Project                       = ''


  association [0..*] to A_CnsldtnProjectT     as _CnsldtnProjectT       on  $projection.Project = _CnsldtnProjectT.Project

{

  key _HierarchyNode.AdditionalMasterDataHierarchy,

      @ObjectModel.text.association: '_CnsldtnProjectHierT_2'
  key _HierarchyNode.HierarchyNode,

  key _HierarchyNode.ValidityEndDate,

      _HierarchyNode.ParentNode,

      @Semantics.businessDate.from: true
      _HierarchyNode.ValidityStartDate,

      @ObjectModel.text.association: '_CnsldtnProjectT'
      _HierarchyNode.Project,

      // STS - compatible ATC cleanup change - to be removed

      cast(_HierarchyNode.HierarchyNodeSequence as abap.char( 56 ) ) as SequenceNumber,

      // STS - compatible ATC cleanup change

      _HierarchyNode.HierarchyNodeSequence,


      _HierarchyNode.HierarchyNodeLevel,

      _HierarchyNode.NodeType,

      @Consumption.hidden: true
      cast( 'CS10' as fincs_hierarchytype preserving type )          as MDHierType,
      @Consumption.hidden: true
      cast( 'CS10' as fincs_hierarchytype preserving type )          as HierarchyType,


      /* assocs */
      _CnsldtnProject,
      _CnsldtnProjectT,
      _CnsldtnProjectHierT,
      _CnsldtnProjectHierT_2
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNPROJECTHIERNODE"
],
"ASSOCIATED":
[
"A_CNSLDTNPROJECT",
"A_CNSLDTNPROJECTHIERT",
"A_CNSLDTNPROJECTT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More