Skip to Content
0
Former Member
Mar 02, 2009 at 05:47 AM

Performance issue

29 Views

Hello,

I have performance problem in my program.

Can anybody suggest me how can i change following query for better performance?

SELECT amblnr amjahr a~bktxt

b~matnr lgort charg erfmg

INTO TABLE i_mseg1

FROM ( mkpf AS a

INNER JOIN mseg AS b ON

amblnr = bmblnr )

WHERE a~mjahr = p_mjahr

AND vgart = 'WA'

AND bktxt NE space

AND lgort = 'SCRP'.

regards,

soni.