cancel
Showing results for 
Search instead for 
Did you mean: 

BEX query unable to filter data based on values passed in customer exit.

Former Member
0 Kudos

Hi All,

I have created a customer exit on a field in BEx query and the setting is 'INCLUSION'.

I want to limit the values passed in the field based on my logic in customer exit.

Based on the logic execution I am appending my 4-5 values to E_T_RANGE internal table with following values

wa_t_range-sign = 'I'.

wa_t_range-opt = 'EQ'.

wa_t_range-low = 'XYZ'.

append wa_t_range to e_t_range.

wa_t_range-sign = 'I'.

wa_t_range-opt = 'EQ'.

wa_t_range-low = 'ABC'.

append wa_t_range to e_t_range.

When I execute the query in RSRT, it is unable to filter data correctly i.e. it is not restricting selection to XYZ and ABC. But returning all values.

My requirement works with 'EXCLUSION' but it is hampering my performance. Hence I have to work with 'INCLUSION' and pass value only which are needed.

I am running on BW 7.4 SP09. Do I need to apply a note or anything ?

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Rujuta,

What exactly are you trying to achieve?

  • Restrict the values that are displayed to user when clicked on F4.

OR

  • Take input from user and then restrict the result of query based on the values entered by the user.

OR

  • Display some default values in the field when query's selection screen is displayed.

All three use cases would need 3 different approaches.

Regards

Loed
Active Contributor
0 Kudos

Hi,

I think you need to add another value which will give a NO DATA to your object.

For example, aside from assigning XYZ and ABC, you should also add the value # so that whenever there is no XYZ and ABC values your query will still run with # value which will result in NO DATA. Because if there is no XYZ and ABC in the report, all values will be shown as if you filter nothing.

Regards,

Loed

DoanManhQuynh
Active Contributor
0 Kudos

if you want to restrict data there are 2 ways:

1. using analysis authorization and assign to users.

2. using F4 restrict value exit, follow below instruction

https://archive.sap.com/kmuuid2/4009b0a8-7adc-2e10-48b3-a111c8f407af/Restricting%20F4%20%28Input%20H...

what you are doing now is just set default value

Former Member
0 Kudos

Hi Quynh Doan Manh,

Let me try your suggestion.

Even if the above logic is executed at i_step =2 , am I only setting default values then ?

And somehow the above logic works with exclusions but doesn't work for inclusions.

thanks,

Rujuta

DoanManhQuynh
Active Contributor
0 Kudos
I dont know for sure about exclusion and inclusion but I think for default if you exclusive something then it wont display again but you including something it doesnt mean you exclusive other values.

i_step = 2 is after user input so i think it dont have affect that you want. the restriction should be authorization or F4 help restriction, it easier and achive what you want.