topic select with pattern in Application Development and Automation Discussions

select with pattern

dmi — Sat, 16 Oct 2010 09:55:36 GMT

Hello

I have this problem:

MAKT-MAKTX contains the value 'abc+def"

How can I find this pattern?

I tryed with:

data lr_maktx type range of maktx.

select * from makt into table lt_makt

where maktx in lr_maktx.

but it doesn't work

Thanks for any help

Daniel

Re: select with pattern

deepak_dhamat — Sat, 16 Oct 2010 11:21:48 GMT

data lr_maktx type range of maktx.
select * from makt into table lt_makt
where maktx in lr_maktx.

USE :

Ranges in order to Pass parameter to query

RANGES : Lr_matkl FOR makt-maktx .

Create Material Parameter

MOVE 'I' TO Lr_maktx-sign.

MOVE 'CP' TO Lr_maktx-option.

MOVE 'abc+def' TO Lr_maktx-low.

APPEND Lr_maktx.

ENDIF.

SELECT * FROM MAKT INTO CORRESPONDING FIELDS OF TABLE IT_MAKT

WHERE MAKTX IN LR_mAKTX .

regards

Deepak.

Re: select with pattern

dmi — Sat, 16 Oct 2010 15:27:25 GMT

HI Deepak

At first:

RANGES is the old version, don't use iit!

Second:

Have you tried your proposal in a SAP ECC6? - It works in your system?

In my system it doesn't work!

Daniel

Re: select with pattern

Former Member — Sat, 16 Oct 2010 22:57:37 GMT

Hi Daniel,

Please, show an example of the data in your MAKTX field (like "abckdef", etc.).

And confirm that your pattern is "abcdef" where "" means any character in that place.

Best regards,

Leandro Mengue

Re: select with pattern

Former Member — Sat, 16 Oct 2010 23:16:29 GMT

Hi,

Please, try this:

DATA: it_makt like makt occurs 0.

DATA: w_maktl like range of makt-maktx with header line.

w_maktl-sign = 'I'.
w_maktl-option = 'CP'.
w_maktl-low = 'abc+def'.
APPEND w_maktl.

SELECT * from makt into table it_makt
 where maktx in w_maktx.

Best regards,

Leandro Mengue

Re: select with pattern

dmi — Sun, 17 Oct 2010 05:01:53 GMT

Hi Leandro

Please read my question carefully - if you have a solution, I am very glad

IF NOT - LET IT - I give you only points for a solution how works, please try at first in your system

Daniel

Re: select with pattern

ThomasZloch — Sun, 17 Oct 2010 11:43:13 GMT

Don't be so impatient with the people trying to help you, rather tell what has not worked, do not offer points publicly, and answer the following questions:

- is "+" meant to be a wildcard placeholder for one character or the actual plus sign?

- can your search string appear at any place in the material description with other characters before or after?

Thomas

Re: select with pattern

dmi — Sun, 17 Oct 2010 14:55:09 GMT

Hi all together

Sorry if I'm not nice - but my question was clear!!!

And here is the solution:

select * from tab where feld like '%+%'.

All points for my self

Daniel

Re: select with pattern

dmi — Sun, 17 Oct 2010 14:55:55 GMT

Solved by my self

Re: select with pattern

ThomasZloch — Sun, 17 Oct 2010 15:12:29 GMT

You don't have to be nice, just polite towards people that you are asking for help, and your question was not clear. It was unclear whether "+" was supposed be a wildcard or normal character, and it was unclear that "abc" and "def" was your personal terminology for "any characters".

Enjoy your points.

Thomas

Re: select with pattern

Former Member — Mon, 18 Oct 2010 12:20:07 GMT

Sorry Daniel, you DO NOT solve your own question!!!

Remember that you use "range of" in your question?!

So, this is the correct answer: ( using the escape operator: # )

DATA: it_makt like makt occurs 0.
 
DATA: w_maktl like range of makt-maktx with header line.
 
w_maktl-sign = 'I'.
w_maktl-option = 'CP'.
w_maktl-low = '*#+*'.
APPEND w_maktl.
 
SELECT * from makt into table it_makt
 where maktx in w_maktx.

Best regards,

Leandro Mengue

Re: select with pattern

dmi — Mon, 18 Oct 2010 15:48:21 GMT

Hi Leandro

Sorry again - please accept my appology

Your solution works, thanks

Daniel

Re: select with pattern

Former Member — Mon, 18 Oct 2010 17:06:52 GMT

Hi Daniel,

That´s ok. Glad to help.

Best regards,

Leandro Mengue