P_EntProjElmntBlockFunc

@AbapCatalog.sqlViewName: 'PBLOCKFUNC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@VDM: {
    viewType: #COMPOSITE,
    private: true
}
@ObjectModel: {
  
   usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #L
    }
}
@ClientHandling.algorithm: #SESSION_VARIABLE 
 define view P_EntProjElmntBlockFunc as select from I_PPM_ProjectTask as ProjectElement
    left outer to one join I_EntProjElmntBlockFunc as EntProjElmntTimeRecgIsBlkd 
        on      ProjectElement.TaskUUID = EntProjElmntTimeRecgIsBlkd.ParentObjectUUID
         and    EntProjElmntTimeRecgIsBlkd.EntProjElementFunctionID      = 'S001'
    left outer to one join I_EntProjElmntBlockFunc as EntProjStaffExpnpostgIsBlkd 
        on      ProjectElement.TaskUUID = EntProjStaffExpnpostgIsBlkd.ParentObjectUUID
         and    EntProjStaffExpnpostgIsBlkd.EntProjElementFunctionID   = 'S003'
    left outer to one join I_EntProjElmntBlockFunc as EntProjSrvcPostgIsBlkd 
        on      ProjectElement.TaskUUID = EntProjSrvcPostgIsBlkd.ParentObjectUUID
         and    EntProjSrvcPostgIsBlkd.EntProjElementFunctionID   = 'S002'
    left outer to one join I_EntProjElmntBlockFunc as EntProjOthExpnPostgIsBlkd 
        on      ProjectElement.TaskUUID = EntProjOthExpnPostgIsBlkd.ParentObjectUUID
         and    EntProjOthExpnPostgIsBlkd.EntProjElementFunctionID     = 'S004'

{

   
    key  ProjectElement.TaskUUID as TaskUUID,
    ProjectElement.ProjectUUID as ProjectUUID,
    
    EntProjElmntTimeRecgIsBlkd.EntProjElementFunctionIsBlkd      as EntProjElmntTimeRecgIsBlkd ,    
    EntProjStaffExpnpostgIsBlkd.EntProjElementFunctionIsBlkd   as EntProjStaffExpnpostgIsBlkd ,    
    EntProjSrvcPostgIsBlkd.EntProjElementFunctionIsBlkd   as EntProjSrvcPostgIsBlkd ,    
    EntProjOthExpnPostgIsBlkd.EntProjElementFunctionIsBlkd     as EntProjOthExpnPostgIsBlkd,
    
    _ProjectRoot
    

   
};             

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTPROJELMNTBLOCKFUNC",
"I_PPM_PROJECTTASK"
],
"ASSOCIATED":
[
"I_PPM_PROJECTROOT"
],
"BASE":
[
"I_PPM_PROJECTTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/