Identify Manual PO

[Former Member]

Hi everyone...

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.

[former_member192897 · Accepted solution]

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)

[Former Member · Accepted solution]

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.

[former_member192897 · Accepted solution]

EKKO-STATU will be blank if you Create a Purchase order from old transaction ME21. If you Create a Purchase order from Enjoy transaction ie ME21N the EKKO-STATU will be set to 9. Just check once.

[Former Member]

Hi,

   As ASHOCK & SAMIR tolled

   to Identify manuval POs EKKO table STATU field based you you find the manual POs, atomatic POs through PR....

SE16 tcode  enter EKKO table exicute in selection screan toy take STATU field now you fill that STATU field as per you requermant.

H F U

[former_member213924]

Hi,

Check EKKO-STATU field which tell you the status of PO created:

it will show status "9: Enjoy purchase order" if it is created manually.

it will show status "B: Purchase Order from Automatic Conversion of Requisitions" if PR automatically converted to PO.

[Former Member]

Hi,

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,