A_CnsldtnProject

DDL: A_CNSLDTNPROJECT SQL: ACSPROJECT Type: view COMPOSITE Package: FIN_CS_MD_API

Combined Project

A_CnsldtnProject is a Composite CDS View that provides data about "Combined Project" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnProject) and exposes 6 fields with key field Project. It has 2 associations to related views. Part of development package FIN_CS_MD_API.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnProject I_CnsldtnProject from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_CnsldtnProjectT _CnsldtnProjectT $projection.Project = _CnsldtnProjectT.Project
[0..*] A_CnsldtnProjectHier _CnsldtnProjectHier $projection.MDHierType = _CnsldtnProjectHier.MDHierType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ACSPROJECT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Combined Project view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
OData.entitySet.name Project view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Project _Source Project
MDHierType
HierarchyType
AdditionalMasterDataSource _Source AdditionalMasterDataSource
_CnsldtnProjectHier _CnsldtnProjectHier
_CnsldtnProjectT _CnsldtnProjectT
@AbapCatalog.sqlViewName: 'ACSPROJECT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Combined Project'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: ['Project']
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C  ,
  sizeCategory: #L
}
@OData.entitySet.name: 'Project'
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view A_CnsldtnProject
  as select from I_CnsldtnProject _Source
  
  association [0..*] to A_CnsldtnProjectT    as _CnsldtnProjectT    on $projection.Project = _CnsldtnProjectT.Project

  association [0..*] to A_CnsldtnProjectHier as _CnsldtnProjectHier on $projection.MDHierType = _CnsldtnProjectHier.MDHierType

{
      @ObjectModel.text.association: '_CnsldtnProjectT'
  key _Source.Project,

      @Consumption.hidden: true
      cast ( 'CS10' as hrytype ) as MDHierType,

      @Consumption.hidden: true
      cast ( 'CS10' as hrytype ) as HierarchyType,

      _Source.AdditionalMasterDataSource,


      /* associations*/
      _CnsldtnProjectHier,
      _CnsldtnProjectT
}