topic Re: purchase order in Application Development and Automation Discussions

purchase order

Former Member — Tue, 26 Aug 2008 07:20:06 GMT

How to get the list of open purchse orders .

I checked the field STATU in EKKO table and did not get a clear idea

please help me inn this issue

Regards

Re: purchase order

Former Member — Tue, 26 Aug 2008 07:23:30 GMT

Open purchase orders may not be assigned to a delivery or invoice.

You need to get the business description of what they call 'Open Purchase Orders'.

Re: purchase order

Former Member — Tue, 26 Aug 2008 07:29:28 GMT

hii

refer to following link.i hope it will help you

[open purchase order|http://themisto.jupiter.txstate.edu/fastrain/content/open%20po%20report/cc/html/index.htm]

regards

twinkal

Re: purchase order

Former Member — Tue, 26 Aug 2008 07:48:02 GMT

Hi,

Please check this link

Best regards,

raam

Re: purchase order

Former Member — Tue, 26 Aug 2008 07:51:29 GMT

Hi,

Check this link, you may get help-

Re: purchase order

kesavadas_thekkillath — Tue, 26 Aug 2008 08:01:29 GMT

ekpo-elikz = space

Re: purchase order

Former Member — Tue, 26 Aug 2008 08:07:03 GMT

How to get the list of open purchse orders .

Why not you used SAP standard ones?

you can use ME2L,ME2N for same.

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.

Also see WIKI code for open PO:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/list%2bof%2bopen%2bpurchase%2borders

Amit.

Re: purchase order

Firoz_Ashraf — Tue, 26 Aug 2008 09:07:31 GMT

Hi !

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.

Regards,

Firoz.

Re: purchase order

Former Member — Tue, 26 Aug 2008 09:26:03 GMT

Hi ,

in selection criteria there is WE101 and WE103 both for open PO what to use

How to get the data from ME2N tcode to my internal table?

regards

Re: purchase order

Former Member — Tue, 26 Aug 2008 09:29:38 GMT

How to get the data from ME2N tcode to my internal table?

No need to do that.just use EKKO-AUTLF field for getting open PO.

did you saw below WIKI code?

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/list%2bof%2bopen%2bpurchase%2borders

Amit.