Skip to end of metadata
Go to start of metadata

Issue

Purchase orders, Scheduling agreements, Contracts and any other MM document may present a considerable history that includes different types of subsequent documents: goods receipt, invoice receipt, service entry sheets, down payment documents, delivery cost documents, etc.

Purchase order history documents are saved in 2 main tables: EKBE and EKBZ. If these tables present a considerable number of entries, each time User access MIRO transaction and enter a document as reference, system will need to search in all the historic documents and this will seriously affect performance.

To check how many entries are in EKBE and EKBZ tables, follow these steps:

Go to SE17 transaction > enter the table name > fill EBELN with the document number > Execute

 

Solution

It is necessary to aggregate Purchase order history using ME87 transaction (RM06EKBE report).

Details are described in the Notes below:

311089 - Performance problems because of long PO history

574494 - Explosion the aggregated purchase order history via report

756293 - ME87 Aggregation duration purchase order history

 

Related Notes / Content

Focus is on MIRO performance

Note 756292 - Consulting: Performance MIRO Enter invoice