Skip to Content

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

Query help

I have 2 DSOs:

DSO # 1:

Key Field - Deliv no and Deliv item

Data field - Material, Batch, Serial no, Customer, Delivery quantity, Delivery type and delivery date

DSO # 2:

Key Field - Notification no and Notification item

Data field - Material, Batch, Serial no, Customer, Complaint quantity, Notification date.

Based on these 2 DSOs, we have a cube containing all characteristics and key figures mentioned above.

Query requirement on cube:

Variable selection: Material, Customer, Notification date, Delivery date.

As long as Material and Customer are selected in variable screen. query should work fine.

But what if user selects notification date range or delivery date range. Data will show separate lines for Notification and Delivery data.

How do I create query for this type of data.

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