ABAP Keyword Documentation →  ABAP - Quick Reference 

sql_exp - Quick reference

Reference

Other versions: 7.31 | 7.40 | 7.54

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.