You can create a query or simple report program for this purpose. The tables you will need are :
PR data can get from EBAN
PO data can get from EKKO + EKPO
GR data can get from MKPF + MSEG
IR data can get from RBKP + RSEG
And PO history from EKBE
To generate a report from SAP, you need to follow a few steps. First, navigate to the Definitions → Reports section and choose “New” from the context menu. On the Report tab, fill in a name into the Name field and choose a filter name in the query. Then, enter the Directory, File Name and click “Generate” to create the report. Once the report is generated, it must be saved. Z reports are created when the client’s reporting requirement cannot be fulfilled with the SAP standard report. In such cases, a functional consultant’s role is to create the Z report to meet the specific requirements of the client.