Skip to Content
0
Former Member
Oct 28, 2009 at 01:13 PM

How to combine header and line item characteristics in DSO

371 Views

I have a need for a DSO that is keyed off a combination of sales document & item number. I need to preserve the line item granularity, but I also want characteristics from my header records. For each of my line items for an order I would like to have characteristics like doc_date, doc_type, etc. My current architecture has an order item DSO and an order header DSO.

However, I obviously don't have the line item part of the key for my target DSO when using my order header DSO as a source. What is the best solution for getting order header characteristics associated with all line items for a given order in my DSO?