topic Re: Deleting from Dynamic Internal table in Application Development and Automation Discussions

Deleting from Dynamic Internal table

former_member212005 — Thu, 02 Jul 2009 13:56:32 GMT

Hi,

How can we delete data from dynamic internal table...

I have a dynamic internal table <fs_dyn_table> which is of type any and can have any fields...

I want to delete all those records which have a value of '10' in a field named field1

I have written my delete statement in the following manner..

DELETE <fs_dyn_table> WHERE field1 = '10'.....but it is not working...it gives me an error...stating that the line type of table must be statically defined.

Re: Deleting from Dynamic Internal table

Former Member — Thu, 02 Jul 2009 14:01:44 GMT

Hi,

Loop on the internal table into a field-symbol of line type same as the internal table.

Use assign component statement and then delete the corresponding record.

Regards,

Ankur Parab

Re: Deleting from Dynamic Internal table

former_member212005 — Thu, 02 Jul 2009 14:02:51 GMT

Ankur...thanks for the reply...

What you have suggested is DELETE statement inside LOOP...which is not feasible as there might be more than lacs of record...

Re: Deleting from Dynamic Internal table

former_member212005 — Thu, 02 Jul 2009 14:11:22 GMT

Hi Ankur....any other suggestion

Re: Deleting from Dynamic Internal table

Former Member — Thu, 02 Jul 2009 14:21:55 GMT

Hi,

Check the Rich Heilman answer in the thread..

Re: Deleting from Dynamic Internal table

former_member212005 — Fri, 03 Jul 2009 05:40:06 GMT

Thanks Avinash...the answer given by Rich Heilman is same as Ankur's...

It gives me a feeling that this is the only way...we cannot avoid the delete statement inside the LOOP.

Re: Deleting from Dynamic Internal table

Former Member — Tue, 08 Sep 2009 19:16:50 GMT

Hi,

Try this

data : key(4) value 'field1'.

DELETE <fs_dyn_table> WHERE (key) = '10'

Regards

Ramakrishna L