I_PPM_ProjectCostSumCurrent

@AbapCatalog.sqlViewName: 'IPPMPRJCSTSUMCUR'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE

@ObjectModel: {
  usageType:{ sizeCategory: #XXL,
              dataClass:    #MIXED,
              serviceQuality: #D    }
}
@Consumption.semanticObject: 'EnterpriseProject'

@AccessControl.authorizationCheck:    #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Project Cost To Current Date'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 
// this excludes future costs


define view I_PPM_ProjectCostSumCurrent
  as select from I_PPM_ProjectSummaryTask   as Project      // get all projets

//    inner join  P_PPM_ProjCostMappingWBS    as WBSMap       // get all cost objects

//            on  Project.ProjectInternalID  = WBSMap.ProjectInternalID            

//    inner join  I_ProjectCostLineItems      as CostItem     // get all costs

//           on   CostItem.ProjectObjectNode = WBSMap.WBSObjectNode

//            and CostItem.IsCommitment       <> 'X' 

//    inner join  I_PPM_CurrentPeriod         as CurrentPeriod

//          on    Project.ProjectInternalID  = CurrentPeriod.ProjectInternalID

//    inner join  I_FiscalYearPeriodForCmpnyCode  as FiscalPeriod     

//            on  CostItem.FiscalYear   = FiscalPeriod.FiscalYear

//            and CostItem.FiscalPeriod = FiscalPeriod.FiscalPeriod

//            and CostItem.CompanyCode  = FiscalPeriod.CompanyCode

//            

    // additional  associations to authorization views

    association [0..1] to I_PPM_AuthznByUsrH        as _AuthUserFin
            on      _AuthUserFin.ReferencedObjectUUID   = $projection.ProjectSummaryTaskUUID
             and    _AuthUserFin.UserID                 = $session.user
             and    _AuthUserFin.Activity = 'Financials'
    association [0..*] to I_PPM_AuthznBySubstitH    as _AuthSubstFin 
            on      _AuthSubstFin.ReferencedObjectUUID  = $projection.ProjectSummaryTaskUUID
             and    _AuthSubstFin.UserID                = $session.user
             and    _AuthSubstFin.Activity = 'Financials' 
    association [0..*] to I_PPM_AuthznByUserRoleH   as _AuthRoleFin
            on      _AuthRoleFin.ReferencedObjectUUID   = $projection.ProjectSummaryTaskUUID
             and    _AuthRoleFin.UserID                 = $session.user
             and    _AuthRoleFin.Activity = 'Financials' 
    association [0..*] to I_PPM_AuthznByUsrGrpH     as _AuthGroupFin
            on      _AuthGroupFin.ReferencedObjectUUID  = $projection.ProjectSummaryTaskUUID
             and    _AuthGroupFin.UserID                = $session.user
             and    _AuthGroupFin.Activity = 'Financials'         
            
{
key Project.ProjectSummaryTaskUUID,
    @Semantics.currencyCode:true
//key CostItem.GlobalCurrency,

key cast ('EUR' as fis_rkcur) as GlobalCurrency,
    Project.ProjectInternalID,

//    @Semantics.amount.currencyCode: 'GlobalCurrency'

//    sum(CostItem.ActualAmountInGlobalCurrency)    as ActualAmountInGlobalCurrency,

//    '500,00' as ActualAmountInGlobalCurrency,

//    @Semantics.amount.currencyCode: 'GlobalCurrency'

//    sum(CostItem.PlanAmountInGlobalCurrency)      as PlanAmountInGlobalCurrency,  

//    '0'      as PlanAmountInGlobalCurrency

  
    _AuthUser,
    _AuthSubst,
    _AuthRole,
    _AuthGroup,
    
    _AuthUserFin,
    _AuthSubstFin,
    _AuthRoleFin,
    _AuthGroupFin
}
//where FiscalPeriod._FiscalPeriodStartDate.YearMonth <= CurrentPeriod.YearMonth 

//  and CostItem.GlobalCurrency                       <> ''

//group by

//  Project.ProjectSummaryTaskUUID,  

//  CostItem.GlobalCurrency,

//  Project.ProjectInternalID