baanerpky
4th June 2008, 02:22
I want to print Pegging Order Relations(SFC Production Order and related sales order) on Order Covering Note in ERL LN61.

Would appreciate your faster reponse..Pl Help

csjoshi
4th June 2008, 13:42
Hi:
For the given production order number (which you want to print), and actual plan code check 'cprrp041'. Get the 'transaction number'. For this transaction number (as supply transaction), and actual plan code, from 'cprrp040' get the demand transaction. For this demand transaction number get the sales order number from 'cprrp041' based on actual plan code and transaction number.
Wish you all the best

baanerpky
4th June 2008, 20:18
Thanks for the reply.. Actual Plan Code? I checked tisfc001 and tisfc010 tables..No field like "Actual Plan code" in those tables. Would you please clarify?

csjoshi
5th June 2008, 07:22
You would get it in cprpd000.aplc

baanerpky
5th June 2008, 08:37
Thanks for your input..