topic Re: checking Not in operator in Application Development and Automation Discussions

checking Not in operator

Former Member — Wed, 18 Feb 2009 06:36:57 GMT

Hi experts

1. is it possible to use NOT IN operator

for e.g if i check few condition using ( IN operator ) and at the

same time want to check that is not there in my ( IN operator)

else pls do let me know by saying how can this be done.....

My query

========

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')

and massn not in 'S5' " this is wat the condition i want to check and pernr in so_pernr.

Elseif pr_sep = 'X'.

Select pernr begda from pa0000 into corresponding fields of table it_pa0000

WHERE

BEGDA <= SY-DATUM AND

ENDDA >= SY-DATUM AND

MASSN in ('S5')

and pernr in so_pernr.

thanx & regards

Rachel

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:41:52 GMT

write as :

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

pernr in so_pernr

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')

and massn NE 'S5' .

or create a range for MASSN ..

populate all the values for MASSN ..

r_massn-sign = 'E'. <-- for all other values pass 'I' ...

r_massn-option = 'EQ'.

r_massn-low = 'S5'.

append r_massn.

in select just use

select ....

where ...

massn in r_massn.

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:43:42 GMT

hi,

please see this thread for help

thanks

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:44:43 GMT

Hi Rachel ,

It possible to use NOT IN operator.

you need to write two select query and according to your requirement codes will be executed.

Regards

Pinaki

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:46:53 GMT

HI Rachel,

For that you need to create the Ranges

try this:

ranges: r_MASSN   type MASSN .

r_MASSN-sign = 'I'.
r_MASSN-option = 'EQ'.
r_MASSN-low     = 'S1'.
r_MASSN-high   = ''.
append r_MASSN.
clear r_MASSN.

r_MASSN-sign = 'I'.
r_MASSN-option = 'EQ'.
r_MASSN-low     = 'S2'.
r_MASSN-high   = ''.
append r_MASSN.
clear r_MASSN.

r_MASSN-sign = 'I'.
r_MASSN-option = 'EQ'.
r_MASSN-low     = 'S3'.
r_MASSN-high   = ''.
append r_MASSN.
clear r_MASSN.

r_MASSN-sign = 'I'.
r_MASSN-option = 'EQ'.
r_MASSN-low     = 'S4'.
r_MASSN-high   = ''.
append r_MASSN.
clear r_MASSN.

r_MASSN-sign = 'I'.
r_MASSN-option = 'NE'.    "Check this for S5
r_MASSN-low     = 'S5'.
r_MASSN-high   = ''.
append r_MASSN.
clear r_MASSN.

r_MASSN-sign = 'I'.
r_MASSN-option = 'EQ'.
r_MASSN-low     = 'S7'.
r_MASSN-high   = ''.
append r_MASSN.
clear r_MASSN.



your query 

Select pernr begda from pa0000 into corresponding fields of table it_pa0000
WHERE
BEGDA <= SY-DATUM AND
ENDDA >= SY-DATUM AND
MASSN in r_MASSN.   "here you will get your required data.
and pernr in so_pernr.

Regards!

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:50:52 GMT

I think you there should not any problem using NOT IN.

Try this:

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7') and

MASSN NOT IN ('S5').

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:52:23 GMT

Hi Rachel,

This would help..kindly chk..


Select pernr begda massn from pa0000 
into corresponding fields of table it_pa0000
WHERE  MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')
and massn NE S5.
"chk return code sy-subrc...

*if S5 is a select option then
s5-sign = 'E'.
modify s5 transporting sign where sign eq 'I'.
 "by this S5 contains only excluded values i.e 'not in' ..thn perform select query..as

Select pernr begda massn from pa0000 
into corresponding fields of table it_pa0000
WHERE  MASSN in ('S1', 'S2', 'S3', 'S4', 'S5','S7')

Regards,

Mdi.Deeba

Edited by: Mdi.Deeba on Feb 18, 2009 7:53 AM

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 06:57:56 GMT

Hi thanx for the reply

I made the changes as u said but then its getting me

an *error saying*

*The IN operator with "R_MASSN" is followed neither by an internal table*

*nor by a value list.*

DATA: s_massn TYPE RANGE OF CHAR10,

r_massn LIKE LINE OF s_massn.

r_massn-sign = 'E'. " <-- for all other values pass 'I' ...

r_massn-option = 'EQ'.

r_massn-low = 'S5'.

append r_massn to s_massn.

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')

and massn in r_massn ---> error and pernr in so_pernr.

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:00:09 GMT

This is a sample code done to exclude specific order nos. Jus replace the same with S5(in ur case) and it will work. Create the corresponding internal table according to the data type of S5.

Your problem will be solved

RANGES: r_ordno FOR wa_ordno-ordno.

LOOP AT it_ordno INTO wa_ordno. "Say you have ord no in tab it_ordno

r_ordno-sign = 'I'.

r_ordno-option = 'EQ'.

r_ordno-low = wa_ordno-ordno.

APPEND r_ordno.

ENDLOOP.

SELECT * FROM AUFK

INTO TABLE it_tab

WHERE ordno NOT IN r_ordno.

Regards,

Priti.

Re: checking Not in operator

GauthamV — Wed, 18 Feb 2009 07:00:35 GMT

Declare ranges like this.


Ranges: r_massn for pa0000-massn.

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000
WHERE
MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')
and massn in r_massn.

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:01:00 GMT

You can try what I have suggest above or do the below changes in the code

DATA: s_massn TYPE RANGE OF CHAR10,

r_massn LIKE LINE OF s_massn.

r_massn-sign = 'E'. " <-- for all other values pass 'I' ...

r_massn-option = 'EQ'.

r_massn-low = 'S5'.

append r_massn to s_massn.

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')

and massn in s_massn ---> error and pernr in so_pernr.

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:02:06 GMT

Hi,

Use the select query given below this works...

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000
WHERE NOT MASSN in 'S5'.

Regards,

Siddarth

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:04:29 GMT

sorry this doesnt works

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:05:02 GMT

thanx not in operator doesnt works for me

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:06:23 GMT

thanx but

neither

and not massn in ('S5')

or not in massn ('s5') works for me

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:06:24 GMT

Have you tried this:

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7') and

MASSN NOT IN ('S5').

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:07:42 GMT

is ur problem solved.

If not then do this.

RANGES: r_massn FOR PA0000-massn.

r_massn-sign = 'I'.

r_massn-option = 'EQ'.

r_massn-low = 'S5'.

APPEND r_massn.

Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7') and

MASSN NOT IN r_massn.

Edited by: priti suryawanshi on Feb 18, 2009 8:11 AM

Re: checking Not in operator

Former Member — Wed, 18 Feb 2009 07:11:48 GMT

hi thanx for the reply

i tried but i am getting a error as

"FOR ... ." or "FOR ... OCCURS ... ." expected after "R_MASSN". near

ranges: r_MASSN type MASSN .

i dont know this ...and iam just trying ...can u pls guide me

thanx alot

Re: checking Not in operator

GauthamV — Wed, 18 Feb 2009 07:13:13 GMT


Tables PA0000.

Ranges : r_massn for pa0000-massn.

Re: checking Not in operator

former_member182354 — Wed, 18 Feb 2009 07:16:12 GMT

Range is what you need for your requirement.

Raghav