@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
define view entity P_PH_TaxReturnCalculation
with parameters
P_TaxBox31aBalance : abap.curr ( 23,2),
P_TaxBox31bBalance : abap.curr ( 23,2),
P_TaxBox32aBalance : abap.curr ( 23,2),
P_TaxBox32bBalance : abap.curr ( 23,2),
P_TaxBox33aBalance : abap.curr ( 23,2),
P_TaxBox34aBalance : abap.curr ( 23,2),
P_TaxBox42aBalance : abap.curr ( 23,2),
P_TaxBox42bBalance : abap.curr ( 23,2),
P_TaxBox43aBalance : abap.curr ( 23,2),
P_TaxBox43bBalance : abap.curr ( 23,2),
P_TaxBox44aBalance : abap.curr ( 23,2),
P_TaxBox44bBalance : abap.curr ( 23,2),
P_TaxBox46aBalance : abap.curr ( 23,2),
P_TaxBox47aBalance : abap.curr ( 23,2),
P_Schedule1e : abap.curr ( 23,2),
P_Schedule1h : abap.curr ( 23,2),
P_Schedule1i: abap.curr ( 23,2)
as select from I_SAPClient //dummy select , CDS view only used for calculations
{
cast ('PHP' as glo_reporting_currency) as ReportingCurrency,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox31aBalance) *-1 as TaxBox31aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox31bBalance) *-1 as TaxBox31bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox32aBalance) *-1 as TaxBox32aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox32bBalance) *-1 as TaxBox32bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox33aBalance) *-1 as TaxBox33aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox34aBalance) *-1 as TaxBox34aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox31aBalance + $parameters .P_TaxBox32aBalance + $parameters .P_TaxBox33aBalance + $parameters .P_TaxBox34aBalance )* -1 as TaxBox35aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox31bBalance + $parameters .P_TaxBox32bBalance )* -1 as TaxBox35bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_Schedule1e) as TaxBox37bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_Schedule1i) as TaxBox50bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox42aBalance) as TaxBox42aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox42bBalance) as TaxBox42bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox43aBalance) as TaxBox43aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox43bBalance) as TaxBox43bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox44aBalance) as TaxBox44aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox44bBalance) as TaxBox44bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox46aBalance) as TaxBox46aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox47aBalance) as TaxBox47aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox42aBalance + $parameters .P_TaxBox43aBalance + $parameters .P_TaxBox44aBalance + $parameters .P_TaxBox46aBalance + $parameters .P_TaxBox47aBalance ) as TaxBox48aBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
($parameters .P_TaxBox42bBalance + $parameters .P_TaxBox43bBalance + $parameters .P_TaxBox44bBalance ) as TaxBox48bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
(($parameters .P_TaxBox42bBalance + $parameters .P_TaxBox43bBalance + $parameters .P_TaxBox44bBalance ) + $parameters .P_Schedule1e ) as TaxBox49bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
(($parameters .P_TaxBox42bBalance + $parameters .P_TaxBox43bBalance + $parameters .P_TaxBox44bBalance ) + $parameters .P_Schedule1h ) as TaxBox55bBalance,
@Semantics.amount.currencyCode : 'ReportingCurrency'
((($parameters .P_TaxBox31bBalance + $parameters .P_TaxBox32bBalance)* -1 - $parameters .P_TaxBox42bBalance - $parameters .P_TaxBox43bBalance - $parameters .P_TaxBox44bBalance ) - $parameters .P_Schedule1h) as TaxBox56bBalance
}
Depth:
1
2
3
4
5
All
Reload
P_PH_TaxReturnCalculation view_entity