List of completed POs with compare all line items

[former_member183424]

Experts,

I need a report where I can see the all completed POs. I can see this from ME2N/ME2M/ME2L.... report. But it is considering the line items. I need to fetch these POs which has completed GR for all line items.

As an example,

I have a PO with 3 line items with qty 10, 10, 10. GR has completed for first 2 line items as 10, 10. But GR has done only 5 qty for 3rd line item.

Then I'll not consider this as complete PO as GR has not done completely for line item 3.

I've checked the selection parameter for report ME2N/ME2M/ME2L....., but it is considering the line item.

I've set the selection parameter as below :

With that, I am getting the line item 1 and 2 as completed PO. But I don't want to show that PO also because GR has not done completely for line item 3.

In short, I want just those POs whose are having "Fully Delivered" status in Header - Status tab (without comparing by line item).

[Prasoon · Accepted solution]

Hi,

   All the standard reports will consider the delivery completion at item level only. As of my knowledge, there is no standard reports which will show the consolidated header level status. Either you may download from ME2N and consolidate the status in excel - (pivot table or similar method) or you may go for a custom report.

   If you are going for development, you may use the FM: BAPI_PO_GETDETAIL and get the GR details from the structure PO_ITEM_HISTORY_TOTALS.

Regards,

AKPT

[former_member183424]

Thanks experts, I've prepared this report with help of ms excel.

I've created a blog with my experience and views .

[JL23]

A way to list completed POs without doing ABAP could be to run archiving in test mode, with a detailed log.

[former_member183424]

3 things:

1. Invoices has not done yet for these PO numbers.

2. I can't able to see the Vendor field (selection) for archive selection.

3. Changes (GR) may be done recently (within 1 or 2 week) for these POs.

Actually I need this report for doing invoice. My organization does the invoice when a PO number get totally GR completed. They will not do invoice as per line item, they will do it as per PO.

Their requirement is how many PO numbers got completed for a vendor xxxxxx till now.

[JL23]

I don't think you will find any report meeting this requirement to a 100%, especially as SAP is calculating this header status dynamically when you open the PO and is not storing it somewhere in a table.

An ABAPer would need to rebuild this logic

[Former Member]

You can use ME2N/Dynamic selections/Purchasing Document Header/Complete Delivery.

If you choose Yes(X) in this field then system just shows the POs which are fully delivered. I mean all the items are delivered.

[JL23]

The field AUTLF for delivery complete at header level  has no function and is hidden for this reason already for a long time, see oss note 31663 for more details