Skip to Content

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

Intelligent modelling question for real BI people

Notification Notif-itme Matl Plant Vendor Source Customer Notif-counter Defect

1000 1 4RA 100 Manuf 5000 1 Kink

1001 1 4RA ABC Purch 5001 1 Break

1002 1 5RA 300 Manuf 6000 1 Kink

Deliv Deliv-item Matl Customer Deliv qty

8000 1 4RA 5000 10

8001 1 4RA 5001 30

8002 1 5RA 6000 50

Manuf: Manufactured

Purch: Purchased goods

ECC LO Data sources: 2LIS_05_0QITEM (for notification) and 2LIS_12_VCITM (for deliveries)

DSOs: Notification DSO and Delivery DSO.

My reporting reqmt needs to combine both DSOs. Only Material, Customer and Batch nos are common in both DSOs.

KPI: Notification counter / Delivery quantity.

Drill downs can be any.

I know that multiprovider on DSOs will show data as shown in above table.

I want all data to come in same row based on material, batch and customer. Can I solve it by using Infoset or APD.

Is there alternate solution for modeling.

Please help.

Thanks

Shankar.

Edited by: Shankar Shankar on Sep 12, 2008 3:02 AM

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