topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Mon, 12 May 2008 12:30:07 GMT

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.

Re: Select statement

Former Member — Mon, 12 May 2008 12:33:26 GMT

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.

Re: Select statement

Former Member — Mon, 12 May 2008 12:33:42 GMT

This should work


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

Re: Select statement

Former Member — Mon, 12 May 2008 12:33:57 GMT

HI Jony,

YOur query should be

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

Regards,

Ravi

Re: Select statement

Former Member — Mon, 12 May 2008 12:36:27 GMT

YOur query will not result in materials starting with r.

you should write

matnr like 'R%'

or matnr like 'r%'.

REgards,

Ravi

Re: Select statement

Former Member — Mon, 12 May 2008 12:36:54 GMT

Hi,

Use Stsatement Uppercase.

Translate <matnr > to upper case.

Regards,

Narasimha

Re: Select statement

Former Member — Mon, 12 May 2008 12:54:27 GMT

hi jony,

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

plz gv REWARD points if helpful...