Records in table1 but not in table2
I use the following statement to select all records from table equi that also exist in itab lt_temp:
SELECT mandt equnr
INTO CORRESPONDING FIELDS OF TABLE lt_equi_temp
FOR ALL ENTRIES IN lt_temp
WHERE equnr EQ lt_temp-equnr
AND equnr LIKE 'C%'.
Problem is I want the records in equi that do not exist in itab lt_temp. I tried changing the 'EQ' to 'NE' in the where clause but that query never comes back.
thanks in advance,