I would like to know, how to identify manual Purchase orders in SAP. I need to get the following lists
i. Purchase orders created manually not through MRP process
ii. when a PO is created by converting a PR if additional lines are added in the converted POs
iii. If quantity changed in the POs which are converted from a PR
I actually analysed the tables EKKO, EKPO for Purchase orders and EBAN for Purchase requisition. In the EBAN table there is filed to identify purchase requisition which are created through MRP process. (If EBAN_ESTKZ= ”B", it is created thorugh MRP Process).
However, there is no such fileds in EKKO, EKPO tables and Im in a need of your help. Is it possible to analyse these tables to get a list of manual POs.
I guess you can check the status field in the EKKO table to find out whether PO's are created manually or automatically via PR conversion.
i.e. the status will be B - Purchase Order from Automatic Conversion of Requisitions or 9 - Enjoy Purchase Order.
Also if you are using a background job for scheduling the PR-PO conversion with a different user-id.
You can differentiate the manual and auto-converted PO based on user-id.
Thanks n Regards,
You can refer the Table field EKKO-STATU to check how the Purchase order was created.
For example, check the following statuses.
B Purchase Order from Automatic Conversion of Requisitions (Auto PO conversion from PR)
C Purchase Order from Goods Receipt (Auto PO)
I Purchase Order from BAPI (PO created through a BAPI BAPI_PO_CREATE or BAPI_PO_CREATE1 (Enjoy)
X Purchase Order Created via Function Module (Created through Transportation module)
9 Enjoy Purchase Order (Manual PO)
Thank you everyone. I think this gives the solution to my issue. However, I checked with two tables of EKKO of two different companies. One company had only "9" in the filed and other company had "9" and blank in the EKKO_STATU filed.
Its is highly unlikely that the company which had "9" create purchase orders only manually. (couldnt confirm this from the Business users).
And then what does it mean if EKKO_STATU filed is blank.