topic Re: logical operator in Application Development and Automation Discussions

logical operator

Former Member — Tue, 08 Jan 2008 19:29:33 GMT

Hi Experts,

Can we use logical operator in where clause of select statement?????

My requirement is i want to CA logical operator in select statement.Is there any possibility????????

If there please tell me???????????\

Nice answers reward with maxi points.................

Former Member — Tue, 08 Jan 2008 19:42:09 GMT

Try this: -

Declare a range say r_matnr with conditions like

SIGN OPTION LOW HIGH

E CP 1234567890

Use this range in the where condition with "IN" clause like "where matnr in r_matnr"

-Cheers

Edited by: Prakash Bhatia on Jan 8, 2008 2:46 PM

Former Member — Tue, 08 Jan 2008 20:49:09 GMT

Hi Subash,

Prakash is right with his idea to go by range,

but it won't work like this.

Instead build your range like this:

ranges r_matnr for Tnnnn-MATNR.

r_matnr-sign = 'I'.

r_matnr-option = 'BT'.

r_matnr-low = '0'.

r_matnr-high = '9999999999'.

"max length of matnr filled with 9

APPEND r_matnr.

then

SELECT * FROM Tnnnn WHERE MATNR IN r_matnr

AND ......

this will get you only those entries with plain numerical MATNR.

For the opposit selection, just replace 'I' wit 'E' in r_matnr-option.

hope that helps.

Regards

Edited by: Joerg Wulf on Jan 8, 2008 10:43 PM

Former Member — Tue, 08 Jan 2008 22:08:50 GMT

I can't think of any way to do this.

Rob