HANA SQL- Internal Table Operation- 7

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



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s