SAP WHERE LOGEXP EXISTS documentation, setup help and example usage

ARTICLE
Short Reference

sql_cond - EXISTS subquery

Syntax
... [NOT] EXISTS subquery ...

Effect
This expression can be formed with any
subquery . It is true if the result set for the subquery contains (does not contain) at least one row.

Example
Reading all free flights leaving from New York from the SFLIGHT database table to the free_flights internal table.
DATA free_flights TYPE TABLE OF sflight.

SELECT *
FROM sflight AS s
INTO TABLE free_flights
WHERE seatsocc < s~seatsmax AND
EXISTS ( SELECT *
FROM spfli
WHERE carrid = s~carrid AND
connid = s~connid AND
cityfrom = 'NEW YORK' ).