SAP WHERE LOGEXP EXISTS
Get Example source ABAP code based on a different SAP table
ARTICLE
• EXISTS WHERE - subquery
Syntax
Effect
This expression can be formed with any
Example
Reading all free flights leaving from New York from the
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' ).