P_PPM_PROJECTPHASECURRENTDATES

CDS View

Date and Sorting Number of current project phase

P_PPM_PROJECTPHASECURRENTDATES is a CDS View in S/4HANA. Date and Sorting Number of current project phase. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPM_ProjectPhaseCurrent view from COMPOSITE UUID of next project phase 
// @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;

Learn More