I_MasterProjectItemList

DDL: I_MASTERPROJECTITEMLIST SQL: IMPITEMLIST Type: view COMPOSITE Package: VDM_CPM_WS

Master Project Item List

I_MasterProjectItemList is a Composite CDS View that provides data about "Master Project Item List" in SAP S/4HANA. It reads from 3 data sources (I_MasterProject, I_MstrProjUsrAuthList, I_MasterProjectItem) and exposes 28 fields. It has 1 association to related views. Part of development package VDM_CPM_WS.

3 data source(s) 28 fields

Data Sources (3)

SourceAliasJoin Type
I_MasterProject MasterProject inner
I_MstrProjUsrAuthList MasterProjectAuth inner
I_MasterProjectItem MasterProjectItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MasterProjectCurrency _Currency $projection.MasterProjectUUID = _Currency.MasterProjectUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPITEMLIST view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Master Project Item List view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MstrProjUsrAuthList MasterProjectUUID
MasterProject I_MstrProjUsrAuthList MasterProject
MasterProjectName I_MasterProject MasterProjectName
MasterProjectStage I_MasterProject MasterProjectStage
StartDate I_MasterProject StartDate
EndDate I_MasterProject EndDate
Customer I_MasterProject Customer
MasterProjectOrganization I_MasterProject MasterProjectOrganization
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
Country I_MasterProject Country
Region I_MasterProject Region
WorkType I_MasterProject WorkType
Industry I_MasterProject Industry
ProjectRisk I_MasterProject ProjectRisk
FinancialRisk I_MasterProject FinancialRisk
TechnicalRisk I_MasterProject TechnicalRisk
OverallRisk I_MasterProject OverallRisk
MasterProjectItemUUID I_MasterProjectItem MasterProjectItemUUID
MasterProjectItemObjectType I_MasterProjectItem MasterProjectItemObjectType
MasterProjectItem I_MasterProjectItem MasterProjectItem
CreatedByUser I_MasterProjectItem CreatedByUser
CreationDateTime I_MasterProjectItem CreationDateTime
LastChangedByUser I_MasterProjectItem LastChangedByUser
LastChangeDateTime I_MasterProjectItem LastChangeDateTime
UserIsInvolved I_MstrProjUsrAuthList UserIsInvolved
MasterProjectType I_MstrProjUsrAuthList MasterProjectType
CurrencyendasCurrency
MstrProjCutOffDate I_MasterProject MstrProjCutOffDate 
@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