Hi experts,
m sending u a part of code that i have created but it is taking a lot of time that makes the executin very slow..Can u plz tell me some other alternatives that can improve its performance..
select * into corresponding fields of table customer from kna1 * AS A INNER JOIN KNVP AS B ON A~KUNNR = B~KUNN2 where regio in regio. * AND PARVW = 'ZA'. clear del. del = sy-subrc . sort customer by kunnr. delete adjacent duplicates from customer. * IF DEL = 0. select a~bukrs a~gjahr a~belnr a~budat a~gjahr a~blart b~kunnr b~buzei b~shkzg b~sgtxt b~bldat b~zuonr b~dmbtr b~pswsl b~zterm b~vbeln into corresponding fields of table itab_bsid from bkpf as a inner join bsid as b on a~belnr = b~belnr and a~gjahr eq b~gjahr and a~mandt = b~mandt and a~bukrs = b~bukrs for all entries in customer where a~budat le p_date and a~bukrs eq p_bukrs and ( b~umskz eq space or b~umskz eq 'A') and b~kunnr eq customer-kunnr. select a~bukrs a~gjahr a~belnr a~budat a~gjahr a~blart b~kunnr b~buzei b~shkzg b~sgtxt b~bldat b~zuonr b~dmbtr b~pswsl b~zterm b~vbeln into corresponding fields of table itab_bsad from bkpf as a inner join bsad as b on a~belnr = b~belnr and a~gjahr eq b~gjahr and a~mandt = b~mandt and a~bukrs = b~bukrs for all entries in customer where a~budat le p_date and a~bukrs eq p_bukrs and ( b~umskz eq space or b~umskz eq 'A') and b~kunnr eq customer-kunnr.
thanks,
Raman
Added code tags and moved to the correct forum
Edited by: Rob Burbank on Mar 9, 2009 9:23 AM