Skip to Content
0
Former Member
Jul 15, 2008 at 10:38 AM

performance

30 Views

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