I_CnsldtnProject

DDL: I_CNSLDTNPROJECT SQL: ICSPROJECT Type: view BASIC

Consolidation Combined Project

I_CnsldtnProject is a Basic CDS View (Dimension) that provides data about "Consolidation Combined Project" in SAP S/4HANA. It has 3 associations to related views.

5 fields

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CnsldtnProjectT _Text $projection.Project = _Text.Project
[0..*] I_CnsldtnProjectHierNode _ProjectHierNode $projection.Project = _ProjectHierNode.Project
[1..1] I_CnsldtnMDSource _MDSource $projection.AdditionalMasterDataSource = _MDSource.AdditionalMasterDataSource

Annotations (12)

NameValueLevelField
EndUserText.label Consolidation Combined Project view
AbapCatalog.sqlViewName ICSPROJECT view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Project Project Project Definition
AdditionalMasterDataSource AdditionalMasterDataSource
_MDSource _MDSource
_Text _Text
_ProjectHierNode _ProjectHierNode 
@EndUserText.label: 'Consolidation Combined Project'
@AbapCatalog.sqlViewName: 'ICSPROJECT'
@VDM.viewType: #BASIC

@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

  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
{

      @EndUserText.label: 'Project Definition'
      @ObjectModel.text.association: '_Text'
      @ObjectModel.hierarchy.association: '_ProjectHierNode'
  key Project,
      @ObjectModel.foreignKey.association: '_MDSource'
      AdditionalMasterDataSource,
      _MDSource,

      _Text,

      _ProjectHierNode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CNSLDTNPROJECT"
],
"ASSOCIATED":
[
"I_CNSLDTNMDSOURCE",
"I_CNSLDTNPROJECTHIERNODE",
"I_CNSLDTNPROJECTT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More