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

Hello,

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

Legend:

GB (Britain)

FR(France)

CH(China)

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.

Question:

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?

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