SAP NEWS-775-ABAP SQL

Get Example source ABAP code based on a different SAP table

AB_SQL in ABAP Release 7.75
ITOC

ABAP_MODIFICATION_NN Window Expressions

Window expressions defined using OVER can now be used in the SELECT list of a query. Window expressions define windows as a subset of the result set and apply window functions to them.

ABAP_MODIFICATION_NN New Aggregate Function STRING_AGG

The new aggregate function STRING_AGG can be used to chain character-like results of the rows of the result set of a query or of the current group as a string.

ABAP_MODIFICATION_NN Addition DISTINCT Optional in Aggregate Function COUNT

The aggregate function COUNT( sql_exp ) can now be used without the addition DISTINCT. In this case, it counts all rows in which the value of the argument is not the null value.

ABAP_MODIFICATION_NN Hierarchy Navigators

The new hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE can be used to calculate aggregate functions for descendant nodes.

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_775 strict mode / , which handles the statement more strictly than the regular syntax check.