How to consolidate the data of Sales Order Header DSO and Sales Order Item DSO into another DSO

[Former Member]

I have a Sales order Header DSO, Sales order Item Dso. I need to consolidate all the date into a final DSO.

The Key of final DSO is sale document and sale item document.

When I load the data from Header DSO and Item DSO into final DSO, I am getting mulitple lines of data for a single order.

EX : Order in Header DSO is 1000

Sales order item DSO is 1000, item 10,20,30.

Final DSO output:

1000 .....

1000 10

1000 20

1000 30

Not sure whether the above output is correct...Please let me know how to solve is. if a code is needed to solve please give me the code in step by step process with the explanation, so that it will be useful to me in future.

Thanks in Advance for your kind time.

Rajesh.

[Former Member]

No idea why to use a final DSO for header and item information.

Why not using a simple multiprovider (only for the fields which are in the header DSO) or composite provider. This should also work and makes things easier.

Otherwise use an infoset, check out page 17 and forward:

http://www.sapbwconsulting.com/hs-fs/hub/118735/file-16662398-pdf/docs/multiproviders_and_infosets.p...