Skip to Content
0
Former Member
May 10, 2005 at 04:36 AM

Anding of the Input Variables in a BEx Query

14 Views

Hello,

I have following scenario: If the report is executed by user1, then one set of shipto's should be visible (also if that user enters a valid shipto, then only that should be visible) AND if the report is executed by user2, then any shipto's should be visible.

If I take two input variables for Shipto, one of them I give to user for input and the other I populate in the exits (I_Step = 1) by checking the user type and populate the 2nd input variable accordindgly then the list of shipto's for that user is given.

The PROBLEM occurs when the user also enters a Shipto, then the Output shows: List of Shipto's derived thru the exit plus the ones that user has entered, WHEREAS it should be that if the user has entered a Shipto then only that should be visible, i.e. it should be an 'AND' operation not 'OR' between two variables.

I hope this can be achieved by some way. If you have an idea about the same, it will be of Great Help.

Many thanks for your help.

Best Regards,

Sumita