P_PPM_PROJECTPHASECURRENTDATE
P_PPM_PROJECTPHASECURRENTDATE is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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":""
}
}*/