delete records from internal table

[Former Member]

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

[Former Member]

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

[Former Member]

hi,

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

btw..this applies to char type field.

regards,

madhu

[Former Member]

hi,

do this way ...

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

Regards,

Santosh

[pole_li]

Hi,

Try this:

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

Regards

Pole

[sivasatyaprasad_yerra]

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

.

Regards,

Siva.

[Former Member]

Loop at Itab

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

Delete ITAB index sy-tabix.

Endif.

Endif.

It should work.

Regards,

Swarup

[Former Member]

Raju,

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

Amit.

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks a lot..