topic Re: Like operator in a select in Application Development and Automation Discussions

Like operator in a select

Former Member — Wed, 26 Jun 2013 09:21:22 GMT

Hi,

I need to compare with a like operator in a select.

For example, I have the following:

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like 'FA%'.

Can anybody tell how I can get this, the last AND.

In a string it would be something like this but, how it is in a select:

matnr+0(2) = 'FA'.

Thanks in advance.

Regards.

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 09:27:25 GMT

Customers with a 'p' in their name from the second position:

SELECT name, city FROM customer

WHERE name LIKE '_%p%'

Please go through the link.

http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/content.htm

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 09:28:11 GMT

use matnr CS 'FA'

This checks the condition if the string 'FA' is present in the variable matnr.

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 09:32:49 GMT

data: w_str like mara-matnr.

w_str = 'FA*'.

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr CP w_str. "CP for Contains pattern

Hope it works.

Regards,

Vishram

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 09:34:37 GMT

Hi David,

Use CS - 'Contains String' Operator.

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr CS 'FA'.

For detailed understanding read http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3516358411d1829f0000e829fbfe/content.htm.

BR.

Re: Like operator in a select

asik_shameem — Wed, 26 Jun 2013 09:43:50 GMT

Hi David,

The mentioned statement itself will work.

  select matnr into ematnr from mast client specified
  WHERE mandt = sy-mandt
  AND werks EQ '3000'
  AND stlan EQ '1'
  AND stlal NE  '01'
  AND matnr like 'FA%'. " this statement will work for your requirement

Regards,

Asik.

Re: Like operator in a select

matt — Wed, 26 Jun 2013 09:47:42 GMT

You hope it works. Hmm. Shame it's not syntactically correct.

The idea of this site is to post helpful answers. Not just what you think might work. If you don't know, then don't post.

Re: Like operator in a select

matt — Wed, 26 Jun 2013 09:48:02 GMT

Shame it's not syntactically correct.

The idea of this site is to post helpful answers. Not just what you think might work. If you don't know, then don't post.

Re: Like operator in a select

matt — Wed, 26 Jun 2013 09:48:31 GMT

Precisely. I do wonder whether we've understood the OP's question. A simple look in the ABAP help at "like" would have revealed this.

Re: Like operator in a select

matt — Wed, 26 Jun 2013 09:48:47 GMT

Shame it's not syntactically correct.

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 10:13:46 GMT

Hi Matthew,

Thanks a lot for correcting me.

Hi David,

Syntactically correct and working code is,

data srch_str TYPE c LENGTH 2 value 'FA'.

CONCATENATE '%' srch_str '%' INTO srch_str.

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like srch_str.

endselect.

BR.

Re: Like operator in a select

former_member209120 — Wed, 26 Jun 2013 10:16:06 GMT

Hi David,

Your Code working fine

data : ematnr type mast-matnr.

select matnr into ematnr from mast client specified
   WHERE mandt = sy-mandt
   AND werks EQ '3000'
   AND stlan EQ '1'
   AND stlal NE '01'
   AND matnr like 'CH%'.
endselect.

Output

See this like you can understand how you get matnr+0(2) = 'FA' for last and matnr like 'FA%'.
http://help.sap.com/saphelp_nw70/helpdata/en/dc/a4dc72e89811d5995600508b6b8b11/content.htm

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 10:17:04 GMT

Hi David,

Your statement need little syntax correction.

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like 'FA%'.

ENDSELECT.

However you can check the wildcard character.

In WHERE-conditions of Open SQL with the operator LIKE "%" stands for any character strings and "_" for individual characters.

Logically it should work.

Thanks,

Anurag

Re: Like operator in a select

asik_shameem — Wed, 26 Jun 2013 10:19:23 GMT

I still have that question in my mind...Is he looking for something else..

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 10:31:49 GMT

Yes, you are right CS logical expression does not work in select queries. Should have checked that before posting. My mistake. Sorry about that.

And ironically, David, your code works perfectly fine after testing.

The only discrepancy I can see is, you need to either use end select, or select single, if ematnr is a work area or use the addition into table ematnr if it is a table. (Which I guess might have been already taken care of too).

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 10:38:40 GMT

Hi,

please try SELECT SINGLE or SELECT INTO TABLE. For example

select SINGLE matnr into ematnr from mast

WHERE werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like 'FA%'.

Do not use CLIENT SPECIFIED with sy-mandt.

Also do not use SELECT ENDSELECT in this case.

Regards,

Klaus

Re: Like operator in a select

former_member209120 — Wed, 26 Jun 2013 10:50:42 GMT

His code is correct and it is working,

I think, he is asking how we get FE by using like 'FE%' in select statement.

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like 'FA%'. " How it works ?

Re: Like operator in a select

Former Member — Wed, 26 Jun 2013 11:35:55 GMT

hi try this

1. data : l_matnr type matnr,

l_str(2) type c.

2. select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'.

if sy-subrc = 0.

l_str = ematnr+0(2).

if l_str = 'FA'.

move ematnr to l_matnr.

endif.

suresh

Re: Like operator in a select

former_member209120 — Wed, 26 Jun 2013 11:39:10 GMT

His code is correct and it is working,

I think, he is asking how we get FE by using like 'FE%' in select statement.

select matnr into ematnr from mast client specified

WHERE mandt = sy-mandt

AND werks EQ '3000'

AND stlan EQ '1'

AND stlal NE '01'

AND matnr like 'FA%'. " How it works ?

Re: Like operator in a select

RaymondGiuseppi — Wed, 26 Jun 2013 13:05:34 GMT

I agree with previous posts, nobody seems able to understand your question (me too) so what did you expect, comparing sql_cond - LIKE with log_exp - Comparison Operators for Character-Like Data Types (e.g. CP Covers Pattern) or what ?

Regards,

Raymond