Skip to Content
0

Merging Supply Chain Data

Oct 02, 2017 at 03:30 PM

57

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Oct 02, 2017 at 03:54 PM
0

Hi Shama,

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hello Shreyas,

Thank you for the response.

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

Regards,

Shama

0
Former Member

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

8) Purchasing group

9) vendor

0

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

Regards,

Shama

0