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

delete record from internal table

Former Member — Tue, 12 Aug 2008 11:42:02 GMT

hi,

i want to delete record from internal table compring the 2nd field.

for example:

x 5

y 5

then the second record should be deleted . the comparision should be on the basis of 2nd field.

regards

nilabichi

Re: delete record from internal table

Former Member — Tue, 12 Aug 2008 11:44:29 GMT

Hi..

your requirment is not clear please provide more detail

watever i understood from question on that basis u shd.

sort the table and then loop it...

regards

vivek

Re: delete record from internal table

Former Member — Tue, 12 Aug 2008 11:47:17 GMT

hii

delete itab-y where y = 5.

thanks

Re: delete record from internal table

Former Member — Tue, 12 Aug 2008 11:47:44 GMT

Try this out

DELETE itab WHERE 2ndfield = ' value ' .

Regards,

Linda

Re: delete record from internal table

former_member206439 — Tue, 12 Aug 2008 11:47:52 GMT

sort itab.

delete adjacent duplecates comparing (that second filed)

try this one

Re: delete record from internal table

Former Member — Tue, 12 Aug 2008 11:52:31 GMT

Hi,

Use

DELETE ADJACENT DUPLICATES FROM itab comparing field2.

Regrads,

Dhan

Re: delete record from internal table

Subhankar — Tue, 12 Aug 2008 11:54:50 GMT

please see this example..

DATA: i_mara TYPE STANDARD TABLE OF mara INITIAL SIZE 0,

wa_mara TYPE mara.

SELECT *

UP TO 10 ROWS

FROM mara

INto TABLE i_mara.

READ TABLE i_mara INTO wa_mara INDEX 2.

if wa_mara-ERSDA <> 'ABC'.

delete i_mara index 2 .

endif.

LOOP at i_mara INTO wa_mara.

WRITE: / wa_mara-matnr.

ENDLOOP.

Re: delete record from internal table

Former Member — Tue, 12 Aug 2008 12:07:26 GMT



data:
  w_temp1 like itab-f2,
  w_temp2 like itab-f2.

loop at itab.
 w_temp1 = itab-f2.
   if w_temp1 eq w_temp2.
      delete itab.
   endif.
 w_temp2 = w_temp1.
endloop

Regards,

Sunil Kumar M