I_MASTERPROJECTITEM

CDS View

Master Project Item

I_MASTERPROJECTITEM is a CDS View in S/4HANA. Master Project Item. It contains 8 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 8 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CProject view from BASIC CProject Higher Level Nodes
I_MasterProjectCurrency view from BASIC Get master Project Currency
I_MasterProjectItemList view from COMPOSITE Master Project Item List
I_MstrProjFinancialPlan view inner COMPOSITE Commercial Project Financial Plan
I_MstrProjItemList view inner BASIC Master Project Item List
I_MstrProjItemListSimple view from COMPOSITE Simplified Master Project Items List

Fields (8)

KeyField CDS FieldsUsed in Views
KEY MasterProjectItemUUID MasterProjectItemUUID 5
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MasterProjectItem MasterProjectItem 5
MasterProjectItemObjectType MasterProjectItemObjectType 5
MasterProjectUUID MasterProjectUUID 1 
@AbapCatalog.sqlViewName: 'IMASTERPROJITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Project Item'
@AbapCatalog.preserveKey:true
define view I_MasterProjectItem
  as select from /cpd/d_mp_item as MasterProjectItem
  association [1..1] to  I_MasterProject     as _MasterProject on MasterProjectItem.parent_key = _MasterProject.MasterProjectUUID

{

  key MasterProjectItem.db_key       as MasterProjectItemUUID,
  MasterProjectItem.parent_key   as MasterProjectUUID,
  MasterProjectItem.mp_itm_otyp  as MasterProjectItemObjectType,
  MasterProjectItem.mp_item_okey as MasterProjectItem,
  MasterProjectItem.created_by   as CreatedByUser,
  cast(MasterProjectItem.created_on as /cpd/cpm_createdon)   as CreationDateTime,
  MasterProjectItem.changed_by   as LastChangedByUser,
  cast(MasterProjectItem.changed_on as /cpd/cpm_changedon)  as LastChangeDateTime,
  _MasterProject

}

Learn More