topic Re: How to delete the data inside a internal table? in Application Development and Automation Discussions

How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:31:59 GMT

I got a internal table name g_itab1.

currently my g_itab1 has a FNAME(50) component.

Inside my component there is ADMINO, EYEAR, FIRSTNAME, LASTNAME and CONTACT.

I want to clear away ADMINO, EYEAR, FIRSTNAME, LASTNAME and CONTACT inside my internal table.

How do i clear it? i have tried using CLEAR g_itab1.

It doesn't work.. the data are still inside.

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:33:26 GMT

Hi,

Use Refresh Statement.

Refresh will clear the contents of both the header line and the body of the internal table. Free will clear both and release the memory allocated as well.

Syntax :

REFRESH itab.

Thanks.

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:33:44 GMT

hi,

try to use delete statement

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:33:49 GMT

Use refresh g_itab1[]

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:34:34 GMT

clear:g_itab1 ,g_itab1[]

Re: How to delete the data inside a internal table?

varma_narayana — Thu, 11 Oct 2007 08:35:31 GMT

You can use :

REFRESH g_itab1.

CLEAR g_itab1[] . "Delete the records from the BODY

Both statements will delete the Entire records from itab.

REWARD IF hELPFUL.

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:35:58 GMT

if you want remove total then go for refresh itab.

if you want to go for some fields then use DELETE itab where

Reward if usefull

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:36:03 GMT

use this.

CLEAR g_itab1[]. " FOR BODY CLEAR

REFRESH g_itab1. " FOR HEADER CLEAR

Message was edited by:

Amit Singla

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 08:38:14 GMT

DELETE TABLE itab WITH TABLE KEY k1 = v1 ... kn = vn.

Example to delete all of the lines between 5 and 36 in a table of names where the entry begins with one of the letters 'A' to 'C'.

DELETE itab FROM 5 TO 36 WHERE NAME CA 'ABC'.

reward if useful

regards

sree

Re: How to delete the data inside a internal table?

Former Member — Thu, 11 Oct 2007 09:53:15 GMT

Thanks everyone!!!!

I've solved my problem!!! 😃