C_MasterProjectBasicData

@AbapCatalog.sqlViewName: 'CMPBASICDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label:'Basic Data - Single Project Overview Screen'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory:#XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.dbHints: [{dbSystem: #HDB,
                        hint:     'NO_RECOMPILE_WITH_SQL_PARAMETERS'}]
define view C_MasterProjectBasicData
  as select from    I_MasterProject
    left outer to one join I_Mstrprojissuechangreq   on I_MasterProject.MasterProject = I_Mstrprojissuechangreq.MasterProject
    left outer to one join I_ActiveRisk              on I_MasterProject.MasterProject = I_ActiveRisk.MasterProject
    left outer to one join I_ODActivity              on I_MasterProject.MasterProject = I_ODActivity.MasterProject
    left outer to one join I_ActivitiesDueInNextWeek on I_MasterProject.MasterProject = I_ActivitiesDueInNextWeek.MasterProject
    association [1..1 ] to I_MstrProjNmbrOfPurReqns as _MPPRCount on $projection.MasterProject = _MPPRCount.MasterProject
    association [1..1] to I_MstrProjNmbrOfOvrdPurOrds as _MPPOCount on $projection.MasterProject = _MPPOCount.MasterProject

//    left outer join I_MstrProjNmbrOfPurReqns  on I_MasterProject.ProjectUUID = I_MstrProjNmbrOfPurReqns.ProjectUUID

//    left outer join I_MstrProjNmbrOfOvrdPurOrds on I_MasterProject.ProjectUUID = I_MstrProjNmbrOfOvrdPurOrds.ProjectUUID

//    left outer join C_MstrProjPRCount         on I_MasterProject.MasterProject       = C_MstrProjPRCount.MasterProject

//    left outer join I_MstrProjPOOverdue       on I_MasterProject.MasterProject       = I_MstrProjPOOverdue.MasterProject

{
  key I_MasterProject.ProjectUUID,
  // key I_MasterProject.MasterProjectUUID_E,

      I_MasterProject.MasterProjectUUID,
      I_MasterProject.MasterProject,
      I_MasterProject.MasterProjectName,
      I_MasterProject.MasterProjectIsConfidential,
      I_MasterProject.MasterProjectType,
      I_MasterProject.MasterProjectOrganization,
      I_Mstrprojissuechangreq.ChangeRequest,
      I_Mstrprojissuechangreq.Issue,
      I_ActivitiesDueInNextWeek.NmbrOfActiesDueInNextWeek,
      I_ActiveRisk.MstrProjActiveRiskCount,
      I_ODActivity.NumberOfOverdueActivities,
//      I_MstrProjNmbrOfPurReqns.NumberOfPurchaseRequisitions,

//      I_MstrProjNmbrOfOvrdPurOrds.NumberOfPurchaseOrders

      _MPPRCount.NumberOfPurchaseRequisitions,
      _MPPOCount.NumberOfPurchaseOrders
      
//      _MPPRCount,

//      _MPPOCount 

      
} 
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACTIVERISK",
"I_ACTIVITIESDUEINNEXTWEEK",
"I_MASTERPROJECT",
"I_MSTRPROJISSUECHANGREQ",
"I_MSTRPROJNMBROFOVRDPURORDS",
"I_MSTRPROJNMBROFPURREQNS",
"I_ODACTIVITY"
],
"ASSOCIATED":
[
"I_MSTRPROJNMBROFOVRDPURORDS",
"I_MSTRPROJNMBROFPURREQNS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/