06-07-2007 9:18 AM
Hi Gurus/Expert.
my problem is i m gettind data in It_vbrk correctly now from it_vbrk i m going to fetch record from bkpf but its dispalying data very slow .
performance is very poor.
how to increas its performance . ? please help me in this case.
select bukrs belnr gjahr blart budat xblnr awkey into table it_bkpf from bkpf
for all entries in it_vbrk
where awkey = it_vbrk-awkey
and xblnr = it_vbrk-xblnr.
abouve code is taking more time.
06-07-2007 9:26 AM
Majid,
Try creating an index and use those fields in the where clause while fetching the data.Seems you are working on purchase register sort of report.
K.Kiran.
06-07-2007 9:26 AM
Majid,
Try creating an index and use those fields in the where clause while fetching the data.Seems you are working on purchase register sort of report.
K.Kiran.
06-07-2007 9:27 AM
Hi,
Make sure the selecting fields are in same order of the database table, and the Where condtion values also should be the same order,
Regards
Sudheer
06-07-2007 9:30 AM
hi
good
use corresponding fields of statement with you select staement and check the performance .
thanks
mrutyun^
06-07-2007 11:37 AM
thanks dear all my problem has been solve ,
also point has been given to all those replay
Thanks,
Majed Khan