SAP WHERE LOGEXP LIST

Get Example source ABAP code based on a different SAP table

ARTICLE
Short Reference
• IN ( ) WHERE
• NOT IN ( ) WHERE
• , WHERE IN

sql_cond - 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.