Skip to Content

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

Design to Report on 2 conflicting Objects in the Same InfoCube


Please I have a problem with developing a suitable data model that can give me my desired data out.

This is my scenario:

Sales Data Line:

Company Code: Country: Country of Final Destination: Amount

001 GB GB 100

001 GB FR 100

001 GB FR 100

002 CH FR 100

002 CH CH 100

002 CH GB 100


GB (Britain)



There are 2 views to this data set. The Country view (Sender) and the Country of Final Destination (Receiver).

Sender view for GB sales is = 300

Reciever view for GB sales is = 200.


How can I in one query report 300 and 200 at the same time. I am also interested in the difference of 100.

So I want to see the Sender View and the Receiver View in the same query?

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