Open purchase orders

[Former Member]

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?

[Former Member]

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?

[Former Member]

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

[Former Member]

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