Doubt in Select Option fetch
I have a select option field for which the input values can be given as in the below example.
Ex. If the input value is given as 10* as the low value and 100* as the high value, i need to fetch records in this range.Which means it should not only include all values starting with 10 and 100 but also the values between 10 and 100. Please let me know how this can be achieved.
Christian Wohlfahrt replied
This is really straight forward from programming point of view - there is nothing special to be done (check with SE16!).
But maybe you struggle with leading zeros. I tested with MARA, here I had to fill 000000000010001* - 000000000010003* to get a result. Reason: there is a conversion exit ALPHA. This adds leading zeros, as long as the input contains only numbers: * is not a number. But our material numbers are stored with leading zeros in database, because they contain only numbers - so here leading zeros have to be added manual.