SAP WHERE LOGEXP EXISTS



Get Example source ABAP code based on a different SAP table
  


Short Reference
• EXISTS ( SELECT ... ) ABAP_OSQL_COND

ABAP_SQLCOND - EXISTS

ABAP_SYNTAX
... EXISTS ( SELECT subquery_clauses $[UNION$|INTERSECT$|EXCEPT ...$] ) ...

What does it do?
Checks the result set of a subquery. The relational expression is true if the result set of the subquery defined by the clauses subquery_clauses contains at least one row. The expression is possible for any result sets that can be defined using subquery clauses subquery_clauses. The set operators UNION , INTERSECT, and EXCEPT can be used to combine the result sets of multiple subqueries. In this case, special rules query_clauses apply when specifying clauses.



Latest notes:

The specified columns in the SELECT list of the subquery are not important for EXISTS. Therefore, explicit lists are not useful. It is recommended that one literal is specified as the only column.
NON_V5_HINTS
ABAP_HINT_END

ABAP_EXAMPLE_VX5
Reads all available flights leaving from New York from the DDIC database table SFLIGHT to the internal table free_flights.
ABEXA 01398
ABAP_EXAMPLE_END