topic Re: Problem while using Comparison Operator 'CA' in select queries in Application Development and Automation Discussions

Problem while using Comparison Operator 'CA' in select queries

Former Member — Mon, 27 Dec 2010 06:48:27 GMT

Hi ,

I have written select query like this.

SELECT * FROM rsdodso INTO TABLE gt_rsdodso

WHERE odsobject CA s_obj-low.

then I am getting error 'CA is not a valid comparison operator'.

Would you please suggest me how to use Comparison operators.

Regards,

K.krishna.

Moderator Message: Basic Post. Thread Locked. Points unassigned.

Edited by: kishan P on Dec 27, 2010 1:07 PM

Re: Problem while using Comparison Operator 'CA' in select queries

Former Member — Mon, 27 Dec 2010 06:54:59 GMT

Hi,

Use 'IN' and not CA. You cannot use CA in where clause. Write CA in if .. endif.

SELECT * FROM rsdodso INTO TABLE gt_rsdodso

WHERE odsobject IN s_obj.

if gt_rsdodso-ODSOBJECT CA '0D_FC_D01'.

endif.

Regards,

Srini.

Moderator Message: Do NOT answer basic questions.

Edited by: kishan P on Dec 27, 2010 1:07 PM

Re: Problem while using Comparison Operator 'CA' in select queries

Former Member — Mon, 27 Dec 2010 06:59:29 GMT

answered

Re: Problem while using Comparison Operator 'CA' in select queries

Former Member — Mon, 27 Dec 2010 07:01:21 GMT

Hi,

The 'Contains' Comparision Operators are not supported on selects if you press F1 on select you should be able to find the list of operators supported. I am not sure of what your requirement is but may be you can use the 'LIKE' to fulfill it.

Regards,

Himanshu