topic select statement with where condition in Application Development and Automation Discussions

select statement with where condition

Former Member — Wed, 21 Mar 2007 14:57:15 GMT

HI all ,

I want to extract data from data base table with where condition with Z*.

How can i do that?

select * from mara into table it_mara where matnr = '12*'.

but iam unable to get materials starts with 12 .

how can i get that one?

Re: select statement with where condition

Former Member — Wed, 21 Mar 2007 14:58:03 GMT

WHERE matnr LIKE '12%'.

Re: select statement with where condition

Former Member — Wed, 21 Mar 2007 14:59:06 GMT

select * from mara into table it_mara where matnr like '12%'.

null

Re: select statement with where condition

Former Member — Wed, 21 Mar 2007 14:59:16 GMT

do this way

select * from mara into table it_mara where matnr like'12%'.

Regards,

Santosh

Re: select statement with where condition

Former Member — Wed, 21 Mar 2007 14:59:51 GMT

But you should remember that material numbers are stored with leading zeros internally (if your material numbers are all numeric). So this still may not give you what you wanted to achieve.

Re: select statement with where condition

Former Member — Wed, 21 Mar 2007 15:03:08 GMT

Thanks guys .

Message was edited by:

priya katragadda

Re: select statement with where condition

ferry_lianto — Wed, 21 Mar 2007 15:11:58 GMT

Hi,

You can also use ranges.


tables: mara.

ranges: r_matnr for mara-matnr.

r_matnr-sign = 'I'.
r_matnr-option = 'CP'.
r_matnr-low = '12*'.
append r_matnr.

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

Regards,

Ferry Lianto