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