Question:
Dear All,
We have BIW 3.0 B and SAP 4.6c.
We have extracted the Sales Header and Sales Item Data using the new extract structure. We are getting one sales order record + multiple Sales Item Records. How to combine the corresponding Sales Order and Sales Item records into one sales order-Item Record.
Please excuse me if this question looks very naive.
Thanks in advance
Velu
Answer:
I don't know what you want to report on, but I guess main important and valuated informations are coming from Sales Item ... Just make a multiprovider ?
If the question is to report on different things, you can also think about Report/Report Interface.
Bye
Answer:
Consider introducing an underlying ODS, with keyfields 'sales order' and 'sales order item'.
The objects in your ODS are similar to those in your cube.
David
Answer:
Thanks to Fred and TapKap for their tips.
I am working on it by creating a ODS and feeding the ODS thorugh multiple(2) InfoSources. I will soon post how it went.
Thanks
Velu