SRF_RuHelperSalesLedger

@AbapCatalog.sqlViewName: 'SRFRUHELPSAL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #P
define view SRF_RuHelperSalesLedger
  with parameters
//    P_AmtCCCur  : firu_amount_in_cc_curr,

    P_VATBase20 : firu_taxbaseamount20cccrcy,
    P_VATBase18 : firu_taxbaseamount18cccrcy,
    P_VATBase10 : firu_taxbaseamount10cccrcy,
    P_VATBase0  : firu_taxbaseamount0cccrcy,
    P_VATAmt20  : firu_taxamount20cccrcy,
    P_VATAmt18  : firu_taxamount18cccrcy,
    P_VATAmt10  : firu_taxamount10cccrcy,
    P_NoVAT     : firu_baseamountnotaxcccrcy
  as select from I_SAPClient //dummy select, CDS view only used for calculations

{
  case $parameters.P_VATBase20
    when 0 then ''
           else cast($parameters.P_VATBase20 as abap.char(100))
  end                                                                       as VATBase20Str,

  case $parameters.P_VATBase18
    when 0 then ''
           else cast($parameters.P_VATBase18 as abap.char(100))
  end                                                                       as VATBase18Str,

  case $parameters.P_VATBase10
    when 0 then ''
           else cast($parameters.P_VATBase10 as abap.char(100))
  end                                                                       as VATBase10Str,

  case $parameters.P_VATBase0
    when 0 then ''
           else cast($parameters.P_VATBase0 as abap.char(100))
  end                                                                       as VATBase0Str,

  case $parameters.P_VATAmt20
    when 0 then ''
           else cast($parameters.P_VATAmt20 as abap.char(100))
  end                                                                       as VATAmt20Str,

  case $parameters.P_VATAmt18
    when 0 then ''
           else cast($parameters.P_VATAmt18 as abap.char(100))
  end                                                                       as VATAmt18Str,

  case $parameters.P_VATAmt10
    when 0 then ''
           else cast($parameters.P_VATAmt10 as abap.char(100))
  end                                                                       as VATAmt10Str,

  case $parameters.P_NoVAT
    when 0 then ''
           else cast($parameters.P_NoVAT as abap.char(100))
  end                                                                       as NoVATStr,

  '0'                                                                       as ActionRuleIsGenerated
}