Srf_RuSumIntSPLedger

@AbapCatalog.sqlViewName: 'SRFRUSUMINTSPL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Add two integer values together'
@ObjectModel.usageType.serviceQuality: #P
define view Srf_RuSumIntSPLedger
  with parameters
    P_Amount1 : abap.char(19), //19 is maximum possible length that allows cast as int8

    P_Amount2 : abap.char(19)
  as select from I_SAPClient //dummy select, CDS view only used for calculations


{
  case $parameters.P_Amount1
    when '' then case $parameters.P_Amount2
                   when '' then 0
                           else cast( cast($parameters.P_Amount2 as abap.numc( 19 ) ) as abap.int8)
                 end
            else case $parameters.P_Amount2
                    when '' then cast( cast($parameters.P_Amount1 as abap.numc( 19 ) ) as abap.int8)
                            else cast( cast($parameters.P_Amount1 as abap.numc( 19 ) ) as abap.int8)
                               + cast( cast($parameters.P_Amount2 as abap.numc( 19 ) ) as abap.int8)
                 end
  end                                                                                                   as SumResult
}