on 06-27-2011 8:11 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.