Skip to Content
0
Former Member
Mar 09, 2009 at 06:17 AM

fast execution

16 Views

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