Hi Friends,
I need to tune the below SELECT statement. Please let me know if join will help. If so, please give the code for the below query.
SELECT matnr werks dismm mmsta sobsl FROM marc INTO TABLE i_marc
FOR ALL ENTRIES IN i_mard
WHERE matnr EQ i_mard-matnr
AND werks EQ i_mard-werks
AND dismm IN s_dismm
AND mmsta IN s_mmsta
AND sobsl IN s_sobsl
AND lvorm NE 'X'.
Thanks,
Dikshitha