Help on selection range contains wildcard '*'

[Former Member]

There is the following code:

  S_VCC FOR RPSCO-ACPOS DEFAULT 'ZPSAC*', " Value Category Costs
  S_VCR FOR RPSCO-ACPOS DEFAULT 'ZPSAR*'. " Value Category Revenue

and if the program use the 2 ranges directly in where clause, it returns no value.

 
AND RPSCO~ACPOS IN  S_VCC

this's not what we expect.

So what we can do? welcome any suggestion!

Thanks very much.

[Former Member]

how is the query written?

It should be in OR condition coz AND would never be true.

AND ( RPSCO_{ACPOS IN S_VCC OR OR RPSCO}ACPOS IN S_VCR )

Please paste the select statement you are using.

[Former Member]

I am sorry that maybe I don't express my idea clearly.

Yes I use the option in the select clauser correctly. But the result set is null.

And we expect |ZPSAC* are : ZPSAC000000000 ,ZPSAC000000001 ,etc

[Former Member]

In that case you can not use default.

<b>Remove default value from declaration of select-option.</b>

Try this:

In Initialization,

<b>INITIALIZATION.

CLEAR S_VCC.

S_VCC-SIGN = 'I'.

S_VCC-OPTION = 'CP'.

S_VCC-LOW = 'ZPSAC*'.

APPEND S_VCC.</b>

As this is a pattern it needs 'CP' in OPTION field and default value will have 'EQ' so it was searching for the exact match for 'ZPSAC*' and hence result was null.

Now it will work perfectly alright.

Reward if resolved.

[Former Member]

Thank you for your great help, Darshil!