Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to increase performance for BKPF . ?

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

kiran_k8
Active Contributor
0 Kudos

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.

4 REPLIES 4

kiran_k8
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

hi

good

use corresponding fields of statement with you select staement and check the performance .

thanks

mrutyun^

Former Member
0 Kudos

thanks dear all my problem has been solve ,

also point has been given to all those replay

Thanks,

Majed Khan