search particular pattern

[Former Member]

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...

[FredericGirod]

hi,

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

rgd

Frédéric

[Former Member]

Hi

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.

[Former Member]

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

[Former Member]

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

[jayanthi_jayaraman]

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.

[Former Member]

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.

[jayanthi_jayaraman]

Hi,

Try giving ??a*

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

[Former Member]

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