P_PPM_ProjectPhaseCurrentDates

// @EndUserText.label: 'Date and Sorting Number of current project phase'

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PPPMPROJPHASECDS'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:  #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.representativeKey: 'ProjectUUID'

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
define view P_PPM_ProjectPhaseCurrentDates as select from P_PPM_ProjectPhaseCurrentDate as projectPhaseCurrentDate
                                      inner join I_PPM_Task as task
                                      on projectPhaseCurrentDate.ProjectUUID = task.ProjectUUID
                                      and projectPhaseCurrentDate.LatestStartDateTime = task.LatestStartDateTime
                                      and task.ObjectType ='PPO'
                                      and task.TaskProcessingStatus = '10'                                          
{
    key task.ProjectUUID,
    task.LatestStartDateTime,
    min(task.SortingNumber) as SortingNumber     
} group by task.ProjectUUID, task.LatestStartDateTime;