topic Re: regarding or condition in select statement in Application Development and Automation Discussions

regarding or condition in select statement

Former Member — Thu, 08 Jan 2009 00:17:05 GMT

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 — Thu, 08 Jan 2009 00:25:48 GMT

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 — Thu, 08 Jan 2009 00:44:06 GMT

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 — Thu, 08 Jan 2009 00:52:53 GMT

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 — Thu, 08 Jan 2009 00:53:30 GMT

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