P_Trrmonbaseplan

@AbapCatalog.sqlViewName: 'PTRRMONBASEPLAN'
//@ClientDependent: true

@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_Trrmonbaseplan
  as

  select from       prps            as prps
    inner join      P_Trrmonaccprin as cust   on  cust.abgsl = prps.abgsl
                                              and cust.bukrs = prps.pbukr

    inner join      fins_trr_acp    as acp    on  acp.acc_principle = cust.acc_principle
                                              and acp.bukrs         = cust.bukrs

    left outer join acdocp          as acdocp on  acdocp.ps_psp_pnr = prps.pspnr
                                              and acdocp.rbukrs     = prps.pbukr
                                              and acdocp.rldnr      = cust.rldnr
                                              and acdocp.category   = acp.plan_category

    left outer join cskb            as cskb   on  cskb.kokrs = acdocp.kokrs
                                              and cskb.kstar = acdocp.racct
                                              and cskb.datab <= $session.system_date
                                              and cskb.datbi > $session.system_date
{
  key prps.pspnr,
  key prps.pbukr,
  key cust.rldnr,
      sum( case when cskb.katyp <> '11' and cskb.katyp <> '12' then acdocp.hsl else 0 end )   as  PlannedCosAmtInCCCrcy,
      sum( case when cskb.katyp = '11' or cskb.katyp = '12' then -1 * acdocp.hsl else 0 end ) as  PlannedRevenueAmtInCCCrcy
}

group by
  prps.pspnr,
  prps.pbukr,
  cust.rldnr
;