Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Records in table1 but not in table2

Hi all,

I use the following statement to select all records from table equi that also exist in itab lt_temp:

SELECT mandt equnr

FROM equi

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,

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question