Skip to Content
0
Former Member
Jul 28, 2005 at 10:08 PM

performance issue

14 Views

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 mkpfbudat msegmatnr mseg~werks

msegbwart msegmenge mseg~shkzg

INTO TABLE i_src

FROM mkpf

JOIN mseg ON mkpfmblnr = msegmblnr AND

mkpfmjahr = msegmjahr

WHERE mkpf~budat IN s_budat AND

mseg~bwart IN s_bwart AND

mseg~matnr IN s_matnr.

Thanks for the great help,

Sobhan.