Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
I checked the field STATU in EKKO table and did not get a clear idea
Above field you mentioned this is indicator for specifying whether a quotation has been received in respect of an RFQ.
this is not for status check for PO.
Just try with field EKKO-AUTLF this is for status check for PO whether this is open or not.you can check by just their value which X means delivery completed else delivery not been placed means GR still pending.
By Open PO if you mean a PO iin which items are still to be delivered then you hav to write a report with the following logic.
Let's take an example where a PO has one item having 5 Qty to be purchased. Now if Goods Reciept has been done for 3 item and remaining 2 is yet to be delivered then.... first of all get the PO Qty from table EKPO (Say it is V_POQTY). Now select the GR qty from table EKBE with VGABE = 1.
Something like this..
SELECT belnr buzei budat menge bwart lfbnr FROM ekbe INTO
CORRESPONDING FIELDS OF TABLE i_grnt
WHERE ebeln = i_ekpo-ebeln AND
ebelp = i_ekpo-ebelp AND
vgabe = '1'.
After you get the sum of GR Qty (sum of i_grnt-menge...above) you have to subtract it from PO qty V_POQTY.
If the balance is zero then it means the PO is not open. Others that have the balance qty are open.
This way I think you can get a list of open purchase orders.
Bluesky
