OR function for filters in BEx
I have a query and in this i need to apply filter on two characters
Let's say i have Delivery indicator values "#" and "X" and i have Invoice indicator values "#" and "X". when i select Delivery indicator "X" and Invoice Indicator "X" it is applying and giving result which is a normal behavior.
Now, what i want is when i select Delivery indicator "X" and invoice indicator "X" it should take as OR and get complete results.
Is there a way to do it?
Loed Despuig replied
I think you can do this in transformation level..
Let's call ZDEL_IND and ZINV_IND your delivery indicator and invoice indicator, respectively..Create a dummy characteristic, let's call it ZDUMMY..Then in transformation leve, map ZDEL_IND and ZINV_IND to ZDUMMY field..Then do this routine in ZDUMMY:
IF ZDEL_IND = 'X' or ZINV_IND = 'X'.
result = 'X'.
***just replace ZDEL_IND and ZINV_IND with the correct field name..
In your query designer, just filter using the ZDUMMY field with 'X'..