topic Re: SELECT-OPTIONS with pattern in interval in Application Development and Automation Discussions

SELECT-OPTIONS with pattern in interval

oliver_am — Wed, 30 Sep 2020 11:48:46 GMT

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!

Re: SELECT-OPTIONS with pattern in interval

FredericGirod — Wed, 30 Sep 2020 11:50:37 GMT

? <-- replace 1 char

* <-- replace all char

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

Re: SELECT-OPTIONS with pattern in interval

oliver_am — Wed, 30 Sep 2020 12:11:49 GMT

Like this?

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

Already tried before post, but is not working

Re: SELECT-OPTIONS with pattern in interval

FredericGirod — Wed, 30 Sep 2020 12:46:32 GMT

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

Re: SELECT-OPTIONS with pattern in interval

oliver_am — Wed, 30 Sep 2020 14:02:23 GMT

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

Re: SELECT-OPTIONS with pattern in interval

FredericGirod — Wed, 30 Sep 2020 14:22:21 GMT

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

Re: SELECT-OPTIONS with pattern in interval

RaymondGiuseppi — Wed, 30 Sep 2020 14:55:49 GMT

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.