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®ards
shishir
Edited by: Julius Bussche on Feb 26, 2009 12:27 PM
Please use meaningfull subject titles and code tags