How to segragate Manual PO from PO created thru MRP

[former_member212181]

Hi All
1) How can i know, one Purchase request \ Quotation \ Purchase order \  Stock transfer request \ Production Order is created thru manually or thru MRP.
2) And I'm not able to find any link between SO and PO (base document and target document) while PO is created thru MRP wizard cum order recommendation.

Regards

Unnikrishnan

[Former Member · Accepted solution]

Dear Unni,

Please check the origintype field in OPOR table....

i think if it is 'M'=Manual

otherwise it is 'R'

Regards

Ajith

[former_member212181 · Accepted solution]

Dear Ajith
Thanks for reply.
I tested below cases
1) Created PO by key in all details manually; Result : Origin Type is M

2) Created PO thru MRP; Result: Origin Type = R 
3) Created PO thru duplicating PO which created thru MRP wizard ; Result : Origin Type = R
4) Created PO thru Procurement confirmation wizard; Result : Origin Type = S
5) Created PO thru duplicating PO which is created thru procurement confirmation wizard; result origin Type = S

So i doubt reliabilty of this field.
Anyway, many thanks
Regards

Unnikrishnan

[former_member197621]

Hi ,

Efficient way is , create a separate series and Map it in ORDER recommendation.-> Form Setting

->Document

This will help you in below ways,

1. Finding the PO
2. Help you while write query report
3. Through Series -> Group -> authorization you can control the user to avoid the PO modification.

[former_member212181]

Hi Prasanna
Thanks
But this wont help me as client need to continue all purchase orders in same series itself.
Even they are having only one series for the entire DB per form.
If the purpose of "Origin Type' is to separate manual\ procurement wizard \ MRP wizard, then its a Bug in SAP , that its not been updated while duplicating.

Regards

Unnikrishnan

[Former Member]

Did you check MSN5 & MSN2 Tables

Cheers

Sandeep