Variable user extit using patern

[Former Member]

Hello,

I've a issue with my variable. I want to select all the transaction ID without 'TD'.

I created a variable ZVAR_TRAN with the caracteristic below:

- Processing by: User exit

- Variable represent: Selection option

- Variable is optional

- Variable not ready for input

- No default value

In my user exit, my code is:

When 'ZVAR_TRAN'.

     Clear l_s_range.

     l_s_range-low = '*TD*'.

     l_s_range-opt = 'NP'.

     l_s_range-sign = 'I'.

     Append l_s_range to e_t_range.

Using RSRT to check my report, I've a error message:

Invalid filter on ZTRAN_ID

System error in program CL_RSR_REQUEST_LISTCALCULATION and APPEND_FAC_TO_SLICER...

Could you please help me o resolve this issue?

Best Regards

Rico

[Former Member]

Hi,

Why are you creating variable. Variable is not requried for this.

you can directly define it in your query.

1. drag Transaction ID in your filter tab in characteristic restriction

2. right click -> Restrict

3. select single value

4. write *TD* in "Direct input" in the below part

5. then just press -> arrow key

it will automatically convert it as [x] *TD* after moving it right side. then right click and exclude selection as you want to exclude it.

you can achieve it this way.

Regards,

Dipti

[yasemin_kilinc]

Hi Rico,

you can also use  l_s_range-opt = 'EQ' and then in bex query you can exclude from selection.

Yasemin.

[Former Member]

try replacing the * with a %

[Former Member]

Hi Raf

Thank for your answer. I tried % but it doesn't work

Best Regards