cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member190756
Active Contributor
0 Kudos

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

0 Kudos

Thanks Steffen we will look into the FM and get it working and try to convince others that we need the upgrade.

Former Member
0 Kudos

Steve

As per above, please can you provide BADI?

Thank you

Susheel

Answers (0)