Ansicht
Dokumentation

ABENSQL_COND_SHORTREF - SQL COND SHORTREF

ABAP Short Reference   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

sql_cond

Reference

Syntax

... { {col1 {=|EQ|<>|NE|>|GT|<|LT|>=|GE|<=|LE}
              { {dobj}
              | {col2}
              | {[ALL|ANY|SOME] subquery} }}
    | {col [NOT] BETWEEN dobj1 AND dobj2}
    | {col [NOT] LIKE dobj [ESCAPE esc]}
    | {col [NOT] IN (dobj1, dobj2 ...)}
    | {col [NOT] IN seltab}
    | {col IS [NOT] NULL}
    | {(cond_syntax)}
    | {[NOT] EXISTS subquery}
    | {col [NOT] IN subquery} } ... .

Effect

Condition for the content of columns after the additions WHERE, ON, or HAVING in statements. The left-hand side can be specified as an SQL expression. Conditions can be put in parentheses explicitly, combined using AND and OR, and negated using NOT.

Additions

• =$|EQ$|<>$|NE$|>$|GT$|<$|LT$|>=$|GE$|=$|LE
  comparison operators: Column content can be compared with host variables, with host expressions, with the content of other columns, and with the result of a subquery subquery.

• ALL$|ANY$|SOME
  Must be specified when the results of the subquery subquery has more than one line.

• $[NOT$] BETWEEN
  Checks whether the content of the left side is in an interval.

• $[NOT$] LIKE operand2 #$[ESCAPE esc$]
  Checks whether the content of the left side matches the pattern in operand2. Here, an escape character esc can be defined with for the wildcard characters "%" and "_" using ESCAPE.

• IS $[NOT$] NULL
  Checks whether the content of the left side has the null value.

• IS $[NOT$] INITIAL
  Checks whether the content of the left side is the initial values of its built-in dictionary type.

• EXISTS subquery
  Checks the result set of the subquery subquery.

• operand $[NOT$] IN (operand1, operand2 ...)
  Checks whether the content of an operand on the left side is in a value list operand1, operand2, ...

• operand $[NOT$] IN subquery
  Checks whether the content of the left side is in the result set of the scalar subquery subquery.

• ( operand1, operand2 ) IN ( ( operand11, operand21 ... ), ... )
  Checks whether the content of a list of operands is in a value list operand1, operand2, ...

• $[NOT$] IN range_tab
  Checks whether the content of the left side meets the conditions of a ranges table range_tab.

• (cond_syntax)
  Condition in cond_syntax specified dynamically.

Vendor Master (General Section)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 5004 Date: 20240424 Time: 174145     sap01-206 ( 43 ms )