Sum of amounts based on period range in ACDOCT(HSL01 to HSL012)

48 Views Last edit Apr 24 at 11:22 PM 2 rev

I have a requirement where I have to add the amounts based on period range selected through Parameters in CDS view.
For examples in the the screen selection user selects Fiscal year , Fiscal Period_From and Period_To as

year ;DIGITS

period_from: 001

period_to : 009

then logic required is to sum the amounts HSL01 - till HSL09.

if user selects different range like period_from = 004 and period_to= 007 then sum (HSL04 till HSL09). This has to be added dynamically in the CDS view based on user selects.
I am building a Analytical report and want to achieve this with CDS view.
Please suggest and let me know if you need any other information.
I have checked in SAP blogs but there is no answer by achieving this with CDS view with parameters.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.