10-22-2007 7:33 AM
hi all
SELECT PERNR FROM PA0001 INTO TABLE INT_PERNR WHERE ORGEH IN S_ORGEH AND
PERSG = '3' AND
PERSK = ( 'K1' OR 'K2' OR 'V1' OR 'V2' OR 'W1' OR 'W2' )
AND ENDDA = '99991231'.
I am getting error in OR Operator. 'OR' is not a valid operator as an error. if i am removing the bracket , i am getting K1 K2 V1 V2 ,,,,, is unknown ,
suggest ur suggestions
regards
karthik
10-22-2007 7:34 AM
SELECT PERNR FROM PA0001 INTO TABLE INT_PERNR WHERE ORGEH IN S_ORGEH AND
PERSG = '3' AND
PERSK IN ( 'K1' , 'K2' , 'V1' , 'V2' , 'W1' , 'W2' )
AND ENDDA = '99991231'.
10-22-2007 7:45 AM
hi, thanks for ur reply. but eventhough i got the same, but i solved with the following,
SELECT PERNR FROM PA0001 INTO TABLE INT_PERNR WHERE ORGEH IN S_ORGEH AND
PERSG = '3' AND
( PERSK = 'K1' OR
PERSK = 'K2' OR
PERSK = 'V1' OR
PERSK = 'V2' OR
PERSK = 'W1' OR
PERSK = 'W2' )
thanks
regards karthik
10-22-2007 7:34 AM
10-22-2007 7:35 AM
You need to change OR condition as
SELECT PERNR FROM PA0001 INTO TABLE INT_PERNR WHERE ORGEH IN S_ORGEH AND
PERSG = '3' AND
( PERSK = 'K1' OR
PERSK = 'K2' OR
PERSK = 'V1' OR
PERSK = 'V2' OR
PERSK = 'W1' OR
PERSK = 'W2' )
This should fix the problem.
ashish