I_CPROJECTITEM
CProject Item
I_CPROJECTITEM is a CDS View in S/4HANA. CProject Item. It contains 4 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Cproject | view | union_all | COMPOSITE |
Fields (4)
| Key | Field | CDS Fields | Used 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'