select statement with where condition

[Former Member]

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?

[Former Member]

WHERE matnr LIKE '12%'.

[Former Member]

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.

[Former Member]

Thanks guys .

Message was edited by:

priya katragadda

[Former Member]

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

null

[Former Member]

do this way

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

Regards,

Santosh

[ferry_lianto]

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