Skip to Content
0
Jun 27, 2011 at 07:11 PM

/SAPTRX/DELETE_EVMSG - Remove only messages for deactivated Event Handlers

100 Views

We are tracking our Sales Order process in Event management including

1. SO Create

2. ATP Date

3. PO Created

4. Inbound Delivery

4. Outbound Delivery

5. PGI

6. Shipment Complete

This can be a very lengthy process over a period of months. We are starting to really fill up the table /SAPTRX/EVM_HDR which slows down performance a great deal. We are not doing any archiving because the data we need will be loaded to BI and then the EH will be deactivated. So we are using the standard reports /SAPTRX/DELETE_EH and /SAPTRX/DELETE_EVMSG.

Finally the question...

The problem that we are having is that the deletion report for DELETE_EH looks at the inactive date on /SAPTRX/EH_HDR. However the DELETE_EVMSG does not look at the EH_HDR inactive status to make sure the messages associated can be deleted. We have set the residence time to a month but that still won't cover everything. Does anyone know if SAP has offered this functionality?? Otherwise we will have to write a "Z" report to handle all of these, or I will put in a customer message.

Thanks,

Alex