Skip to Content
0
Former Member
Apr 13, 2005 at 05:45 PM

Complex BEX Variables with CMOD

97 Views

Hi,

I am trying to generate AND and OR condition for 5 products in my transactions. I have 5 product fields for each transaction. I should be able to have 2 selection variable filter and based on that selection i should be able to get only those records that have both the selected filter variables in any of the 5 products.

Variable 1 - 123

Variable 2 - 345

SAMPLE DATA :

TransID  Prd1  Prd2  Prd3  Prd4  Prd5
001      123   234   345    -     -
002       -    234   345    -    123
003       -    657   876    -     -
004      123   098    -    246    -
005      123    -     -    345    -
006      333    -     -    222    -

I should get only the result with TransID 001,002,005 because it had 123 and 345 in any of the 5 Products

I am able to generate results with OR condition showing only TransID 001,002,004,005.I handled this scenario with 5 customer exit variables based on 5 produts and 2 selection variable and retrieving the data and populating the 5 customer exit variables.

Any brilliant idea will be fully rewarded.

Thank you

Arun