P_PPM_PROJECTPHASECURRENTDATE

CDS View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PPM_ProjectPhaseCurrentDates view from COMPOSITE
// @EndUserText.label: 'Date of current project phase'

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PPPMPROJPHASECUD'
@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
/* Specifications
   S1. Should determine the date of the next milestone of a project
   S2. Only milestones which are marked as relevant (attribute of task type) are considered
   S3. Only milestoned with has been released are considered
*/ 
define view P_PPM_ProjectPhaseCurrentDate as select from I_PPM_Task as task
{
    key task.ProjectUUID,
    min(task.LatestStartDateTime) as LatestStartDateTime
 }
 where  task.ObjectType = 'PPO' //phase 

        and task.TaskProcessingStatus = '10'     
 group by task.ProjectUUID                                                                
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TASK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/