Ansicht
Dokumentation

ABENOPENSQL_STRICT_MODE_740_SP08 - OPENSQL STRICT MODE 740 SP08

ABENOPENSQL_STRICT_MODE_740_SP08 - OPENSQL STRICT MODE 740 SP08

Fill RESBD Structure from EBP Component Structure   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

- 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:

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

  • 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 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 specified directly in the SELECT list cannot be specified after GROUP BY if a HAVING clause is specified.





RFUMSV00 - Advance Return for Tax on Sales/Purchases   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 4931 Date: 20240328 Time: 101313     sap01-206 ( 45 ms )