P_EntProjCostLineItems

@AbapCatalog.sqlViewName: 'PEPSRPRLS'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
define view P_EntProjCostLineItems
  as select from    I_ProjectCostLineItems       as ProjCost
    left outer join I_EnterpriseProject          as EntProj       on ProjCost.ProjectInternalID = EntProj.ProjectInternalID
    left outer join I_PPM_ProjTeamMembersCntNoSt as TeamMemberCnt on TeamMemberCnt.ProjectSummaryTaskUUID = EntProj.ProjectSummaryTaskUUID

  association [0..1] to I_SingleResponsibleForProj as _Responsible on _Responsible.ReferencedObjectUUID = EntProj.ProjectSummaryTaskUUID
{

  key  EntProj.ProjectSummaryTaskUUID,
  key  ProjCost.ProjectInternalID,
  key  EntProj.ProjectUUID,
       EntProj.Project,
       EntProj.ProjectDescription,
       EntProj.ProfitCenter,
       EntProj.FunctionalArea,
       EntProj.ResponsibleCostCenter,
       EntProj.ProjectStartDate,
       EntProj.ProjectEndDate,
       EntProj.CompanyCode,
       EntProj.ControllingArea,
       case
          when EntProj.ProjectStartDate > '19000101'
            and EntProj.ProjectEndDate > '19000101'
          then cast ((dats_days_between(EntProj.ProjectStartDate, EntProj.ProjectEndDate) + 1) as numberofdays )
          else 0
       end                                           as PlannedDuration,
       // Actual Costs Excluding Settlements

       sum(case
       when ProjCost.IsSettled = 'X'
       then  ProjCost.ActualAmountInGlobalCurrency
       else 0  end)                                  as ActualAmountInGlobalCurrency,
       sum(ProjCost.PlanAmountInGlobalCurrency)      as PlanAmountInGlobalCurrency,
       ProjCost.GlobalCurrency,
       _Responsible.BusinessPartnerUUID,
       _Responsible.BusinessPartnerFullName,
       cast( TeamMemberCnt.TeamMemberCount as int4 ) as TeamMemberCount
}

group by
  EntProj.ProjectSummaryTaskUUID,
  ProjCost.ProjectInternalID,
  EntProj.Project,
  EntProj.ProjectUUID,
  EntProj.ProjectDescription,
  EntProj.ProfitCenter,
  EntProj.FunctionalArea,
  EntProj.ResponsibleCostCenter,
  EntProj.ProjectStartDate,
  EntProj.ProjectEndDate,
  EntProj.CompanyCode,
  EntProj.ControllingArea,
  ProjCost.GlobalCurrency,
  _Responsible.BusinessPartnerUUID,
  _Responsible.BusinessPartnerFullName,
  TeamMemberCnt.TeamMemberCount
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTERPRISEPROJECT",
"I_PPM_PROJTEAMMEMBERSCNTNOST",
"I_PROJECTCOSTLINEITEMS",
"I_SINGLERESPONSIBLEFORPROJ"
],
"ASSOCIATED":
[
"I_SINGLERESPONSIBLEFORPROJ"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/