Skip to Content
0
Former Member
Feb 25, 2009 at 07:17 PM

Help on performance tuning

23 Views

Please help to take a look those two select statements. Any suggestion will be appreciated.

First one:

SELECT mara~matnr mara~mtart
mara~meins mvke~prat2
INTO TABLE t_matnr
FROM mara
LEFT OUTER JOIN mvke
ON mara~matnr = mvke~matnr
AND mvke~vkorg = v_vkorg
INNER JOIN marc
ON mara~matnr = marc~matnr
WHERE mara~matnr IN s_matnr
AND marc~werks IN p_werks
AND mara~matkl IN s_matkl.

Second one:

IF t_matnr_mard IS NOT INITIAL.
SELECT werks matnr lgort
labst umlme insme
einme speme retme 
FROM mard
INTO TABLE t_mard
FOR ALL ENTRIES IN t_matnr_mard
WHERE matnr = t_matnr_mard-matnr
AND werks IN p_werks 
AND lvorm NE 'X'
AND ( labst > 0 OR umlme > 0 OR 
insme > 0 OR einme > 0 OR 
speme > 0 OR retme > 0 ).

thanks!

EY

Edited by: Rob Burbank on Feb 25, 2009 2:51 PM

Aded code tags