C_PPM_ProjectBriefCostHeader

@AbapCatalog.sqlViewName: 'CPPMPROBRFCOSHD'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Source of Cost Chart'

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
   representativeKey: 'ProjectUUID',
   alternativeKey: [ { id : 'ProjectSummaryTaskUUID', element: ['ProjectSummaryTaskUUID'], uniqueness: #UNIQUE } ],
   usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #S
   }
}

/** This view delivers just the Global Currency for each project and dummy values that 
    are replaced with the actual values within the DPC_EXT-Implementation **/

define view C_PPM_ProjectBriefCostHeader 
  as select from R_EnterpriseProject      as PPM
    
//    // additional  associatioins 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' 

{
         @UI.hidden: true
  key    PPM.ProjectUUID,
  
         @UI.hidden: true
         PPM.ProjectSummaryTaskUUID,
         @UI.hidden: true
         PPM.WBSElementInternalID,
         @UI.hidden: true
         PPM.Project                                                                      as Project,
         
         @UI.hidden: true
         PPM.ProjectInternalID,

         @Semantics.currencyCode:true
         PPM._ControllingArea.ControllingAreaCurrency                                     as Currency,

         @EndUserText: {
            label:      'Actual Cost',
            quickInfo:  'Actual Cost'
         }
         @Semantics: { amount : {currencyCode: 'Currency'} }
         cast( 0 as abap.curr( 25, 2 ))                                                   as ActualCost, //Dummy, calculated within DPC_EXT

         
         @EndUserText: {
            label:      'Planned Cost',
            quickInfo:  'Planned Cost'
         }
         @Semantics: { amount : {currencyCode: 'Currency'} }
         cast( 0 as abap.curr( 25, 2 ))                                                   as PlannedCost, //Dummy, calculated within DPC_EXT


         @EndUserText: {
            label:      'Actual Cost to Date',
            quickInfo:  'Actual Cost to Date'
         }
         @Semantics: { amount : {currencyCode: 'Currency'} }
         cast( 0 as abap.curr( 25, 2 ))                                                   as ActualCostUpToCurPerd, //Dummy, calculated within DPC_EXT


         @EndUserText: {
            label:      'Planned Cost to Date',
            quickInfo:  'Planned Cost to Date'
         }
         @Semantics: { amount : {currencyCode: 'Currency'} }
         cast( 0 as abap.curr( 25, 2 ))                                                   as PlannedCostUpToCurPerd, //Dummy, calculated within DPC_EXT


         @EndUserText: {
            label:      'Actual Cost Variance to Date',
            quickInfo:  'Actual Cost Variance to Date'
         }
         @Semantics: { amount : {currencyCode: 'Currency'} }
         cast( 0 as abap.curr( 25, 2 ))                                                   as CostDvtnUpToCurrentPeriod, //Dummy, calculated within DPC_EXT

         
         ' '                                                                              as CostDvtnUpToCurPerdCritlty, //Dummy, calculated within DPC_EXT


         @Consumption.hidden: 'true'
         PPM.ControllingArea,

         @Consumption.hidden: 'true'
         PPM.ProfitCenter,

         @Consumption.hidden: 'true'
        PPM._CompanyCode.CompanyCode,
        
         @Consumption.hidden: 'true'
         PPM.ResponsibleCostCenter,
         
         @Consumption.hidden: 'true'
         PPM.FunctionalArea,
         
         @Consumption.hidden: 'true'
         PPM.Plant,
         
         @Consumption.hidden: 'true'
         PPM.EnterpriseProjectType,
         
         @Consumption.hidden: 'true'
         PPM.ProjectProfileCode,
        
         PPM._ControllingArea._Currency
         
}
where
  PPM._ControllingArea.ControllingAreaCurrency  != ''