2007 Mar 21 2:57 PM
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?
2007 Mar 21 2:58 PM
2007 Mar 21 2:58 PM
2007 Mar 21 2:59 PM
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.
2007 Mar 21 3:03 PM
2007 Mar 21 2:59 PM
select * from mara into table it_mara where matnr like '12%'.
null
2007 Mar 21 2:59 PM
do this way
select * from mara into table it_mara where matnr like'12%'.
Regards,
Santosh
2007 Mar 21 3:11 PM
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