Skip to Content
0
Former Member
Jun 09, 2009 at 11:23 AM

Join for MARC & MARD

805 Views

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