WHERE - IN

Syntax

... col [NOT] IN (dobj1, dobj2 ... ) ...

Effect

This expression is true if the value of the column col matches (does not match) the contents of the data object in the value list. The value list is specified as a list of elementary objects in parentheses and separated by commas dobj1, dobj2 ....

Example

Reading the bookings in which the class does not lie in the value range (C - Business, F - First, Y - Economy) of the corresponding domain in the ABAP Dictionary.

DATA sbook_tab TYPE TABLE OF sbook.
SELECT *
       FROM sbook
       INTO TABLE sbook_tab
       WHERE class NOT IN ('C','F','Y').
IF sy-subrc = 0.
  "Error handling
ENDIF.