topic Re: Open purchase orders in Application Development and Automation Discussions

Open purchase orders

Former Member — Sat, 10 Sep 2005 10:33:28 GMT

Hello gurus,

Can anyone tell me how to find the open purchase orders for a material? I found the table EKPO. There I can see the purchase orders for a material. Then I found the structure RM06A with the field OWEMG (undelivered quantity). How can I put that data (from the structure) in a report?

Re: Open purchase orders

Former Member — Sat, 10 Sep 2005 10:51:31 GMT

Hi George,

I don't have access to my SAP instance at the moment, so I can't tell you the exact field names. But you can look for following three fields in EKPO -

1. Deletion Flag (If item is deleted, it is no open).

2. Delivery completion indicator.

3. Invoice completion indicator.

now depending on you definition/understanding of open order you can check these.

Cheers,

Sanjeev

Re: Open purchase orders

Former Member — Sat, 10 Sep 2005 11:33:21 GMT

hi, you'd better aware that the delivery is for item level, not header level.

some flag for a open purchase is list as following:

1. PO Header deletion indicator (EKKO-LOEKZ) = Blank

2. Subject to Release (EKKO-FRGRL) = Blank

3. PO Line item deletion indicator (EKPO-LOEKZ) = Blank

4. Delivery Completed Indicator (EKPO-ELIKZ) = Blank

EKKO is for PO header, EKPO is for PO item.

hope it will be helpful

thanks