I_CPROJECT

CDS View

CProject Higher Level Nodes

I_CPROJECT is a CDS View in S/4HANA. CProject Higher Level Nodes. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CProjectItem view from BASIC CProject Item
P_Cproject view from COMPOSITE CPROJECT

Fields (5)

KeyField CDS FieldsUsed in Views
_MasterProject _MasterProject 1
MasterProjectItem MasterProjectItem 2
MasterProjectItemObjectType MasterProjectItemObjectType 2
MasterProjectUUID MasterProjectUUID 2
ProjectExternalID ProjectExternalID 1 
@AbapCatalog.sqlViewName: 'ICPROJECT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CProject Higher Level Nodes'
@VDM.viewType: #BASIC
define view I_CProject
  as select from I_MasterProjectItem as MasterProjectItem
    inner join   iaom_ext_obj_inf    as ExternalObjInfo on ExternalObjInfo.ext_object_id = MasterProjectItem.MasterProjectItem
    association [1..1] to I_MasterProject as _MasterProject on $projection.MasterProjectUUID = _MasterProject.MasterProjectUUID

{

  ExternalObjInfo.ext_object_id    as ProjectExternalID,
  ExternalObjInfo.acc_ass_object as ExternalObjectIdentifier,
  ExternalObjInfo.business_key as Project,
  MasterProjectItem.MasterProjectUUID,
  MasterProjectItem.MasterProjectItemUUID,
  MasterProjectItem.MasterProjectItem,
  MasterProjectItem.MasterProjectItemObjectType,
  _MasterProject


}
where
  ExternalObjInfo.bus_scenario_id = 'CPROJECTS'

Learn More