performance issue

Hi,

I have the following query taking a lot of time and resulting in aborting the program. So I am thinking to use select for all option for this query. I am wondering if select for all is the right option to use?

SELECT mkpf_{budat mseg}matnr mseg~werks

mseg_{bwart mseg}menge mseg~shkzg

INTO TABLE i_src

FROM mkpf

JOIN mseg ON mkpf_{mblnr = mseg}mblnr AND

mkpf_{mjahr = mseg}mjahr

WHERE mkpf~budat IN s_budat AND

mseg~bwart IN s_bwart AND

mseg~matnr IN s_matnr.

Thanks for the great help,

Sobhan.