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