SAP NetWeaver AS ABAP Release 752, ©Copyright 2017 SAP AG. All rights reserved.
ABAP - Keyword Documentation → ABAP - Reference → Processing External Data → ABAP Database Accesses → Open SQL → Open SQL - Operands and Expressions → Open SQL - Conditions sql_cond → sql_cond - rel_exp for Statements →sql_cond - EXISTS
Syntax
... EXISTS ( SELECT subquery_clauses [ UNION ...] ) ...
Effect
Checks the results set of a subquery. The relational expression is true when the results set of the subquery defined by the clauses subquery_clauses contains at least one row. This expression is possible for all results sets that can be defined using the clauses subquery_clauses. The language element UNION can be used to combine the result sets of multiple subqueries. In this case, special rules query_clauses apply for specifying clauses.
Example
Extracts all available flights leaving from New York from the database table SFLIGHT to the internal table free_flights.
DATA city TYPE spfli-cityfrom VALUE 'NEW YORK'.
SELECT *
FROM sflight AS s
WHERE seatsocc < s~seatsmax AND
EXISTS ( SELECT *
FROM spfli
WHERE carrid = s~carrid AND
connid = s~connid AND
cityfrom = @city )
INTO TABLE @DATA(free_flights).