I_MASTERPROJECTITEMLIST

CDS View

Master Project Item List

I_MASTERPROJECTITEMLIST is a CDS View in S/4HANA. Master Project Item List. It contains 28 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 28 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_MasterProjectSalesOrder view from COMPOSITE Get MasterProject Sales Order
I_MPNetwork view from COMPOSITE Get Master Project Network
I_MPNetworkActivity view from COMPOSITE Get Master Project Network Activity
I_MPWBSElement view from COMPOSITE Get Master Project WBS Elements
I_MstrProjMlstnDte view from COMPOSITE Get Project Next Milestone Date
I_MstrProjStrctrElmntWBC view from COMPOSITE Master Project Structure Element for WBC
I_MstrProjStrctrElmntWBC view union COMPOSITE Master Project Structure Element for WBC
I_MstrProjStructure view from COMPOSITE Master Project Structure Element
I_MstrProjStructureElement view from COMPOSITE Master Project Structure Element
I_MstrProjWBSElement view from COMPOSITE PROJECT COMPANION WBS ELEM
P_Mpnwe view from COMPOSITE
P_MPStructureElement view union COMPOSITE
P_Mpwbs view from COMPOSITE
P_MstrProjHierarchy view union COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 12
KEY MasterProjectUUID MasterProjectUUID 9
Country Country 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
Currency Currency 2
Customer Customer 2
EndDate EndDate 2
FinancialRisk FinancialRisk 2
Industry Industry 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MasterProjectIsConfidential MasterProjectIsConfidential 11
MasterProjectItem MasterProjectItem,MstrProjAnchorObjectInternalID 6
MasterProjectItemObjectType ControllingObjectType,MasterProjectItemObjectType 5
MasterProjectItemUUID MasterProjectItemUUID 2
MasterProjectName MasterProjectName 9
MasterProjectOrganization MasterProjectOrganization 11
MasterProjectStage MasterProjectStage 3
MasterProjectType MasterProjectType 12
MstrProjCutOffDate MstrProjCutOffDate 2
OverallRisk OverallRisk 2
ProjectRisk ProjectRisk 2
Region Region 2
StartDate StartDate 2
TechnicalRisk TechnicalRisk 2
UserIsInvolved UserIsInvolved 2
WorkType WorkType 2 
@AbapCatalog.sqlViewName: 'IMPITEMLIST'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Master Project Item List'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MasterProjectItemList
  as select from I_MasterProjectItem as MasterProjectItem
    inner join I_MstrProjUsrAuthList as MasterProjectAuth on MasterProjectItem.MasterProjectUUID = MasterProjectAuth.MasterProjectUUID
    inner join   I_MasterProject     as MasterProject on MasterProjectAuth.MasterProjectUUID = MasterProject.MasterProjectUUID
    association [1..1] to I_MasterProjectCurrency as _Currency on $projection.MasterProjectUUID = _Currency.MasterProjectUUID
{
  MasterProjectAuth.MasterProjectUUID,
  MasterProjectAuth.MasterProject,
  MasterProject.MasterProjectName,
  MasterProject.MasterProjectStage,
  MasterProject.StartDate,
  MasterProject.EndDate,
  MasterProject.Customer,
  MasterProject.MasterProjectOrganization,
  MasterProject.MasterProjectIsConfidential,
  MasterProject.Country,
  MasterProject.Region,
  MasterProject.WorkType,
  MasterProject.Industry,
  MasterProject.ProjectRisk,
  MasterProject.FinancialRisk,
  MasterProject.TechnicalRisk,
  MasterProject.OverallRisk,

  //MasterProject.Currency,

  MasterProjectItem.MasterProjectItemUUID,
  // MasterProjectItem.MstrProjParentkeyOfItem,

  MasterProjectItem.MasterProjectItemObjectType,
  MasterProjectItem.MasterProjectItem,
  MasterProjectItem.CreatedByUser,
  MasterProjectItem.CreationDateTime,
  MasterProjectItem.LastChangedByUser,
  MasterProjectItem.LastChangeDateTime,
  MasterProjectAuth.UserIsInvolved,
  MasterProjectAuth.MasterProjectType,


  case when MasterProject.Currency = ''
  then _Currency.Currency
  else
  MasterProject.Currency
  end as Currency,
  MasterProject.MstrProjCutOffDate


}

Learn More