I_MSTRPROJITEMLIST

CDS View

Master Project Item List

I_MSTRPROJITEMLIST is a CDS View in S/4HANA. Master Project Item List. It contains 25 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 25 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_KPIProgress view inner COMPOSITE KPI: Progress
P_MstrProjActuals view from COMPOSITE
P_MstrProjWIP view from COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 3
KEY MasterProjectUUID MasterProjectUUID 3
Country Country 2
Currency Currency 1
Customer Customer 2
EndDate EndDate 2
FinancialRisk FinancialRisk 2
Industry Industry 2
MasterProjectIsConfidential MasterProjectIsConfidential 3
MasterProjectItem MasterProjectItem 2
MasterProjectItemObjectType MasterProjectItemObjectType 2
MasterProjectItemUUID MasterProjectItemUUID 2
MasterProjectName MasterProjectName 2
MasterProjectOrganization MasterProjectOrganization 3
MasterProjectStage MasterProjectStage 2
MasterProjectType MasterProjectType 3
MstrProjCutOffDate MstrProjCutOffDate 1
OverallRisk OverallRisk 2
PostingPeriod PostingPeriod 1
ProjectRisk ProjectRisk 2
ProjectUUID ProjectUUID 1
Region Region 2
StartDate StartDate 2
TechnicalRisk TechnicalRisk 2
WorkType WorkType 2 
@AbapCatalog.sqlViewName: 'IMSTRPROJITEM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Item List'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MstrProjItemList
  as select from I_MasterProject     as MasterProject
    inner join   I_MasterProjectItem as MasterProjectItem on MasterProjectItem.MasterProjectUUID = MasterProject.MasterProjectUUID
    association [1..1] to I_MasterProjectCurrency as _Currency on $projection.MasterProjectUUID = _Currency.MasterProjectUUID
{
  MasterProject.MasterProjectUUID,
  MasterProject.MasterProject,
  MasterProject.MasterProjectName,
  MasterProject.MasterProjectType,
  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.MasterProjectUUID_E,

  MasterProject.ProjectUUID,
  MasterProjectItem.MasterProjectItemUUID,
  // MasterProjectItem.MstrProjParentkeyOfItem,

  MasterProjectItem.MasterProjectItemObjectType,
  MasterProjectItem.MasterProjectItem,
  MasterProjectItem.CreatedByUser,
  MasterProjectItem.CreationDateTime,
  MasterProjectItem.LastChangedByUser,
  MasterProjectItem.LastChangeDateTime,
  case when MasterProject.Currency = ''
  then _Currency.Currency
  else
  MasterProject.Currency
  end as Currency,
  MasterProject.MstrProjCutOffDate,
  concat( substring(MasterProject.MstrProjCutOffDate, 1, 4), concat('0',substring(MasterProject.MstrProjCutOffDate, 5, 2))) as PostingPeriod
  //concat(0,substring(MasterProject.MstrProjCutOffDate, 5, 2))

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

Learn More