Ansicht
Dokumentation
ABENNEWS-775-ABAP_SQL - NEWS-775-ABAP SQL
BAL_S_LOG - Application Log: Log header data rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
in Release 7.75
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.
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.
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.
Hierarchy Navigators
The new hierarchy
navigator HIERARCHY_DESCENDANTS_AGGREGATE can be used to calculate
aggregate functions for
descendant nodes.
Strict Mode in the Syntax Check
If one the new features listed above is used in an statement, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.
CPI1466 during Backup General Material Data
This documentation is copyright by SAP AG.
Length: 2363 Date: 20240426 Time: 053256 sap01-206 ( 27 ms )