SELECT-OPTIONS with pattern in interval

[oliver_am]

Hello,
Is it possible to use patterns in an interval in a select-options?

I need to select a field filtering only by the last 5 characters.

I can use CP in select-options and the character + or * but is not working with intervals.

You can test it in se16 in table KNA1 for example:

Tried also with * but not working.

How would you do it efficiently by code?

SAP_ABA 731.

Thanks!

[FredericGirod]

? <-- replace 1 char

* <-- replace all char

if you do a *00070 to *00099, it should works

[oliver_am]

Like this?

SIGN I
OPTION BT "Tried also with CP
LOW *0070
HIGH *0099

Already tried before post, but is not working

[FredericGirod]

Yep it does not work.

And certainly cannot work

Imagine you have the value 10070 20075 30099

even if you try to do a split interval you will have to do

10070 -> 10099

20070 -> 20099

30070 -> 30099

and to have the list of intervals, you have to do a full SELECT on the database to know the list of possible intervals

[oliver_am]

i konw...
so the unique solution is to select all the records of the table (thousands...) and the filter the data in my program... 😞

I'll suggest functional team not using intervals in this field

[FredericGirod]

I already created a simple function to merge continuous value to recreate a "simplified" range, to prevent the max size of a RANGES

it replaces 0011 0012 0013 0015 to

I BT 0011 0013

I EQ 0015

it is not so complex, and simplify the next SELECT statement

[RaymondGiuseppi]

Select-options allows either wildcard or range, not a mix of 'LIKE' and 'BETWEEN'. In recent versions you can use a function as operand such as RIGHT( expr,len ) but define a special range in your selection-screen.