Ansicht
Dokumentation
ABENWHERE_LOGEXP_EXISTS - WHERE LOGEXP EXISTS
BAL_S_LOG - Application Log: Log header data ABAP Short ReferenceThis documentation is copyright by SAP AG.
- EXISTS
... EXISTS ( SELECT subquery_clauses $[UNION$|INTERSECT$|EXCEPT ...$] ) ...
Effect
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 language elements UNION, INTERSECT, and EXCEPT can be used to combine the result sets of multiple subqueries. In this case, special rules query_clauses apply to specifying clauses.
Note
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.
Example
Reading of all available flights leaving from New York from the DDIC database table SFLIGHT to the internal table free_flights.
General Data in Customer Master Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 1954 Date: 20240425 Time: 191029 sap01-206 ( 33 ms )