Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  Open SQL →  Open SQL - Overview →  Open SQL - Release-Dependent Syntax Check Modes 

Strict Mode in Release 7.40, SP08

Other versions: 7.31 | 7.40 | 7.54

Conditions for the Strict Mode

The strict mode of the syntax check in Release 7.40, SP08 applies to all Open SQL statements that use one of the following attributes introduced in Release 7.40 SP08:

  • SQL expression after the addition GROUP BY of the statement SELECT
  • SQL expression as an argument of aggregate functions in the SELECT list or in the HAVING clause
  • Use of the additions LIKE, IN, and NOT plus the operators OR or NOT in an ON condition.
  • Outer join without a comparison between columns on the left and right sides.
  • Arrangement of the INTO clause as the final clause of a SELECT statement.

Rules for the Strict Mode

The strict mode in Release 7.40, SP08 covers all rules of the strict mode in Release 7.40, SP05, plus the following rules:

  • If the content of a host variable read in an operand position needs to be converted to the target type, this is done using the rules for lossless assignments. If the assignment cannot be lossless, an exception is raised.
  • If AS tabalias is used to define an alias name for a database table, this name must also be used in dynamic tokens.
  • If a column specified in the HAVING clause outside of an aggregate expression is not specified after GROUP BY, a syntax error occurs.
  • Columns specified directly in the SELECT list are not specified after GROUP BY if a HAVING clause is specified.