I_CProjectItem

DDL: I_CPROJECTITEM SQL: ICPROJECTITEM Type: view BASIC

CProject Item

I_CProjectItem is a Basic CDS View that provides data about "CProject Item" in SAP S/4HANA. It reads from 3 data sources (I_CProject, iaom_ext_obj_inf, I_MasterProjectPpmObject) and exposes 6 fields.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_CProject CProject from
iaom_ext_obj_inf ExternalObjInfo inner
I_MasterProjectPpmObject ppmcproobject inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICPROJECTITEM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label CProject Item view

Fields (6)

KeyFieldSource TableSource FieldDescription
ProjectExternalID iaom_ext_obj_inf ext_object_id
ExternalObjectIdentifier iaom_ext_obj_inf acc_ass_object
MasterProjectUUID I_CProject MasterProjectUUID
MasterProjectItem I_CProject MasterProjectItem
MasterProjectItemObjectType I_CProject MasterProjectItemObjectType
_MasterProject I_CProject _MasterProject 
@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'




/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CPROJECT",
"I_MASTERPROJECTPPMOBJECT",
"IAOM_EXT_OBJ_INF"
],
"ASSOCIATED":
[
"I_MASTERPROJECT"
],
"BASE":
[
"I_CPROJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More