P_PPM_ProjectPhaseCurrentDate

DDL: P_PPM_PROJECTPHASECURRENTDATE SQL: PPPMPROJPHASECUD Type: view COMPOSITE Package: VDM_PPM_OBJECTS_PROJECT

Date of current project phase

P_PPM_ProjectPhaseCurrentDate is a Composite CDS View that provides data about "Date of current project phase" in SAP S/4HANA. It reads from 1 data source (I_PPM_Task) and exposes 2 fields with key field ProjectUUID. Part of development package VDM_PPM_OBJECTS_PROJECT.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_Task task from

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PPPMPROJPHASECUD view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey ProjectUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_PPM_Task ProjectUUID
LatestStartDateTime 
// @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

Learn More