Sir can you plz explain if clear and refresh both works the same way. Why can't we use refresh in the work area as well. Also why do we have two operations for the same objective?
LINES is already explained which tells the number of rows in the internal table. KIND tells the type of internal table - T signifies standard table, S - Sorted, H - Hashed. OCCURS returns the initial size of the internal table.
Hello - CLEAR , REFRESH - Delete internal table contents, but do not release the memory spaced occupied previously by the internal table. FREE - Delete internal table contents and release completely the memory space also occupied by the internal table.
Hello Ehtasham - UPDATE is not a Internal Table operation, UPDATE is a Database Operation. UPDATE Operation is only applicable to Database tables, In future When I will cover the topic database operations, then I will cover UPDATE. For INSERT, this Internal table operation is applicable to Sorted Internal tale, When I will cover the topic, Types of Internal Table, then I will cover INSERT. The best way from the programming is to use APPEND to insert data to Internal table and MODIFY to update the contents of internal table.
Excellent Rahul Bhai
Thank you.
Sir can you plz explain if clear and refresh both works the same way. Why can't we use refresh in the work area as well. Also why do we have two operations for the same objective?
Reverted in another comment.
Sir, what about the concepts like LINES, OCCURS and KIND used in Describe operation?
LINES is already explained which tells the number of rows in the internal table. KIND tells the type of internal table - T signifies standard table, S - Sorted, H - Hashed. OCCURS returns the initial size of the internal table.
what is the difference between clear, refresh and free??
Hello - CLEAR , REFRESH - Delete internal table contents, but do not release the memory spaced occupied previously by the internal table.
FREE - Delete internal table contents and release completely the memory space also occupied by the internal table.
sir what about INSERT and UPDATE statements?
Hello Ehtasham - UPDATE is not a Internal Table operation, UPDATE is a Database Operation. UPDATE Operation is only applicable to Database tables, In future When I will cover the topic database operations, then I will cover UPDATE. For INSERT, this Internal table operation is applicable to Sorted Internal tale, When I will cover the topic, Types of Internal Table, then I will cover INSERT. The best way from the programming is to use APPEND to insert data to Internal table and MODIFY to update the contents of internal table.