Skip to Content
Author's profile photo Former Member

Advanced DSO’s changelog deletion

SP8 for SAP BW 7.4 has introduced BW’s newest modelling object: the Advanced DSO. The Advanced DSO is BW’s new major modelling object that  plays a central role in any SAP BW on HANA data model. It is used as a classical DSO, info cube, PSA or write optimized DSO. The Advanced DSO manages to replace all of these objects by basically being all of themWhen creating the Object you have to decide about the properties the Info Provider shall have.

Sometime we choose Classical DSO option for  data provision to next layer and so change log table comes into picture. One thing missing at the moment is the possibility to delete the Change log via process type. But according to SAP this functionality is to come in future ( may be BW 7.5 ).

At this moment, it is possible to do the deletion manually to delete the requests manually in the manage UI but no workaround to delete in batch. However, SAP has recently come with a workaround.

After implementation of this note #2253065, program “RSDSO_REMOVE_REQS_PC “ will be available in your BW on HANA system . This program internally calls Function Module M “RSDSO_REMOVE_REQUESTS_API” to delete change log requests in batch.

Take an example, DSO “Z_TEST” ADSO contains 13 change log requests.


We run program “RSDSO_REMOVE_REQS_PC” for ADSO “Z_TEST” with age 15 days


All change log data older than 15 days are deleted now.


We can create an ABAP variant having ADSO name and age of requests to be removed.

We can use this ABAP program and variant in process chain using ABAP process type to automate change log deletion via process chain.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo B. ATM
      B. ATM

      Waiting for this functionality. Thanks for sharing,

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.

      Author's profile photo Siva Sankar Reddy Sanepalli
      Siva Sankar Reddy Sanepalli

      Hi Dhiraj,
      Thanks for post. We are facing issue with PSA deletion which is updating data to ADSOs. We have added the DS to process chain variant to delete history data older than 8 days from PSA. Can you please help here.