AS ABAP Release 758, ©Copyright 2024 SAP SE. All rights reserved.

ABAP - Keyword Documentation →  ABAP - Programming Language →  ABAP - Short Reference →  S

sql_exp - Short Reference

Reference

Syntax

... { col }
  | { literal | @dobj  | @( expr ) }
  | { operand1 +|-|*|/ operand2 [+|-|*|/ operand3 ... ] }
  | { func( arg1[, arg2]... ) }
  | { cast( operand AS dtype ) }
  | { operand1 && operand2 [&&  operand3 ... ] }
  | { coalesce( arg1, arg2 ) }
  | { CASE ... WHEN ... THEN ... ELSE ... END }
  | { sql_agg }
  | { sql_win } ...

Effect

Expression that is passed to the database system and executed there.

Additions  

• col | literal | @dobj  | @( expr )
  Column or literal, host variable, host expression.
• operand1 +|-|*|/ operand2 [+|-|*|/ operand3 ... ]
  Arithmetic expression
• func( arg1[, arg2]... )
  Numeric function or string function.
• cast( operand AS dtype )
  Type modification.
• operand1 && operand2  [&& operand3 ... ]
  Chaining of character strings.
• COALESCE( arg1, arg2 )
  Replacement of a null value.
• CASE ... WHEN ... THEN ... ELSE ... END
  Case distinction.
• sql_agg
  Aggregate expression.
• sql_win
  Window expression.