Select statement

[Former Member]

Hi,

I want to select only matnr whose starts from R.

i wrote select quary like this..

select matnr from mara into table itab where matnr like '%R'.

can any body tell me what happen if any material start with r(small)

but its not working.

Amit.

[Former Member]

populate a range as

r_matnr-sign = 'I'.

r_matnr-option = 'CP'.

r_matnr-low = 'R*'.

append r_matnr.

r_matnr-sign = 'I'

r_matnr-option = 'CP'

r_matnr-low = 'r*'.

append r_matnr.

select matnr from mara into table itab where matnr in r_matnr.

[Former Member]

This should work

  SELECT * FROM MAKT
    WHERE MATNR LIKE 'R%'.   "<== need your where clause like this.
** Do Stuff
  ENDSELECT.

[Former Member]

HI Jony,

YOur query should be

select matnr from mara into table itab where matnr like 'R%'.

Regards,

Ravi

[Former Member]

YOur query will not result in materials starting with r.

you should write

matnr like 'R%'

or matnr like 'r%'.

REgards,

Ravi

[Former Member]

Hi,

Use Stsatement Uppercase.

Translate <matnr > to upper case.

Regards,

Narasimha

[Former Member]

hi jony,

the querry vl b like : SELECT MATNR FROM MARA WHERE MATNR LIKE 'R%'.

plz gv REWARD points if helpful...