topic Re: About Select Statement in Application Development and Automation Discussions

About Select Statement

Former Member — Mon, 24 Nov 2008 12:55:39 GMT

Hi friends,

i want to select records from mara table which first letter starts with "M". how should i write it.

regards

Kumar m

Re: About Select Statement

Former Member — Mon, 24 Nov 2008 13:02:37 GMT

Hi Friends,

i am wating for answer.

Re: About Select Statement

Former Member — Mon, 24 Nov 2008 13:04:26 GMT

Which field would you like to choose?

You may try

select field1 field2 ...

into table i_tab

from mara

where condition_field like 'M%'.

Re: About Select Statement

Former Member — Mon, 24 Nov 2008 13:05:27 GMT

Hi,

I guess this code should help you to get the data starting with M as first letter in MATNR. I have bolded the where condition in which you have to use a variable where you concatenate the first letter and % for the selection. % is something like * when you are searching.

DATA: it_mara TYPE TABLE OF mara.

DATA: wa_mara TYPE mara.

DATA: l_variable(2) TYPE c.

CONCATENATE 'M' '%' INTO l_variable.

SELECT * FROM mara

INTO TABLE it_mara

WHERE matnr LIKE l_variable.

Re: About Select Statement

Former Member — Mon, 24 Nov 2008 13:08:25 GMT

Hi,

Do u mean to say that u want records from mara with perticular firlds (e.g. matnr) start with M.

Then u can try following,

select all data from mara into itab.

str = 'M*'.

loop at itab.

if itab-matnr = str1.

exit.

else.

delete itab index sy-tabix.

endif.

endloop.