SAP NEWS-777-ABAP SQL
Get Example source ABAP code based on a different SAP table
AB_SQL in ABAP Release 7.77 ITOC
ABAP_MODIFICATION_NN Client Handling The new additions
USING $[ALL$] CLIENTS $[IN$] in queries
USING $[ALL$] CLIENTS $[IN$] in write statements
make it possible to switch implicit client handling from the current default client to multiple clients.
This makes the addition CLIENT SPECIFIED obsolete in queries and obsolete in the write statements UPDATE SET and DELETE FROM.
ABAP_MODIFICATION_NN Extensions of the INTO Clause
The INTO clause has been extended as follows:
The new addition NEW can be used to implicitly create anonymous data objects as target areas. The addition NEW now also makes inline declarations using @DATA(...) possible when using dynamic tokens and after the statement FETCH.
The new addition INDICATORS can be used to specify a null indicator.
ABAP_MODIFICATION_NN Extension of the CAST Matrix
The matrix of types that can be converted to each other using a CAST expression was revised. In particular, the new data types in ABAP Dictionary are respected. The new types DECFLOAT16 and DECFLOAT34 can also be specified after the addition AS of the aggregate function AVG.
ABAP_MODIFICATION_NN New Built-In Functions
AB_SQL Now supports the following new built-in functions:
UUID
ABAP_MODIFICATION_NN New Window Functions
AB_SQL now supports the following new window functions in window expressions:
LEAD and LAG.
ABAP_MODIFICATION_NN SQL Conditions
The SQL conditions were revised as follows:
Unlike in all other relational expressions in AB_SQL , the relational expression IS $[NOT$] NULL can now be used to check LOBs and geodata types.
A new variant of the operator IN can be used to compare multiple operands with a list of value tuples.
ABAP_MODIFICATION_NN Hierarchy Navigators
The hierarchy aggregate navigators were revised as follows:
New WITH additions in the hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE make it possible to evaluate the aggregate functions specified using MEASURES for further row sets in the hierarchy.
The new hierarchy navigator HIERARCHY_ANCESTORS_AGGREGATE makes it possible to calculate aggregate functions for ancestor nodes and also supports the new aggregate function PRODUCT.
ABAP_MODIFICATION_NN Strict Mode in the Syntax Check
If one the new features listed above is used in an AB-SQL statement, the syntax check is performed in a ABAP_STRICT_777 strict mode / , which handles the statement more strictly than the regular syntax check.
ABAP_MODIFICATION_NN Syntax Check for Literals and Host Constants
The fact that conversions of host variables in read positions need to be lossless is checked for untyped literals and host constants in the strict syntax check modes from ABAP_STRICT_762 ABAP_RELEASE ABAP_762 / and ABAP_STRICT_763 ABAP_RELEASE ABAP_763 / and hence can produce syntax errors. From ABAP_RELEASE 7.77, a syntax check warning is produced when this rule is broken outside of the strict mode too.
