topic Re: deleting internal table records with pattern in Application Development and Automation Discussions

deleting internal table records with pattern

Former Member — Fri, 24 Jul 2009 06:20:53 GMT

Hi experts

I need to delete the internal table records where vbeln like '40%'.

all the vbeln atarting with the number 40 i need to delete. if i use the like in where clause i am getting error.

Please suggest some solution on this

thanks in advance

sai

Re: deleting internal table records with pattern

former_member156446 — Fri, 24 Jul 2009 06:22:34 GMT

build a range table and use

data: ra_vbeln type standard table of selopt,
         wa_vbeln type selopt.

wa_vbeln-sign = 'I'.
wa_vbeln-option = 'EQ'.
wa_vbeln-low = '40*'
append wa_vbeln to ra_vbeln.

delete tabe itab where vbeln in ra_vbeln.

Re: deleting internal table records with pattern

sridhar_meesala — Fri, 24 Jul 2009 06:26:53 GMT

Hi,

Try this.

DELETE itab WHERE vbeln = '40%'

Thanks,

Sri.

Re: deleting internal table records with pattern

Former Member — Fri, 24 Jul 2009 06:28:01 GMT

Hello ,

you can use this trick ....

data: var1 type char2 .

loop at itab .

var1 = itab-vbeln+0(2) .

if var1 = '40' .

delete itab .

enidf.

endloop.

Thanks and regards..

Priyank

Re: deleting internal table records with pattern

Former Member — Fri, 24 Jul 2009 06:28:49 GMT

Hi,

You can try this way...

vbeln-sign = 'I'.
vbeln-option = 'CP'.        " You sould use Contains Pattern when you use * 
vbeln-low = '40*'
append vbeln .
 
delete tabe itab where vbeln in vbeln.

Re: deleting internal table records with pattern

Former Member — Fri, 24 Jul 2009 06:29:11 GMT

Hi,

use, DELETE itab where vbeln+0(2) = '40'.

Hope it works!!

Rgds,

Pavan

Re: deleting internal table records with pattern

Former Member — Fri, 24 Jul 2009 06:33:11 GMT

tables : vbak.

data: itab TYPE standard TABLE OF vbak.

start-of-selection.

SORT itab BY vbeln DESCENDING.

DELETE itab where vbeln = '40*'.

Re: deleting internal table records with pattern

Former Member — Fri, 24 Jul 2009 06:37:45 GMT

Hi .

I hope this code solved your problem .

Loop at itab where vbeln(2) = '40' .

delete itab .

continue .

endloop .