P_PPM_ProjectMilestRelNextDate

DDL: P_PPM_PROJECTMILESTRELNEXTDATE Type: view COMPOSITE

P_PPM_ProjectMilestRelNextDate 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 PPPMPROJMLSTRND 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 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

Learn More