regarding or condition in select statement

[Former Member]

Hi,

i have an error with folowing statement tcode = ( 'ME22N' or 'ME23N' AND CHNG_IND = 'U' ).

this is gibing and eror please suggest.

SELECT * FROM cdhdr INTO TABLE t_cdhdr1

WHERE objectclas = 'EINKBELEG' AND

objectid = t_ekko-ebeln AND

tcode = ( 'ME22N' or 'ME23N' AND CHNG_IND = 'U' ).

[Former Member]

Hi,

i have an error with folowing statement tcode = ( 'ME22N' or 'ME23N' AND CHNG_IND = 'U' ).

this is gibing and eror please suggest.

SELECT * FROM cdhdr INTO TABLE t_cdhdr1

WHERE objectclas = 'EINKBELEG' AND

objectid = t_ekko-ebeln AND

tcode = ( 'ME22N' or 'ME23N' AND CHNG_IND = 'U' ).

[amit_khare]

Will this work -

*SELECT * FROM cdhdr INTO TABLE t_cdhdr1*

WHERE objectclas = 'EINKBELEG' AND

objectid = t_ekko-ebeln AND

( tcode = 'ME22N' or

tcode = 'ME23N' ) AND

CHNG_IND = 'U' .

also, check its CHNG_IND or CHANGE_IND.

[Former Member]

i have tried like this but it doesn't work

SELECT * FROM cdhdr INTO TABLE t_cdhdr1

WHERE objectclas = 'EINKBELEG' AND

objectid = t_ekko-ebeln AND

tcode = ( 'ME22N' ) or

( 'ME23N' AND CHANGE_IND = 'U' ) .

[Former Member]

Hi i got it

SELECT * FROM cdhdr INTO TABLE t_cdhdr1

WHERE objectclas = 'EINKBELEG' AND

objectid = t_ekko-ebeln AND

tcode = 'ME22N' or

( tcode = 'ME23N' AND CHANGE_IND = 'U' ) .

[Former Member]

Hi,

Try this one.

SELECT * FROM cdhdr INTO TABLE t_cdhdr1

WHERE objectclas = 'EINKBELEG' AND

objectid = t_ekko-ebeln AND

tcode in ( 'ME22N', 'ME23N' )

AND CHANGE_IND = 'U' .

Regards,

Andre