How to check in a report the last approval date in a purchase requisition?

[former_member247962]

Is there any standard report to view the last approval date in a purchase requisition?

I need to check the last date that a purchase requisition was approved, even in case that it went back to approval after some alterations. Is it possible to view it using just ME5A? Thanks, Daniel A.

[former_member540826]

Check the report ME5A. Go to the dynamic selection. Select the release date from the selection options if it is not already displayed on the selection screen. Execute the report for the Purchase requisitions with the dates filled in the release dates for the required span.

[Prasoon]

Hi,

This is a common mis-understanding with the field "release date" in PR or EBAN table. The "release date" in PR doesnt have any relation with the release strategy. The "release date" field in PR means the date on which the PO should be initiated to cover the requirement based on the delivery date. You may check the F1 help for the field which explains in detail.

For the approval date, we have to check the change history. This can be done by checking the individual PR change status or through the report AUT10 transaction (and press F9) with the below inputs:

In the output, you can put a filter with BANPR new value as '05', which represents final release. Please note that the report will give you all the change logs.

If it doesnt suite your requirement, you can use the FM: ME_CHANGEDOC_READ and develop your own custom report.

[BijayKumarBarik]

Refer table CDHDR for PR release date, releaser along with t.code for release for your PR or else refer release date details as changed date in t.code ME53N for your PR with selection of Environment data in Menu bar

[JL23]

The current status can be seen in the documents, the approval date is only captured in the change history, which is one of your largest tables in your SAP system, so it should be avoided to read it in reports that are frequently executed. I am not aware of any standard purchasing report which can give you this information. If you have to investigate a certain case then check the history of a single document via the environment menu in the ME53N.