topic Substring in SELECT Statemen in Application Development and Automation Discussions

Substring in SELECT Statemen

Former Member — Wed, 28 Jun 2006 21:36:23 GMT

Hello I need to do something like this:

select single bukrs

from ce1xx00

into v_bukrs

where prctr+2(2) = 'ab'.

but is telling me prctr+2(2) is not valid.

How can I do that? I'm doing this in an RFC call and is not affordable to bring all the data from the table

Any ideas?

TIA

Re: Substring in SELECT Statemen

RichHeilman — Wed, 28 Jun 2006 21:48:59 GMT

Scott, you can try to use a wildcard. Check this sample program. It will retrieve all program names that the 2nd and 3rd positions = 'RI'. I believe this is the type of functionality that you require.



data: itab type table of trdir with header line.

select * into table itab from trdir
              <b>where name like '_RI%'.</b>
  check sy-subrc  = 0.

REgards,

Rich Heilman

Re: Substring in SELECT Statemen

RichHeilman — Wed, 28 Jun 2006 22:07:41 GMT

So in your case....



select single bukrs 
from ce1xx00 
into v_bukrs 
where prctr  = '__ab%'.

You may have to use upper case.



select single bukrs 
from ce1xx00 
into v_bukrs 
where prctr  = '__AB%'.

REgards,

Rich HEilman

Re: Substring in SELECT Statemen

Former Member — Wed, 28 Jun 2006 22:08:36 GMT

I appollogize for not document all the case from the begining. Table xxx have two fields yyy and zzz. yyy always have 4 letters and zzz have 6. the chars 2 to 6 must be equals to field yyyy. Because of a bug, there are some items that are not consistent. So I need to ask

Where zzz+2(4) ne yyy

Re: Substring in SELECT Statemen

RichHeilman — Wed, 28 Jun 2006 22:13:40 GMT

Well this is a completely different requirement. Not sure that you can accomplish it with a single select statement.

REgards,

Rich Heilman