hi all,
i'm working on payment report..
following query is taking lot of time...
LOOP AT it_rseg .
CLEAR it_temp.
CONCATENATE it_rseg-belnr it_rseg-gjahr INTO it_temp-temp.
APPEND it_temp.
SELECT belnr gjahr awkey
FROM bkpf
APPENDING TABLE it_bkpf
WHERE awkey EQ it_temp-temp.
ENDLOOP.
if i use select statement outside the loop,
even its takes more time...
please help me in reducing the time of execution..
regards
Suprith