Get Example source ABAP code based on a different SAP table
AB_SQL in ABAP Release 4.0 ITOC
ABAP_MODIFICATION_NN INNER JOIN and LEFT OUTER JOIN
It is now possible to read records from multiple logically associated database tables using a single SELECT statement. This can be done using the new constructs INNER JOIN and LEFT OUTER JOIN in the FROM clause. In the past this was normally done using a nested SELECT loop. Replacing these loops with joins produces greatly improved runtime performance.
ABAP_MODIFICATION_NN Subqueries
Subqueries are now possible in the WHERE conditions of SELECT, UPDATE, and DELETE statements. Tasks that previously required multiple SQL statements can now be solved more efficiently. A description of these subqueries is available in the documentation of the relational expressions.
ABAP_MODIFICATION_NN HAVING Clause
The new HAVING clause makes it possible to define further conditions for a set of results of a SELECT statement created using aggregation and grouping.
