P_PPM_ProjectMilestEssentDate

DDL: P_PPM_PROJECTMILESTESSENTDATE Type: view COMPOSITE

P_PPM_ProjectMilestEssentDate is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PPM_Task, I_PPM_Tasktype) and exposes 2 fields with key field ProjectUUID.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_PPM_Task task from
I_PPM_Tasktype tasktype inner

Annotations (11)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PPPMPROJMLSTED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_PPM_Task ProjectUUID
MilestoneDateTime 
// @EndUserText.label: 'Date of essential milestone of proj.'

@VDM.private: true
@VDM.viewType: #COMPOSITE

@AbapCatalog: { 
    sqlViewName: 'PPPMPROJMLSTED',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
   representativeKey: 'ProjectUUID',
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #L
   }
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
/* Specifications
   S1. Should determine the date of the essential milestone of a project
   S2. Only milestones which are marked as essential (attribute of task type) are considered
*/ 
define view P_PPM_ProjectMilestEssentDate as select from I_PPM_Task as task
            inner join I_PPM_Tasktype as tasktype
                on task.TaskType = tasktype.TaskType
                and ( tasktype.IsEssentialMilestone = 'X' )
{
    key task.ProjectUUID,
    min(task.LatestFinishDateTime) as MilestoneDateTime
 }
 where  task.IsProjectMilestone = 'X'   
 group by task.ProjectUUID                                                                 
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TASK",
"I_PPM_TASKTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More