Select-options with pattern

[Former Member]

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-

[Former Member]

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%'.

[Former Member]

Hi,

U can attach '%' for searching.

[Former Member]

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.

[Former Member]

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.