Dear Experts,
I want to delete old process chain execution logs in the BW system,as they occupy unnecessary space in the system. I know that these logs are stored in the tables RSPCPROCESSLOG and RSPCLOGCHAIN.
In SAP BW 3.5, I couldn't find any SAP defined standard way to delete the process chain logs.In BI 7.0, there is one program RSPC_LOG_DELETE,which can be used to delete process chain logs of a particular process chain for any date range. But this will delete logs of only one chain at a time. I want to delete logs of all process chains in one go for a selected date range, e.g. logs which were executed 1 year back. Is there any SAP defined standard way to do it? Can you please provide your valuable inputs for this?
Thanks in advance for your help.
Amol