topic Re: search particular pattern in Application Development and Automation Discussions

search particular pattern

Former Member — Tue, 21 Feb 2006 10:34:57 GMT

hi all...

in MB51 i want to find all materials whose third letter is 'a'

e.g t0a1,mianl,anart,aaakk,mmatt etc....

Plz help...

Re: search particular pattern

FredericGirod — Tue, 21 Feb 2006 10:36:48 GMT

hi,

select * from mara where matnr like '??A%'.

rgd

Frédéric

Re: search particular pattern

Former Member — Tue, 21 Feb 2006 10:43:06 GMT

HI Madan

you can use

CP --> contains pattern

DATA: str1 TYPE string,

str2 TYPE string.

str1 = 'ABCDEFGH'.

str2 = 'CF+H'.

IF str1 CP str2.

...

ENDIF.

Re: search particular pattern

jayanthi_jayaraman — Tue, 21 Feb 2006 10:47:27 GMT

Hi,

Try giving ??a*

Kindly reward points by clikcing the star on the left of reply,if it helps.

Re: search particular pattern

Former Member — Tue, 21 Feb 2006 10:53:39 GMT

Hi,

To search a character field for a particular pattern, use the SEARCH statement:

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb33cc358411d1829f0000e829fbfe/content.htm

Best Regards,

Anjali

Re: search particular pattern

Former Member — Tue, 21 Feb 2006 10:54:08 GMT

Just write a simple ABAP program with the following code

data:

begin of t_matnr occurs 0,

matnr type matnr,

end of t_matnr.

select matnr

from mara

into table t_matnr

where matnr like '__A%'.

loop at t_matnr.

write:/ t_matnr-matnr.

endloop.

Re: search particular pattern

Former Member — Tue, 21 Feb 2006 11:02:45 GMT

hi all...i want to that can we search this in MB51 without ABAP coding....

Re: search particular pattern

Former Member — Tue, 21 Feb 2006 11:11:52 GMT

Hi Madan,

It is not possible, through coding you can search, but this is standard program,that is also ruled out ...

what is your requirement..

Regards

vijay

Re: search particular pattern

jayanthi_jayaraman — Tue, 21 Feb 2006 11:15:02 GMT

Hi,

If you want that option for F4 help in Material number,you can do so by ??a*.Then press F4.You will get only those values.