How to find all Open POs and PO status

[Former Member]

Hi,

1. If I open any PO (we are on ECC6.0), on the PO header status Tab, we can see the status as "Fully Invoiced or Partially Invoiced or Not Invoiced" and similarly for delivery too. Is there any table to see get these statuses directly for any given PO?If no, How do I determine the status manually in the report ?

2. If you get into a PO, follow the menu path Environment-->AC Commitments docs. Choose Funds Management from the Pop-up. This shall generate a report for the document Jounal entries and display the final amounts (final bdgt) there. Is there any table where I can get this amounts for a given PO?

I want to generate a report for all the Open POs based on the different statuses from point 1 and also where its AC Commitments-FM docs amount is not equal to 0.

I checked with my MM consultant for this and he couldnt be of help.

Thanks

Kiran

[Former Member]

Hi kiran,

if u want find whether P.O is open or not , check the field ELIKZ (billing completed)in EKPO table.

if above field is space then P.O is open and not Billed.

Thanks

Sai

[amit_khare]

Are you looking for Table EKBE?

[Former Member]

I think the PO history table is what you need for #1.

You can use ST05 to figure out what tables are hit for FM.

Rob

[Former Member]

But how can I figure out from EKBE or PO history?

Do I need to compare the quantities from PO & invoices? If yes, what is the case, if there are multiple accounts for a same line item?...will calculation not be very tedious?

Is there any direct shot I can hit to get the status for a given PO and given line item which says....Full Invoiced or Partially Invoiced or Not invoiced and similarly where do I go for delivery statuses?

Thanks

Kiran

[Former Member]

Hi Kiran,

I think there is no way to get the direct status like Sales VBUK or VBUP Tables...

But here for PO it is a manual calculation....

EKET, EKBE, EKKN...! The customisation depends on your requirement,,,!

these three tables got all the values to know about the status..!

Thanks & regards,

Dileep .C

[Former Member]

Well, I have 4 use cases to determine all open POs. So how do I go and what tables to hit to get all those open POs. I only need F type..not worried about contracts or any other order types

1. Fully Invoiced & AC Commitments documnets -> fund managements. There amount > 0.

2. Partially Invoiced & Last GR date <= Input date and Last IR date <= Input date

3. Not Invoiced, or partially received or fully delivered

4. GR status = Not delivered, Invoiced status = Not Invoiced.

Thanks

Kiran

Edited by: kiran dasari on May 13, 2009 10:09 AM

[Former Member]

Hi,

It is more related to functional prospective, if u find any MM consultant. He will resolve all your issues

[Former Member]

Any more clues plz...

[Former Member]

EKKO - FRGZU

IF X THEN RELEASED ELSE NOT RELEASED

[Former Member]

Hi,

Check table EKBE, it will give you the history and current status of PO

and Take a look at transactions ME1P and ME$0.

[Former Member]

Which field in EKBE will tell the status like FULLY INVOICED or partilly etc...

Thanks

Kiran

[Former Member]

>

> But how can I figure out from EKBE or PO history?
> 
> Do I need to compare the quantities from PO & invoices? If yes, what is the case, if there are multiple accounts for a same line item?...will calculation not be very tedious?
> 
> Is there any direct shot I can hit to get the status for a given PO and given line item which says....Full Invoiced or Partially Invoiced or Not invoiced and similarly where do I go for delivery statuses?
> 
> Thanks
> Kiran

Yes - it is tedious, but that is what we are paid for. You have to look at each line in the PO history table (EKBE), add up the invoices, subtract the returns. There are also some flags mentioned by other posters to determine whether the PO (or PO item) is complete.

Rob

[Former Member]

Yes. I am coding and can you plz give the logic.

Thanks,

kiran