Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 28, 2011 at 07:18 AM

    Hello Alex,

    as /SAPTRX/DELETE_EVMSG was more thought as a program to delete test data there is no option to do it.

    But in the standard archiving program for Event Messages you can do this check for still existing EHs with a Plug In function.

    Yiu can create the plug in function in TR /saptrx/restm similar as other functions in EM.

    In EM 7.01 a standard BADI implementation is available for the new archiving reports that is allready doing this check.

    So in principle i would recommend to use the archiving reports instead of the only deletion reports. In case anything went wrong you have the possibility to reload the data If you really don't need the archived data you could just drop the archive files later.

    Best regards,

    Steffen

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.