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.