How can include '*' option in a query
I have an input field for Material number , and this is used in a join to fetch data , my problem is some times user will enter material number as 456* , in this case how can i change the query.
Please see the join,
select dmatnr as material dwerks as plant dlgort as slocation dumlme dlabst rmeins k~maktx as descr
into corresponding fields of table it_data2
from mard as d inner join mvke as m
on dmatnr = mmatnr
inner join mara as r
on rmatnr = dmatnr
inner join makt as k
on kmatnr = dmatnr
*where d~matnr= lv_matnr*
and d~werks in r_plant
and m~vkorg in r_sales.