Ansicht
Dokumentation

ABENABAP_SQL_STRICTMODE_740_SP08 - ABAP SQL STRICTMODE 740 SP08

CL_GUI_FRONTEND_SERVICES - Frontend Services   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

- Strict Mode in Release 7.40, SP08

Conditions for the Strict Mode

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

• Columns dbtab~* specified in the SELECT list.

• Inline declarations using @DATA(...) for the target area of SELECT.

• SQL expressions:

• Minus sign (-) in front of an operand of an arithmetic expression

• SQL expression as an operand of a simple case distinction

• Use of a complex case distinction

• SQL expression after SELECT together with aggregate expressions or the addition GROUP BY

• SQL expression after the addition GROUP BY of the statement SELECT

• SQL expression as an argument of aggregate expressions in the SELECT list or in the HAVING clause

• Joins:

• Use of the additions LIKE, IN, and NOT and the operators OR or NOT in an ON condition.

• Outer join without a comparison between columns on the left and right sides.

• Subquery specified in a dynamic WHERE condition.

• 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 an untyped literal, a host variable, or a host expression that is 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 DDIC database table, this name must also be used in dynamic tokens.

• Comparisons between non-comparable types produce a syntax error or raise an exception.

• If a column specified in the HAVING clause outside of an aggregate expression is not specified after GROUP BY, a syntax error occurs.

• Columns listed directly in the SELECT list cannot be specified after GROUP BY if a HAVING clause is specified.

Fill RESBD Structure from EBP Component Structure   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 4935 Date: 20240419 Time: 043048     sap01-206 ( 42 ms )