SAP ABAP SQL STRICT MODES



Get Example source ABAP code based on a different SAP table
  


VERSION 5 OUT

AB_SQL - Release-Dependent Syntax Check Modes
In ABAP_RELEASE 7.40, SP02, a new SQL parser for AB_SQL was introduced that is used for both statically specified AB-SQL statements and for dynamic tokens, and which applies some rules more strictly than the previous parser. In ABAP_RELEASE 7.40, SP02, the new parser was used only for the statement SELECT and, from ABAP_RELEASE 7.40, SP05, for all AB-SQL statements. The corresponding syntax revisions can be found under the release-dependent changes for 7.40 SP02 and 7.40 SP05.
Alongside these general revisions, which apply to all AB-SQL statements, ABAP_RELEASE 7.40, SP05 also introduced syntax check modes known as strict modes, which check AB-SQL statements even more strictly if they use features introduced in the corresponding release.
SUBNODES



Latest notes:

The release-dependent strict modes are generally downward compatible, since they are applied only if an feature is used that was not present in previous releases.
The strict modes in later releases contain the rules from all preceding releases. More specifically, all strict modes demand, from ABAP_RELEASE 7.40, SP05, programs in which the program property fixed point arithmetic is activated.
The following reasons apply to release-dependent strict modes of the syntax check:
First, rules such as the use of comma-separated lists or the introduction of host variables with @ are a prerequisite for using new syntax constructs that cannot be parsed otherwise.
On the other hand, developers should be encouraged to always use the desired syntax. For these reasons, an AB-SQL statement that is enhanced with a new feature must adhere to the corresponding strict rule, even if the new feature used would not depend on it.
ABAP_HINT_END