topic Re: Select-options with pattern in Application Development and Automation Discussions

Select-options with pattern

Former Member — Thu, 03 Dec 2009 05:33:59 GMT

Hello All,

I have to get material from mara table based on product hier.. My user enters only first two digits. Then I have to pick all the records which starts with the entered number.

Select-options: s_prdha for mara-prodh_d.

Suppose if I enter 18. My output should come with materials having prdha startes 18.

matnr prdha

123 183423424

345 186734893

678 1823

Vinod-

Re: Select-options with pattern

Former Member — Thu, 03 Dec 2009 05:36:59 GMT

Hi,

You can give input in your select option as 18*.

Or in your select query say


select field1 field2 from table where field1 like '18%'.

Re: Select-options with pattern

Former Member — Thu, 03 Dec 2009 05:38:29 GMT

Hi,

U can attach '%' for searching.

Re: Select-options with pattern

Former Member — Thu, 03 Dec 2009 05:40:19 GMT

Hi,

Concatenate '%' to the s_prodha-low. And in the select statement use

the condition : where prodh_d eq s_prodha-low.

Hope this solves ur problem.

Regards,

Bhavesh.

Re: Select-options with pattern

Former Member — Thu, 03 Dec 2009 11:00:57 GMT

LIKE statement works only for Parameter.

My requirement has to work for ranges, Single multiple values and whatever.

I had done it by creating Ranges table.