topic Re: delete itab in Application Development and Automation Discussions

delete itab

Former Member — Wed, 01 Feb 2006 04:02:28 GMT

Hi Abapers,

i want to delete itab using 'in' operator but it's not supporting...

So can any one say what is the substitute for in operator?

Example Like This..

delete itab where mtart in ('HALB' 'ROH') and also

delete itab where mtart not in ('HALB' 'ROH')

Thanks...

Have a nice day..

Regards

OJP..

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:04:15 GMT

Hi Priya,

try : with Comma between HALB and ROH

delete itab where mtart in ('HALB','ROH' ).

Lanka

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:05:27 GMT

Use commas:

delete itab where mtart in ('HALB' , 'ROH')

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:05:35 GMT

Priya,

You cannot use it like that.

Declare a variable RANGES, append all your values there and then use the IN clause. You can use I and EQ for the Sign and Option fields.

DELETE itab where MATNR in R_MATNR.

Regards,

Ravi

Note : Reward the posts that help you.

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:22:49 GMT

RANGES range for mara-mtart.
range-sign = 'I'.
range-option = 'EQ'.
range-low = 'HALB'.
range-high = 'ROH'.
APPEND range.
DELETE : itab where mtart in range.

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:26:12 GMT

Hi Priya,

You can try using Select options as...

SELECT-OPTIONS check_in FOR mtart NO-DISPLAY.

s_number-sign = 'I'.

s_number-option = 'EQ'.

s_number-low = 'HALB'.

APPEND check_in TO check_in.

s_number-sign = 'I'.

s_number-option = 'EQ'.

s_number-low = 'ROH'.

APPEND check_in TO check_in.

delete statement

Regards,

Uma

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:30:39 GMT

A correction to the previous post as Uma had suggested.

RANGES range for mara-mtart.

range-sign = 'I'.

range-option = 'EQ'.

range-low = 'HALB'.

APPEND range.

range-sign = 'I'.

range-option = 'EQ'.

range-low = 'ROH'.

APPEND range.

DELETE : itab where mtart <b>NOT IN</b> range.

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:46:45 GMT

Hi,

ranges: r_mtart for mara-mtart.
r_mtart-sign = 'I'.
r_mtart-option = 'EQ'.
r_mtart-low = 'HALB'.
APPEND r_mtart.

r_mtart-sign = 'I'.
r_mtart-option = 'EQ'.
r_mtart-low = 'ROH'.
APPEND r_mtart.

delete itab where mtart not in r_mtart

regards

vijay

Message was edited by: Vijay Babu Dudla

Re: delete itab

Former Member — Wed, 01 Feb 2006 04:50:10 GMT

Performance wise, I would just recommend using two statements instead of one as follows.

DELETE itab WHERE mtart = 'HALB'.

DELETE itab WHERE mtart = 'ROH'.

Re: delete itab

former_member184495 — Wed, 01 Feb 2006 05:09:02 GMT

hi priya,

to my knowledge, 'IN' is replaced for 'OR'

and 'Not in' by 'AND'.

so you could try it out.

delete itab where mtart eq 'HALB' or mtart eq 'ROH'

delete itab where mtart ne 'HALB' and mtart ne 'ROH'

reward me if it was helpful.

regards,

Aditya.

Re: delete itab

Former Member — Wed, 01 Feb 2006 06:42:17 GMT

Hi All,

Kindly note that Range is not same as operator IN

e.g IN (A , B , F) .. this will delete the entries wid value as A or B or F (this represents a SET not a range)

if you use the range table between A and F it will delete all entries between A and F i.e A , B , C , D , E and F.

The best solution is the one advised by Mr. Adavi.

regards,

Sumeet Mishra,

Reward points if this helps. : )