Ansicht
Dokumentation

ABENSELECT_UNION_SUM_GTT_ABEXA - SELECT UNION SUM GTT ABEXA

BAL_S_LOG - Application Log: Log header data   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

SELECT, Union with Global Temporary Table

This example demonstrates a union across a table and a global temporary table (GTT).

Source Code

Execute

Description

This example has the same result as the executable example for a union with aggregate expression. Here, however, the SELECT statement is split into two statements for demonstration purposes:

• The aggregation is performed in the subquery of an INSERT statement whose result set is written to a global temporary table (GTT).

• UNION is used to create the union of the result set of a SELECT statement on the table SFLIGHT and a SELECT statement on the GTT.

The GTT must be cleared explicitly before the end of the program to prevent the runtime error COMMIT_GTT_ERROR in the next implicit database commit.

Note

See also the corresponding executable example for common table expressions.

RFUMSV00 - Advance Return for Tax on Sales/Purchases   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 1653 Date: 20240427 Time: 043408     sap01-206 ( 27 ms )