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 llifnr = l1lifnr
INNER JOIN bsik AS b
ON llifnr = blifnr AND
lbukrs = bbukrs
WHERE
bzfbdt LE p_allgst AND lbukrs = p_bukrs AND
( llifnr IN s_lifnr OR l1KTOKK = S_KTOKK OR b~PRCTR in S_PRCTR ).
pls do check this..
thank's in advance