P_PPM_PROJECTMILESTRELNEXTDATE

CDS View

P_PPM_PROJECTMILESTRELNEXTDATE 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_ProjectMilestRelNext view from COMPOSITE UUID of next relevant milestone of proj. 
// @EndUserText.label: 'Date of next relevant milestone of proj.'

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

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

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

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
define view P_PPM_ProjectMilestRelNextDate as select from I_PPM_Task as task
            inner join I_PPM_Tasktype as tasktype
                on task.TaskType = tasktype.TaskType
                and ( tasktype.IsRelevantMilestone = 'X'
                      or tasktype.IsEssentialMilestone = 'X' )
{
    key task.ProjectUUID,
    min(task.LatestFinishDateTime) as MilestoneDateTime
 }
 where  task.IsProjectMilestone = 'X'
        and task.TaskProcessingStatus >= '10'
        and task.TaskProcessingStatus < '20'      
 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