ABAP Keyword Documentation →  ABAP − Short Reference 

sql_exp - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

... { col | dobj } 
  | { operand1 +|-||/ operand2 [+|-||/ operand3 ... ] } 

  | { func( arg1[, arg2]... ) } 
  | { cast( operand AS dtype ) } 
  | { operand1 && operand2 [&&  operand3 ... ] } 

  | { coalesce( arg1, arg2 ) } 
  | { CASE ... WHEN ... THEN ... ELSE ... END } ... 

Effect

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

Additions

• col | dobj
  Column or host variable.
• operand1 +|-|*|/ operand2 [+|-|*|/ operand3 ... ]
  Arithmetic expression
• func( arg1[, arg2]... )
  Arithmetic function.
• cast( operand AS dtype )
  Type modification.
• operand1 && operand2 [&& operand3 ... ]
  Chaining character strings.
• coalesce( arg1, arg2 )
  Replacing null value.
• CASE ... WHEN ... THEN ... ELSE ... END
  Case distinction.