topic Re: Ranges? in Application Development and Automation Discussions

Ranges?

Former Member — Tue, 15 May 2007 17:45:03 GMT

Hi Experts,

I know that the following statemnt works with select options,

DELETE ITAB WHERE NOT KUNNR = S_KUNNR[ ]

But, in my enhancing z_prog. the earlier programmer is defined it (s_kunnr) as RANGES! (now i can not change from range to select options, bcoz of some other constraints)

So,

1 - Can I use the similar statement for the Ranges also! to get deleted all the records from itab, which does not match, like,

DELETE ITAB WHERE NOT KUNNR = R_KUNNR [ ]

ThanQ.

Re: Ranges?

Former Member — Tue, 15 May 2007 17:46:19 GMT

Hi,

You have to use IN instead of =

DELETE ITAB WHERE NOT KUNNR IN R_KUNNR [ ]

Thanks,

Naren

Re: Ranges?

Former Member — Tue, 15 May 2007 17:48:03 GMT

Ranges also used similar to Select-options with IN operator in where condition

use

DELETE ITAB WHERE NOT KUNNR IN R_KUNNR .

it will work fine.

Reward points if useful

Regards

Anji

Re: Ranges?

Former Member — Tue, 15 May 2007 17:58:28 GMT

U mean its not necessory to use " [ ] " ?

thanq.

Re: Ranges?

Former Member — Tue, 15 May 2007 18:00:53 GMT

No need to use [] in Ranges and Select option.

just use

delete itab where cond in s_kunnr.

Reward Points if it is useful

Thanks

Seshu

Re: Ranges?

rahulnavandar — Tue, 15 May 2007 18:03:19 GMT

Sridhar,

It is not necessary to use []. you can do this using IN.