Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can include '*' option in a query

Hi,

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.

Regards,

Ratheesh BS

Tags:
Not what you were looking for? View more on this topic or Ask a question