ME87 RM06EKBE Question

[Former Member]

Hi,

   Does anyone have documentation on how ME87 and purchase history table archiving works?  I have read all the OSS notes and discussions that can be found but not seen anything that tells how the logic works.  We've been testing and understand that it aggregates purchase history receipts and invoices but not sure what is the criteria for determining which records get added to EKBEH and removed from EKBE.  We had assumed that it did an aggregation then wrote all of the EKBE records to EKBEH but this doesn't appear to be the case as EKBEH only contains those purchase history records where there are a large number (>4?) EKBE records.  Any thoughts would be appreciated.

Thanks!

[Former Member · Accepted solution]

The following note gives the criteria for aggregation:

311089 - Performance problems because of long PO history

[Former Member]

Hi thanks for the notes, I went throught these.  They don't tell me what I'm wanting to know which is what determines which records are written to the    EKBEH table after aggregation and how aggregation works.  I can test ME87 in test system and see that even when it does an aggregation it doesn't always write the records to EKBEH.  So I am trying to find out HOW it aggregates and what the criteria is for writing records to EKBEH.  I have read a lot of notes and can't find this information anywhere.  Thanks!

[JL23]

It is already in ME87 selection screen where you define the threshold above which the history is written.

but you already restrict it in field below, that this level must have been reached before a certain date.

The OSS note given my Manosij Basu explains further criteria which have to be fulfilled before an aggregation is carried out.

Why dont you give a real case as an example where you struggle to know why SAP did not aggregate so that we can explain it on this basis for a better understanding.

[Former Member]

Hi Jurgen,

  It must have been the way I was doing something.. naturally when I was documenting this to show you the problem then it is working okay and writing the aggregated records to EKBEH.

[frank_schttenberg]

This message was moderated.

[Prasoon]

Hi,

   In addition to the note  311089  suggested by Manosij Basu, you may check the notes:  417933 - Consulting note on purchase order history records ME87 , 756293 - ME87 Aggregation duration purchase order history and the KBA: 1596184 - ME87 does not aggregate PO data

Regards,

AKPT