topic Re: regarding select statement in Application Development and Automation Discussions

regarding select statement

Former Member — Mon, 11 Jun 2007 06:01:59 GMT

Hi,

i am using material code ( declared as parameter statement ) in where clause of select statemant . i want to run the select for input like DC* in parameter so that all materials starting from DC are included in the select.

thanks and regards

abaper.

Re: regarding select statement

santhosh_patil — Mon, 11 Jun 2007 06:05:59 GMT

Hi,

use like

select -

from ---

where

matnr like p_matnr.

--Patil

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 06:22:04 GMT

Hi King,

This is dynamic selection and * is not used in this clause. You can use % instead of * to achieve at the solution.

This sholud solve your query.

Reward Points if useful.

Thanks,

Tej..

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 06:23:39 GMT

select matnr from mara into table itab where matnr like P_MATNR.

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 06:31:31 GMT

Hi Tez,

can you write the full select statement. where to write %

thanks and regards

abaper

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 06:34:33 GMT

HI,

select * from mara into i_mara where matnr = 'dc%'.

this select statement will select all the record which is having material number starts with "dc"

rgds,

bharat.

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 06:42:35 GMT

Hi again King,

Use this way.

Select field1 field 2

from table

into int_table

where sel_field = 'DC%'.

Note: Always remember that the code within single cotes should be in CAPS.

This should solve your query.

Reward Points if useful.

Thanks,

Tej..

Message was edited by:

Shree Tejus

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 06:53:41 GMT

Hi ,

thanks for your reply , but i dont want to hard code it .

rgds

abaper.

Re: regarding select statement

kiran_k8 — Mon, 11 Jun 2007 06:54:09 GMT

Hi,

The above select statements are not working.

select maktx from makt into table imakt where makt = 'T%'.

is not working.

K.Kiran.

Re: regarding select statement

santhosh_patil — Mon, 11 Jun 2007 06:56:08 GMT

Hi,

use LIKE

select maktx from makt into table imakt where makt like 'T%'.

--Patil

Re: regarding select statement

jayanthi_jayaraman — Mon, 11 Jun 2007 06:56:47 GMT

Hi,

If you are using select-options, you can achieve the result without extra effect.

If you want to use only parameter, you need to use ranges in your logic and equate option = 'CP'.Here is the code.It is working fine.Kindly reward points by clicking the star on the left of reply,if it helps.

parameters p_matnr type matnr.

tables mara.

data itab type standard table of mara.

data wa type mara.

ranges r_matnr for mara-matnr.

r_matnr-low = p_matnr.

r_matnr-sign = 'I'.

r_matnr-option = 'CP'.

append r_matnr.

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

loop at itab into wa.

write wa-matnr.

endloop.