Ansicht
Dokumentation

ABENNEWS-774-ABAP_SQL - NEWS-774-ABAP SQL

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

in Release 7.74

Definition of Associations

When associations of a common table expression are exposed using the addition WITH ASSOCIATIONS, new CTE associations can be defined by specifying JOIN TO ONE$|MANY. These CTE associations can be used in the subsequent queries of the current WITH statement, either in path expressions or as hierarchy associations in the hierarchy generator HIERARCHY.

Definitions of associations require strict mode from Release .

Temporal SQL Hierarchies

The hierarchy generator HIERARCHY can now use the new addition PERIOD FROM TO VALID FROM TO to create temporal SQL hierarchies in which the hierarchy nodes are limited by time intervals.

Aggregate Expressions in SQL Expressions

From Release 7.74, aggregate expressions can be specified as operands of SQL expressions.

PERFORM Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 2264 Date: 20240510 Time: 231412     sap01-206 ( 32 ms )