srf_eco

@AbapCatalog.sqlViewName: 'SRFECO'
@EndUserText.label: 'Mapped Aggregated Values for CBR France'
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel.usageType: { dataClass: #CUSTOMIZING, sizeCategory: #S, serviceQuality: #B }

define view srf_eco
  with parameters 
    P_BOPFormItem: abap.char( 1 ),
    P_Amount: abap.curr( 23,2 )      

  as
  select from I_SAPClient //dummy select

  
{ 
    case :P_BOPFormItem 
      when 'A' then 'MONNAIE_A'
      when 'B' then 'MONNAIE_B'
      when 'C' then 'MONNAIE_C'
      when 'D' then 'MONNAIE_D'
      else ''
      end as P_Monnaie,
      
    case :P_BOPFormItem 
      when 'A' then 'PAYS_A' 
      when 'B' then 'PAYS_B'
      when 'C' then 'PAYS_C'
      when 'D' then 'PAYS_D'
      else ''
      end as P_Pays,
     
    case :P_BOPFormItem     
      when 'A' then 'CREA_AFF'
      when 'B' then 'DET_AFF'
      when 'C' then 'AVAC_V_AFF'
      when 'D' then 'AVAC_R_AFF'         
  else ''            
  end as P_Aff,
  
    case :P_BOPFormItem     
      when 'A' then 'CREA_NON_AFF'
      when 'B' then 'DET_NON_AFF'
      when 'C' then 'AVAC_V_NON_AFF'
      when 'D' then 'AVAC_R_NON_AFF'         
  else ''            
  end as P_NonAff,
  
   cast(floor(abs($parameters.P_Amount)) as abap.dec( 23, 0)) as P_RoundDownAmount                     
      
}