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.
SAPCODES 