6 Replies Latest reply: Dec 13, 2012 5:22 AM by Ashok Kumar Telugu RSS

Identify Manual PO

Chaythree P
Currently Being Moderated

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.

  • Re: Identify Manual PO
    SAP FC
    Currently Being Moderated

    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,

  • Re: Identify Manual PO
    Samir Rana
    Currently Being Moderated

    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.

  • Re: Identify Manual PO
    Ashok Kumar Telugu
    Currently Being Moderated

    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)

    • Re: Identify Manual PO
      Chaythree P
      Currently Being Moderated

      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.

  • Re: Identify Manual PO
    veeraprathap kankanala
    Currently Being Moderated

    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

Actions