Ansicht
Dokumentation

ABENWHERE_LOGEXP_OPERAND_IN - WHERE LOGEXP OPERAND IN

ABENWHERE_LOGEXP_OPERAND_IN - WHERE LOGEXP OPERAND IN

Vendor Master (General Section)   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Short Reference

- operand IN ( ... )

... operand $[NOT$] IN ${ (operand1$[, operand2$[, ...$]$]) $}
                   $| ${ ( SELECT subquery_clauses $[UNION$|INTERSECT$|EXCEPT ...$] ) $} ...


Variants:

1. ... operand $[NOT$] IN (operand1$[, operand2$[, ...$]$])

2. ... operand $[NOT$] IN ( SELECT subquery_clauses [UNION$|INTERSECT$|EXCEPT ...] )

Effect

Checks whether the value of an operand operand matches a value in a set of values specified in parentheses. The set of values can be specified as follows:

  • Using a comma-separated list of individual literals or host variables.

The following applies to operand:

Variant 1

... operand $[NOT$] IN (operand1$[, operand2$[, ...$]$])


Effect

This relational expression is true if the value of the operand operand matches (does not match) the content of one of the operands operand1, operand2 ... in a parenthesized comma-separated value list.

The following applies to operand1, operand2, ...:

  • The content of untyped literals and host variables must match the data type of operand in accordance with the rules for lossless assignments. This is checked by the strict modes of the syntax check from Release and can produce a syntax error or raise an exception.

It is also possible to specify just one operand operand1 in the parentheses. Blanks can be placed after the opening parenthesis, in front of the closing parenthesis, and after the commas. If blank is placed after the opening parenthesis, there must also be a blank in front of the closing parenthesis.

Note

No columns col, no host expressions, and no other SQL expressions can be specified here on the right side. SQL expressions are, however, specified in the variant of IN with an operand list.

Example

Reading of the bookings in which the class is not in the value range (C - Business, F - First, Y - Economy) of the corresponding domain in the ABAP Dictionary.

Variant 2

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


Effect

This relational expression is true if the value of the operand operand is (is not) contained in the result set of a subquery. The clauses in the subquery subquery_clauses must represent a scalar subquery. 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.

Example

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






Addresses (Business Address Services)   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 5630 Date: 20240329 Time: 135337     sap01-206 ( 72 ms )