Ansicht
Dokumentation

ABENWHERE_LOGEXP_IN_SUBQUERY - WHERE LOGEXP IN SUBQUERY

RFUMSV00 - Advance Return for Tax on Sales/Purchases   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Short Reference

sql_cond - IN subquery

Syntax

... operand $[NOT$] IN ( SELECT subquery_clauses $[UNION ...$] ) ...

Effect

Search for an operand operand in the result set of a subquery. The clauses in the subquery subquery_clauses must constitute a scalar subquery. 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.

The relational expression is true if the value of the operand operand is (is not) contained in the results set of the scalar subquery. Columns and SQL expressions can be specified for operand. This covers literals, host variables, and host expressions. In a HAVING clause, aggregate expressions can also be used.

Example

Reads the geographical latitude and longitude of a city from the database table SGEOCITY, where this city is the city of origin of a flight in the database table SPFLI.

DATA: carr_id TYPE spfli-carrid VALUE 'LH',
      conn_id TYPE spfli-connid VALUE '400'.


SELECT SINGLE city, latitude, longitude
       FROM sgeocity
       WHERE city IN ( SELECT cityfrom
                              FROM spfli
                              WHERE carrid = @carr_id AND
                                    connid = @conn_id )
       INTO (@DATA(city), @DATA(lati), @DATA(longi)).

Addresses (Business Address Services)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 3176 Date: 20240419 Time: 091723     sap01-206 ( 29 ms )