Merging Supply Chain Data

[shama_parween]

Hello All,

I have requirement to merge the SCM data(Purchase orders) with the Work Order and Operation Number.

We want to use Work Order Number and Operation Number to get the related SCM data.

Can you please suggest which fields from the SCM(other than Work Order) can be used to get operation level data.

Regards

Shama

[Former Member · Accepted solution]

Hi Shama,

Are you looking for a report which will show purchasing and work order data together?

[shama_parween · Accepted solution]

Hello Shreyas,

Thank you for the response.

Yes, I am trying to design such report in BW.

Regards,

Shama

[Former Member · Accepted solution]

Purchase order against a work order can be for an external service or an external material. Standard process first creates a purchase requisition which is the link between work order and purchase order.

In addition to work order You can look at fields like below for external service

1) Operation number (against which the purchase requisition is created)

2) Purchase requisition

3) Operation description

4) Gross Price

5) Number of resources (multiplier)

6) Net price

7) purchasing group

In addition to work order You can look at fields like below for external material

1) Operation number

2) External material number (if any)

30 External material Description

4) Purchase requisition

5) Gross price

6) Quanity

7) Net price

😎 Purchasing group

9) vendor

[shama_parween · Accepted solution]

Thank you so much for the help. I ll try designing this logic.

Regards,

Shama