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