sapdev logo background
sapdev logo sapdev logo
Comments

SAP WHERE LOGEXP LIST documentation, setup help and example usage



Return to SAP documentation index


ARTICLE
Short Reference

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.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved




WHERE_LOGEXP_LIKE
WHERE_LOGEXP_NULL




comments powered by Disqus