in where condition OR operator not working (i am using inner joins)

[Former Member]

in where condition OR operator not working (i am using inner joins)

SELECT l~lifnr

l1~name1

b~waers

b~dmbtr

b~zfbdt

b~zbd1t

b~zbd2t

b~zbd3t

b~belnr

b~xblnr

b~shkzg

b~blart

INTO CORRESPONDING FIELDS OF TABLE int_bsik

FROM lfb1 AS l INNER JOIN lfa1 AS l1

ON l_{lifnr = l1}lifnr

INNER JOIN bsik AS b

ON l_{lifnr = b}lifnr AND

l_{bukrs = b}bukrs

WHERE

b_{zfbdt LE p_allgst AND l}bukrs = p_bukrs AND

( l_{lifnr IN s_lifnr OR l1}KTOKK = S_KTOKK OR b~PRCTR in S_PRCTR ).

pls do check this..

thank's in advance

[Former Member]

Hi,

if S_KTOKK is an select-option don't use

l1~KTOKK = S_KTOKK

use

l1~KTOKK in S_KTOKK

Hope it helps.

Regards, Dieter

[Former Member]

l1~ktokk in s_ktokk it is becaming endless loop. wat is the diffrence b/w = and in

[Former Member]

= checks for one single value ..

IN checks for all the values in the select option/range ..

[Former Member]

Hi,

SELECT l~lifnr

l1~name1

b~waers

b~dmbtr

b~zfbdt

b~zbd1t

b~zbd2t

b~zbd3t

b~belnr

b~xblnr

b~shkzg

b~blart

INTO CORRESPONDING FIELDS OF TABLE int_bsik

FROM lfb1 AS l INNER JOIN lfa1 AS l1

ON l_{lifnr = l1}lifnr

INNER JOIN bsik AS b

ON l_{lifnr = b}lifnr AND

l_{bukrs = b}bukrs

WHERE

b_{zfbdt LE p_allgst AND l}bukrs = p_bukrs AND

( l_{lifnr IN s_lifnr OR l1}KTOKK IN S_KTOKK OR b~PRCTR in S_PRCTR ).

you can use l1~KTOKK IN S_KTOKK instead of

l1~KTOKK = S_KTOKK

regards

bhupal

[Former Member]

hi write like this...

WHERE

b~zfbdt LE p_allgst

AND l~bukrs = p_bukrs

AND l~lifnr IN s_lifnr

OR l1~KTOKK in S_KTOKK

OR b~PRCTR in S_PRCTR .

[Former Member]

Thanks