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

Open Purchase orders

Former Member — Fri, 16 Mar 2007 13:15:48 GMT

Hi,

I have to report OPEN PURCHASE ORDERS.

1. How can i know the particular PO i relevent to GR or not.

2. If it is relevent to GR then how do i know GR done/created or not.

3. At the same time Invoice receipt also.

Please some one give me the table and fields for the mentioned scenarious.

Thanks,

Deepak.

Message was edited by:

KDeepak

Re: Open Purchase orders

Former Member — Fri, 16 Mar 2007 13:22:50 GMT

Hi,

To prepare the Open PO report:

Take all the purchase order details from EKKO and EKPO tables by writing a JOIN based on the selection screen paramters:(into ITAB)

Then fetch the related GR and GI data from the table MSEG for each PO Item (using for all entries of ITAB passing EBELn and EBELP to MSEG).

Here based on the movement type you have to consider the GR or GI.

generally for 101 movement types it is fresh GR(goods receipt).

so in this table MSEG you have many entries with different movement types for each PO items, so summing up the correct quanitities(ERFMG) for GR and other s is importants.So from ITAB you know the PO qty for a particular PO and from MSEG you know the qty received(GR QTY), if the both qty's are equal then that order is closed, if bothe qty's are not equal then that order is OPEN.

Fetch the invoice related data from EKBE or RSEG tablse passing EBELN and EBELP fields for them.

GR dat is in MSEG

and Invoice data is in EKBE or RSEG.

Hope this is useful.

regards,

Anji

Re: Open Purchase orders

Former Member — Fri, 16 Mar 2007 13:40:59 GMT

Hi Thanks for the reply....

But how can i get whether the particular PO is related to GR or not.

Thanks,

Deepak.

Re: Open Purchase orders

Former Member — Fri, 16 Mar 2007 13:54:45 GMT

Hi Deepak

Table EKBE is your friend! It contains the Purchase Order lines and the various Invoices / Goods Receipts / Services, etc. against them. Use field VGABE to determine the type.

Cheers

Lyal

Re: Open Purchase orders

Former Member — Fri, 16 Mar 2007 14:23:43 GMT

Hi All,

Here I am unable to map the tables for INVOICE RECEIPT when i have GR.

Please help me in out.

Thanks in advance.

Deepak.