Ansicht
Dokumentation

ABENDDIC_GTT_ABEXA - DDIC GTT ABEXA

- Global Temporary Tables, Access

This example demonstrates how global temporary tables in ABAP Dictionary are accessed.

Source Code

Execute

Description

and Native SQL are used to access a global temporary table (GTT) DEMO_GTT:

• After the GTT is filled using the statement INSERT, the table is cleared again depending on user input using the statement DELETE FROM without a WHERE condition. If the DELETE statement is not executed, the statement WAIT UP TO, which performs an implicit database commit, produces the runtime error COMMIT_GTT_ERROR, which can be found in the ABAP dump analysis (ST22).

• After the GTT has been filled using a static native INSERT statement between EXEC SQL - ENDEXEC, the table is not cleared explicitly. Instead, it is cleared in most database platforms using an implicit database commit raised by the statement WAIT UP TO.

Note

Native SQL is used to fill the GTT here for demonstration purposes only. Only should be used to access GTTs.