Ansicht
Dokumentation
ABENNEWS-40-ABAP_SQL - NEWS-40-ABAP SQL
TXBHW - Original Tax Base Amount in Local Currency TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
in Release 4.0
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.
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.
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.
PERFORM Short Reference CPI1466 during Backup
This documentation is copyright by SAP AG.
Length: 1498 Date: 20240425 Time: 075143 sap01-206 ( 39 ms )