Merging Purchasing Data

43 Views

Hi,

I need to merge purchasing documents. I have two DSOs:

1. DSO 1 with purchase requisitions (key fields: #PR, #PR item; data fields: #PO (if any), #PO item)

2. DSO 2 with Purchase Orders (key fields: #PO, #PO item; data fields: #PR (if any), #PR item)

I need to maintain into this merged structure all following purchase documents:

- PR without an associated PO

- PR with an associated PO

- PO created with reference to a PR

- PO created without reference to a PR

An infoset with a left out join relationship between DSO 1 (first) and DSO 2 by using "#PO" and "#PO item" does not meet the requirement because it would keep out PO created without reference to a PR.

An infoset with a left out join relationship between DSO 2 (first) and DSO 1 by using "#PR" and "#PR item" does not meet the requirement because it would keep out PR that don't have any PO created yet.

What kind of structure would you recommend for this situation?

Thanks in advance.

BR,

Ana