Clear Internal Table in HANA SQL Script
In ABAP method generally in many instances, it is required to clear / refresh the internal table with CLEAR/ REFRESH statement but in HANA SQL SCRIPT these statements don;t work and the below post shows how to make clear an internal table.
Suppose an internal table have some records and you want to clear this internal table as a part of the processing.
A simple SELECT statement with NULL entry for each column from dummy makes the internal table clear.
Below is an AMDP Method-
The program that calls the method.
Debug Details- Internal table is filled with some records and let’s make it clear by executing the next SELECT statement with NULL value for each column.
Now the Internal table is cleared.