calculation in final internal table in amdp class

[winona86]

Hi ,

I have a AMDP class where the final itab is a join of several itabs.

I wrote this code initially as normal abap report and since the execution time was much longer I am approaching it as AMDP class.

How can I write this in my amdp select 

[winona86]

@Romanos  Thanks, That helped a lot. However I am unable to apply filter. I have below code in my report

This is my class below , Should I mention FKDAT in my where Clause?

[winona86]

So , basically I am unable to select by fkdat date ranges.