SRF_Helper_PH_ENVELOP

@AbapCatalog.sqlViewName: 'SRFPHVATENV'
@EndUserText.label: 'Calculated Values for PH VAT Declaration'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #P
define view SRF_Helper_PH_ENVELOP
  with parameters
    P_TaxBox15aBalance : abap.curr( 23,2),
    P_TaxBox15bBalance : abap.curr( 23,2),
    P_TaxBox16aBalance : abap.curr( 23,2),
    P_TaxBox16bBalance : abap.curr( 23,2),
    P_TaxBox17Balance  : abap.curr( 23,2),
    P_TaxBox18Balance  : abap.curr( 23,2),
    P_TaxBox20aBalance : abap.curr( 23,2),
    P_TaxBox20bBalance : abap.curr( 23,2),
    P_TaxBox20cBalance : abap.curr( 23,2),
    P_TaxBox20dBalance : abap.curr( 23,2),
    P_TaxBox20eBalance : abap.curr( 23,2),
    P_TaxBox21aBalance : abap.curr( 23,2),
    P_TaxBox21bBalance : abap.curr( 23,2),
    P_TaxBox21cBalance : abap.curr( 23,2),
    P_TaxBox21dBalance : abap.curr( 23,2),
    P_TaxBox21eBalance : abap.curr( 23,2),
    P_TaxBox21fBalance : abap.curr( 23,2),
    P_TaxBox21gBalance : abap.curr( 23,2),
    P_TaxBox21hBalance : abap.curr( 23,2),
    P_TaxBox21iBalance : abap.curr( 23,2),
    P_TaxBox21jBalance : abap.curr( 23,2),
    P_TaxBox21kBalance : abap.curr( 23,2),
    P_TaxBox21lBalance : abap.curr( 23,2),
    P_TaxBox21mBalance : abap.curr( 23,2),
    P_TaxBox21nBalance : abap.curr( 23,2),
    P_TaxBox21oBalance : abap.curr( 23,2)

  as select from I_SAPClient //dummy select, CDS view only used for calculations

{
  ($parameters.P_TaxBox15aBalance)  *-1                                   as TaxBox15aBalance,
  ($parameters.P_TaxBox15bBalance)  *-1                                   as TaxBox15bBalance,
  ($parameters.P_TaxBox16aBalance)  *-1                                   as TaxBox16aBalance,
  ($parameters.P_TaxBox16bBalance)  *-1                                   as TaxBox16bBalance,
  ($parameters.P_TaxBox17Balance)   *-1                                   as TaxBox17Balance,
  ($parameters.P_TaxBox18Balance)   *-1                                   as TaxBox18Balance,
  ($parameters.P_TaxBox15aBalance + $parameters.P_TaxBox16aBalance + $parameters.P_TaxBox17Balance + $parameters.P_TaxBox18Balance)* -1
                                                                          as TaxBox19aBalance,
  ($parameters.P_TaxBox15bBalance + $parameters.P_TaxBox16bBalance) *-1   as TaxBox19bBalance,
  //abs($parameters.P_TaxBox20aBalance)                                     as TaxBox20aBalance,

  //abs($parameters.P_TaxBox20bBalance)                                     as TaxBox20bBalance,

  // abs($parameters.P_TaxBox20cBalance)                                     as TaxBox20cBalance,

  // abs($parameters.P_TaxBox20dBalance)                                     as TaxBox20dBalance,

  // abs($parameters.P_TaxBox20eBalance)                                     as TaxBox20eBalance,

  //abs($parameters.P_TaxBox20aBalance + $parameters.P_TaxBox20bBalance + $parameters.P_TaxBox20cBalance + $parameters.P_TaxBox20dBalance + $parameters.P_TaxBox20eBalance)

  //                                     as TaxBox20fBalance,

  ($parameters.P_TaxBox21aBalance)                                        as TaxBox21aBalance,
  ($parameters.P_TaxBox21bBalance)                                        as TaxBox21bBalance,
  //abs($parameters.P_TaxBox21cBalance)                                     as TaxBox21cBalance,

  //abs($parameters.P_TaxBox21dBalance)                                     as TaxBox21dBalance,

  ($parameters.P_TaxBox21eBalance)                                        as TaxBox21eBalance,
  ($parameters.P_TaxBox21fBalance)                                        as TaxBox21fBalance,
  ($parameters.P_TaxBox21gBalance)                                        as TaxBox21gBalance,
  ($parameters.P_TaxBox21hBalance)                                        as TaxBox21hBalance,
  ($parameters.P_TaxBox21iBalance)                                        as TaxBox21iBalance,
  ($parameters.P_TaxBox21jBalance)                                        as TaxBox21jBalance,
  ($parameters.P_TaxBox21kBalance)                                        as TaxBox21kBalance,
  ($parameters.P_TaxBox21lBalance)                                        as TaxBox21lBalance,
  ($parameters.P_TaxBox21mBalance)                                        as TaxBox21mBalance,
  ($parameters.P_TaxBox21nBalance)                                        as TaxBox21nBalance,
  ($parameters.P_TaxBox21oBalance)                                        as TaxBox21oBalance,
  ($parameters.P_TaxBox21aBalance   + $parameters.P_TaxBox21eBalance + $parameters.P_TaxBox21gBalance + $parameters.P_TaxBox21iBalance
  + $parameters.P_TaxBox21kBalance + $parameters.P_TaxBox21mBalance +  $parameters.P_TaxBox21nBalance )
                                                                          as TaxBox21pBalance, //exclude 21c


  ($parameters.P_TaxBox21bBalance  + $parameters.P_TaxBox21fBalance + $parameters.P_TaxBox21hBalance + $parameters.P_TaxBox21jBalance
  + $parameters.P_TaxBox21lBalance + $parameters.P_TaxBox21oBalance  )
  // +  abs($parameters.P_TaxBox20aBalance + $parameters.P_TaxBox20bBalance + $parameters.P_TaxBox20cBalance + $parameters.P_TaxBox20dBalance + $parameters.P_TaxBox20eBalance)

                                                                          as TaxBox22Balance, //exclude 20f and 21d


  ($parameters.P_TaxBox15bBalance + $parameters.P_TaxBox16bBalance ) * -1 -
  //abs($parameters.P_TaxBox20aBalance + $parameters.P_TaxBox20bBalance + $parameters.P_TaxBox20cBalance + $parameters.P_TaxBox20dBalance + $parameters.P_TaxBox20eBalance) -

  ($parameters.P_TaxBox21bBalance  + $parameters.P_TaxBox21fBalance + $parameters.P_TaxBox21hBalance + $parameters.P_TaxBox21jBalance
  + $parameters.P_TaxBox21lBalance + $parameters.P_TaxBox21oBalance  )    as TaxBox25Balance

}