topic Re: delete records from internal table in Application Development and Automation Discussions

delete records from internal table

Former Member — Fri, 27 Jun 2008 09:31:35 GMT

hi all,

i want to delete records from intenal table which are starting with a particular starting number .

eg internal table

10000

20000

90000

91000

92000

88880

i want delete the records starting with 9 i.e. 90000 91000 92000.

Thanks in Adv

RAJ

Re: delete records from internal table

Former Member — Fri, 27 Jun 2008 09:32:39 GMT

hi,

delete itab where field+0(1) = 9.

btw..this applies to char type field.

regards,

madhu

Re: delete records from internal table

Former Member — Fri, 27 Jun 2008 09:34:10 GMT

hi,

do this way ...


delete itab where <field> cp '9%'.

Regards,

Santosh

Re: delete records from internal table

pole_li — Fri, 27 Jun 2008 09:35:00 GMT

Hi,

Try this:

delete it_tab where zfield(1) = '9'.

Regards

Pole

Re: delete records from internal table

sivasatyaprasad_yerra — Fri, 27 Jun 2008 09:35:29 GMT

 delete <internal table> where <column name> cp '9*'.

Regards,

Siva.

Re: delete records from internal table

Former Member — Fri, 27 Jun 2008 09:35:39 GMT

Loop at Itab

IF Itab-fld+0(1) EQ '9'.

Delete ITAB index sy-tabix.

Endif.

It should work.

Regards,

Swarup

Re: delete records from internal table

Former Member — Fri, 27 Jun 2008 09:37:06 GMT

Raju,

loop at itab.
if <field> cp '9%'.
delete itab index sy-tabix.
endif.
endloop

Amit.

Re: delete records from internal table

Former Member — Fri, 27 Jun 2008 10:59:21 GMT

You can test this piece of code.

DATA:

i_tab TYPE STANDARD TABLE OF mara,

wa_tab TYPE mara.

wa_tab-matnr = '1000'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '1001'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '1002'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '1003'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '2001'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '3001'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '4010'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

\[removed by moderator\]

Edited by: Jan Stallkamp on Aug 8, 2008 4:40 PM

Re: delete records from internal table

Former Member — Fri, 27 Jun 2008 10:59:57 GMT

You can test this piece of code.

DATA:

i_tab TYPE STANDARD TABLE OF mara,

wa_tab TYPE mara.

wa_tab-matnr = '1000'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '1001'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '1002'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '1003'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '2001'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '3001'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

wa_tab-matnr = '4010'.

APPEND wa_tab TO i_tab.

CLEAR wa_tab.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Aug 8, 2008 4:49 PM

Re: delete records from internal table

Former Member — Mon, 30 Jun 2008 08:26:17 GMT

Thanks a lot..