My report is taking much time for execution . Using SE30 tcode....evaluated the program and and found the overview of my program.
In my Overview Database level was high when compared to other 2(ABAP & SYSTEM). Just inside the Hit list found the condition and for one select query Net time was too high. Please find the select query given below.
Select * into table t_bkpf from bkpf where cpudt >= p_date
and cpudt <= p_bdate
and blart in s_blart.
loop at t_bkpf.
In my debugging i found the select query condition takes time to cross the next one...but even values are not fetched in t_bkpf. Please suggest me the solution to overcome this issue.