topic Re: Delete Internal Table in Application Development and Automation Discussions

Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:48:57 GMT

Hi,

I have Internal Table like

Data : Begin of test occurs 0,

vbeln like vbrp-vbeln,

posnr like vbrp-posnr,

bzirk like vbrp-bzirk,

end of test.

If suppose in my internal table with vbeln = 90800100, 10 line items its having.

I want to delete all the entries in the internal table which is having Vbeln = 90800100.

How can i do this what is the exact statement I can use for this.

Thanks & Regards

Venkat

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:50:56 GMT

Hi venkata,

1. simple

2. DELETE TEST WHERE VBELN = '908001000'.

regards,

amit m.

Re: Delete Internal Table

dani_mn — Tue, 25 Jul 2006 11:51:37 GMT

HI,

DELETE test WHERE vbeln = '90800100'.

REgards,

Wasim Ahmed

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:52:00 GMT

To delete more than one line using a condition, use the following statement:

DELETE <itab> WHERE <cond>.

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:52:01 GMT

Hi,

You can do like ths.

DELETE test WHERE vbeln = '90800100'

Regards,

Raghav

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:52:06 GMT

sort itab by vbeln

delete itab where vbeln eq '90800100'.

regards

Prabhu

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:52:31 GMT

delete itab where itab-vbeln = '90800100'.

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:52:49 GMT

Hi Venkata,

Use DELETE statement to delete entries in internal table.

Try as follows::

DELETE TEST WHERE VBELN = '90800100'.

To know more about DELETE statment check the following link:

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/delete_i.htm

Thanks,

Vinay

Message was edited by: Vinaykumar G

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 11:54:59 GMT

Hi Venkata,

Use

V_vbeln = '90800100'.

Delete test where vbeln = v_vbeln.

Hope it would help you.

Cheers,

Prashanth

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 12:02:07 GMT

use the DELETE statement

DELETE test WHERE VBELN = 90800100

Regards

Beena

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 12:22:44 GMT

Hi,

The problem is not very critical. Every one has given you the correct solution .

Just after getting all the records in your "test" internal table just delete the records where the VBELN matches the data. If still the problem is not solved I think you better clarify the problem in detail.

Re: Delete Internal Table

Former Member — Tue, 25 Jul 2006 12:29:44 GMT

Hi,

I don't think the problem is very critical.Every one has given you the correct solution that is first get the data in your internal table and then delete the records where VBELN matches with the data.If still the problem is not solved then I think you better clarify it in detail.

Regs

Somnath