Skip to Content

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

Lookup two objects list values in one object are not in the other object

Hi,

I have two sources of reference numbers that ties our whole system together. Let's call them RefCodeSystemA and RefCodeSystemB. I would like to build a webi report that shows the Values in RefCodeSystemA that a NOT in RefCodeSystemB. I can easily find out the matching ones but not the NON matching onces?

Any suggestions on a simple query to do this?

Former Member
Former Member replied

Hi Galvin,

Hope you can use the Minus at the Query pannel.

We have Union,Intersection,Minus hence you can get it from that.

Please let me know if you need details for this.

Regards

Prashant

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question