performance promblem with FOR ALL ENTRIES

hello frnds...

this code is taking too much time, is thr any way to optimize this code....

SELECT  bukrs
          belnr
          gjahr
          bldat
          blart
          INTO TABLE t_bkpf
          FROM bkpf
          FOR ALL ENTRIES IN t_sum
          WHERE gjahr = t_sum-mjahr
          AND bukrs = t_sum-bukrs
          AND blart IN ('PR','KP','RE','SA')
          AND ( budat >= s_budat-low AND budat <= s_budat-high ).

  SELECT
         bukrs
         belnr
         gjahr
         buzei
         shkzg
         dmbtr
         vorgn
         matnr
         werks
         menge
         INTO TABLE t_voucher
         FROM bseg
         FOR ALL ENTRIES IN t_bkpf
         WHERE bukrs = t_bkpf-bukrs
         AND belnr = t_bkpf-belnr
         AND gjahr = t_bkpf-gjahr
         AND  hkont IN s_hkont
         AND matnr IN s_matnr
         AND werks IN  s_werks
         AND ( hkont  >= s_hkont-low AND hkont  <= s_hkont-high ).

thanks&regards

shishir

Edited by: Julius Bussche on Feb 26, 2009 12:27 PM

Please use meaningfull subject titles and code tags