P_PPM_PROJECTMILESTESSENTDATE

CDS View

P_PPM_PROJECTMILESTESSENTDATE is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPM_ProjectMilestEssent view from COMPOSITE UUID of essential milestone of proj. 
// @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