Skip to Content
0
Former Member
Mar 02, 2009 at 04:34 PM

Select Stmt problem

27 Views

hi all,

i am using following code to get FI accounting doc and year. but it is taking around 5 min to execute this select stmt can any one suggest me to improve the performance.

if not i_rseg[] is initial.

select belnr

gjahr

budat

awkey

from bkpf

into table i_bkpf

for all entries in i_rseg

where bukrs = i_rseg-bukrs

and awkey = i_rseg-awkey.

endif.

there are around 15000 entries exist in the table which are related to select query.

thanking you ,

srujan.p