Ansicht
Dokumentation
ABENWHERE_LOGEXP_LIST - WHERE LOGEXP LIST
Vendor Master (General Section) ABAP Short ReferenceThis documentation is copyright by SAP AG.
sql_cond - IN ( ..., ... )
Syntax
... 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.
- 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.
- The following can be specified for operand1, operand2, ...:
- Literals
- Host variables whose name is prefixed with the escape character @.
The content of the operands operand1, operand2, ... Must match the data type of operand in accordance with the rules for lossless assignments. This is also checked by the strict modes of the syntax check from Release 7.40, SP08 and can raise an exception.
Note
No columns and no host expressions can be specified here on the right side.
Example
Reads the bookings in which the class is not in the value range (C - Business, F - First, Y - Economy) of the corresponding domain in ABAP Dictionary.
SELECT *
FROM sbook
WHERE class NOT IN ('C','F','Y')
INTO TABLE @DATA(sbook_tab).
IF sy-subrc = 0.
"Error handling
ENDIF.
rdisp/max_wprun_time - Maximum work process run time ROGBILLS - Synchronize billing plans
This documentation is copyright by SAP AG.
Length: 2716 Date: 20240425 Time: 171630 sap01-206 ( 32 ms )