Merging Purchasing Data

[Former Member]

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

[Former Member]

Hi,

Can you provide more details on your requirement?

you need this information for reporting? if its for reports, what kind of PR information is required in PO? or How you want to show the PR without PO in BW reports to show with PO without PR?

Please tell us how exactly you need output with some examples, that helps

In General, I would suggest as following

1) Create info set combing these DSO with INNER JOIN - so you get PO with PR and PR with PO. So your 2 /3 scenarios resolved [assuming in back end data loads, all PO and PR are loaded to these DSO1 / DSO2 regularly so that all PO created from PR will have PR information in DSO2, also all PR will have PO information in DSO1 once PO created]

2) Create multi provider, add new info set along with other DSO itself into the new multi provider

3) Now in query, for all key figures add restrictions so NOT to duplicate values as following

RKF to show PR without PR from PR DSO 1

RKF to show PO without PR from PO DSO 2

KF from InfoSet directly

If you combine all of these three values, you should get exactly what you are expecting.

Make a note , I provided this options considering general assumptions, so let us know your full reporting requirement if above steps doesn't solve your concern.

Regards,

Arun