SAP NEWS-774-ABAP SQL



Get Example source ABAP code based on a different SAP table
  



AB_SQL in ABAP Release 7.74
ITOC

ABAP_MODIFICATION_NN 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 ABAP_STRICT_774 strict mode from ABAP_RELEASE ABAP_774 / .

ABAP_MODIFICATION_NN 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.

ABAP_MODIFICATION_NN Aggregate Expressions in SQL Expressions

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