I_CProject

DDL: I_CPROJECT SQL: ICPROJECT Type: view BASIC Package: VDM_CPM_WS

CProject Higher Level Nodes

I_CProject is a Basic CDS View that provides data about "CProject Higher Level Nodes" in SAP S/4HANA. It reads from 2 data sources (iaom_ext_obj_inf, I_MasterProjectItem) and exposes 8 fields. It has 1 association to related views. Part of development package VDM_CPM_WS.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
iaom_ext_obj_inf ExternalObjInfo inner
I_MasterProjectItem MasterProjectItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MasterProject _MasterProject $projection.MasterProjectUUID = _MasterProject.MasterProjectUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICPROJECT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CProject Higher Level Nodes view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
ProjectExternalID iaom_ext_obj_inf ext_object_id
ExternalObjectIdentifier iaom_ext_obj_inf acc_ass_object
Project iaom_ext_obj_inf business_key
MasterProjectUUID I_MasterProjectItem MasterProjectUUID
MasterProjectItemUUID I_MasterProjectItem MasterProjectItemUUID
MasterProjectItem I_MasterProjectItem MasterProjectItem
MasterProjectItemObjectType I_MasterProjectItem MasterProjectItemObjectType
_MasterProject _MasterProject 
@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