Skip to Content

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

conditional query (OR) on set of characteristics but not (AND)

Hi,

Is it possible to do the following in a BEx query?

query wiht 4 characteristics (A,B,C and D) defined in rows.

I need to get results with conditions on B, c & D characteristics.

query should bring records of all where either B, C or D characteristic value is blank.

How do i achieve this?

Let's say, I've following records

A B C D

=======

  1. 2 3 4

1 2 3 4

1 # # 3

1 # 2 #

2 6 7 #

query should bring following records where atleast one of the 3 chars (b,c,d) are blank.

A B C D

=======

1 # # 3

1 # 2 #

2 6 7 #

Appreciate your help.

thanks,

Hari Immadi

http://immadi.com

SEM BW Analyst

Helpful Answer

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