Skip to Content
Former Member
Aug 13, 2009 at 03:20 AM

SQL Select for wildcard search in search help in module pool programme


Hi all,

In my module pool programe table control I have created F4 value ( Search help) by FM F4IF_INT_TABLE_VALUE_REQUEST

in Process on value-request.

I am populating internal table to get the values.

but user asks they will put wildcard ( * ) search for the material document to get the list by F4 values.

like 23*09 instead of full material document no.

In my select statement i have used % instead of *. ( 23%09) and with LIKE statement.

I am not getting any data from my data base table.

kindly help me what type of select statement i have to use to get the data list.

Thanks in advance.