I_CNSLDTNPROJECT

CDS View

Consolidation Combined Project

I_CNSLDTNPROJECT is a CDS View in S/4HANA. Consolidation Combined Project. It contains 2 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 2 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_CnsldtnProject view from COMPOSITE Combined Project
C_CnsldtnProject view_entity from CONSUMPTION Consolidation Project
I_CnsldtnProjectT view inner COMPOSITE Consolidation Combined Project Text
I_CnsldtnProjectVH view_entity from COMPOSITE Consolidation Project

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Project Project 2
CnsldtnIsAdditionalMasterData CnsldtnIsAdditionalMasterData 1 
@EndUserText.label: 'Consolidation Combined Project'
@AbapCatalog.sqlViewName: 'ICSPROJECT'
@VDM.viewType: #COMPOSITE

@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction.enabled: false
}
//@Analytics.internalName: #LOCAL

@ObjectModel.representativeKey: ['Project']
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:  [ '_Text' ]

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C  ,
  sizeCategory: #L
}

define view I_CnsldtnProject
  as

  select distinct from P_CnsldtnProject as _Source

  association [0..*] to I_CnsldtnProjectT        as _Text            on $projection.Project = _Text.Project

  association [0..*] to I_CnsldtnProjectHierNode as _ProjectHierNode on $projection.Project = _ProjectHierNode.Project

  association [1..1] to I_CnsldtnMDSource        as _MDSource        on $projection.AdditionalMasterDataSource = _MDSource.AdditionalMasterDataSource

{

      @ObjectModel.text.association: '_Text'
      @ObjectModel.hierarchy.association: '_ProjectHierNode'
  key cast( _Source.Project as fincs_project preserving type )                                              as Project,

      @ObjectModel.foreignKey.association: '_MDSource'
      cast( max ( _Source.AdditionalMasterDataSource ) as fincs_masterdatasource preserving type )          as AdditionalMasterDataSource,

      cast( max ( _Source.CnsldtnIsAdditionalMasterData ) as fincs_isadditionalmasterdata preserving type ) as CnsldtnIsAdditionalMasterData,

      @Semantics.systemDateTime.createdAt
      cast( min ( CreationDateTime ) as fincs_creationdatetime preserving type )                            as CreationDateTime,

      /* associations */
      _Text,
      _ProjectHierNode,
      _MDSource

}
where
  _Source.Project is not initial //required to avoid access to corrupt database entries

group by
  _Source.Project

Learn More