Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OR function for filters in BEx

Hi,

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?

Thanks

Former Member
replied

Hi Kool,

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'.

ENDIF.

***just replace ZDEL_IND and ZINV_IND with the correct field name..

In your query designer, just filter using the ZDUMMY field with 'X'..

Regards,

Loed

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question