topic Re: Delete single record from internale table in Application Development and Automation Discussions

Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:44:31 GMT

How to delete single record in an internal table.

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:45:14 GMT

delete itab where your_condition_here.

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:45:32 GMT

Hi,

Delete ITAB index 1.

Loop at ITAB.

delete itab.

exit.

endloop.

Darren

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:47:01 GMT

Hi,

When you say you want to delete a single record from an internal table, on what basis are you deleting it ?

If you have a specific condition in mind you can write the following code.

Read table t_test with key (cond).

(Assuming t_test has a header line).

Delete t_test index sy-index.

Regards,

Pramod

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:48:08 GMT

delete itab where <your condititon>

(or)

delete itab from wa--> work area.

(or)

delete itab index 3.

delete ita index 4.

For more examples place cursor on keyword DELETE ITAB and press F1 key

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:53:41 GMT

Hi,

there are several ways of doing this:

1.delete itab where <condition>

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 10:56:40 GMT

hi Lavanya,,

If in your Internal table having 10 records ,

if you want to delete 5th record :

Delete itab where f1 = '5'.

Click F1 on delete in you program .. and you will get many options. dude

Thanks : Maddy

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 11:31:42 GMT

HI,

deleteion can be done on the basis of some condition:

loop at itab.

delete itab where field = ' '.

endloop.

this will work..

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 11:40:03 GMT

LOOP AT ist_bkpf INTO wa_bkpf.

READ TABLE ist_payr INTO wa_payr WITH KEY vblnr = wa_bkpf-belnr gjahr = wa_bkpf-gjahr.

IF sy-subrc = 0.

DELETE ist_bkpf.

ENDIF.

ENDLOOP.

hope this will help u

Re: Delete single record from internale table

Former Member — Fri, 10 Oct 2008 11:50:30 GMT

Hi,

One best thing we can do while writing code we an have F1 help when we write the code.

plz check the below examples to delete entry from internal table :

DELETE TABLE itab WITH TABLE KEY matnr = p_matnr.

DELETE TABLE itab FROM wa_mara.

READ TABLE itab WITH TABLE KEY matnr = p_matnr 
                     TRANSPORTING NO FIELDS. 

IF sy-subrc = 0. 
  DELETE itab INDEX sy-tabix. 
ENDIF.

thanx.