Skip to Content
0
Former Member
Feb 16, 2009 at 09:14 PM

Report on Master data attributes comparison

53 Views

Hello All,

Scenario: I have a master data object getting loaded with 2 attributes for that Master data object,

Master data Object - Material

Attribute 1 - Region 1 &

Attribute 2 - Region 2

So the data is somethign as below:

Material Region1 Region2

12345 NW SW

23456 SW SW

34567 EA WT

Now we want to create a BW Query, wherein we want to say, Fetch me all the Materials where the Region 1 <> Region 2.

Thereby getting only Materials 12345 & 34567, since the Region1 & Region2 are not same.

Question is: Is this possible in BW. Can I compare two attributes on the same Master data object and get results in a Query??

Early response would be appreciated.

Regards

Rohit