I_CPROJECTITEM

CDS View

CProject Item

I_CPROJECTITEM is a CDS View in S/4HANA. CProject Item. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Cproject view union_all COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
ExternalObjectIdentifier ExternalObjectIdentifier 1
MasterProjectItem MasterProjectItem 1
MasterProjectItemObjectType MasterProjectItemObjectType 1
MasterProjectUUID MasterProjectUUID 1 
@AbapCatalog.sqlViewName: 'ICPROJECTITEM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'CProject Item'
define view I_CProjectItem
  as select from I_CProject       as CProject
    inner join   I_MasterProjectPpmObject         as ppmcproobject       on ppmcproobject.ExternalObjectIdentifier = CProject.ProjectExternalID
    inner join   iaom_ext_obj_inf as ExternalObjInfo on ExternalObjInfo.ext_object_id = ppmcproobject.ExternalProjectTaskIdentifier

{


  ExternalObjInfo.ext_object_id    as ProjectExternalID,

  ExternalObjInfo.acc_ass_object as ExternalObjectIdentifier,

  CProject.MasterProjectUUID,


  CProject.MasterProjectItem,

  CProject.MasterProjectItemObjectType,
  CProject._MasterProject
}
where
  ExternalObjInfo.bus_scenario_id = 'CPROJECTS'

Learn More