topic Re: delete data from itab in Application Development and Automation Discussions

delete data from itab

Former Member — Tue, 16 May 2006 13:38:56 GMT

i have itab , and i want to delete the first column how i do it?

Re: delete data from itab

RichHeilman — Tue, 16 May 2006 13:39:28 GMT

You can not delete the column, but you can delete the data in the column.

Loop at itab.
clear itab-field1.
modify itab.
endloop.

Regards,

Rich Heilman

Re: delete data from itab

suresh_datti — Tue, 16 May 2006 13:39:33 GMT

Column? if it is row

delete itab index 1.

Regards,

Suresh Datti

Re: delete data from itab

rahulkavuri — Tue, 16 May 2006 13:41:43 GMT

Loop at int_table.

clear itab-VBELN.
modify int_table.

endloop.

Re: delete data from itab

Former Member — Tue, 16 May 2006 13:45:02 GMT

If you want to clear the contents, then it can be done.

loop at itab.

clear itab-field1.

modify itab.

endloop.

but it is not possible to delete it.

What you can do is move all the contents of itab to itab2 which has all the fields exept the first colum.

loop at itab.

move-corresponding itab to itab2.

append itab2.

endloop.

delete table itab.

Regards,

Ravi

Re: delete data from itab

Former Member — Tue, 16 May 2006 13:48:59 GMT

rich

i learn that modify is not good for performance?????

Re: delete data from itab

Former Member — Tue, 16 May 2006 13:53:33 GMT

2 problems?

1.i work with WA.

2.it delete the mandt but i have 3 space at the beging

Re: delete data from itab

RichHeilman — Tue, 16 May 2006 13:56:17 GMT

How else do you intend on modifing the records?

Regards,

Rich Heilman

Re: delete data from itab

RichHeilman — Tue, 16 May 2006 13:57:49 GMT

You can delete the data, but the column will still be there, showing the space. If you don't want that column in your internal table, then remove it from the internal table structure.

You mentioned that you are using WA. Here is some sample.

Loop at itab into wa.
  clear wa-field1.
   modify itab from wa.
endloop.

Regards,

Rich Heilman

Re: delete data from itab

former_member184495 — Tue, 16 May 2006 17:09:28 GMT

hi,

as our friend Suresh said,

if its the first record that you want to delete...

*----

delete itab index 1.

loop at itab.

endloop.

*----

cheers,

Aditya.