You can edit existing data subscriptions after you have created them. This allows you to still adjust the settings of a data subscription after initial creation. To ensure the system remains clean and operates efficiently, you can delete a single data subscription or perform mass deletion.
Editing Data Subscriptions
There are two ways to edit a data subscription:
- In the SAP BW/4HANA Cockpit, use the Data Subscriptions app .
- In SAPGUI, use transaction RSDPS.
The settings you can change depend on the status of the data subscription.
After you have created the data subscription, but when it's not run yet, you can still edit:
- Description
- Process Chain Variant
- Extraction Mode
- Projections
- Selections
Once you have run the data subscription and the local table (file) has been created and deployed, you can only edit the description and all other fields become read-only and cannot be adjusted anymore.
If you do any changes, you have to activate the data subscription again, so that the A (Active) version equals the M (Modified) version.
Deleting a Data Subscription
There are two ways to manually delete a data subscription:
- In the SAP BW/4HANA Cockpit, use the Data Subscriptions app .
- In SAPGUI, use transaction RSDPS.
You can only select and delete one data subscription at once. It is not possible to delete multiple data subscriptions in one operation.
Mass Deleting of Data Subscriptions
When multiple data subscriptions share a common target, such as a specific SAP BW space or an entire SAP Datasphere tenant, deleting them individually is inefficient. In these cases, you can use a mass deletion report to delete multiple data subscriptions simultaneously based on a target.
You can access the mass deletion report Mass Deletion of Data Subscriptions by Target in two ways:
- In SAPGUI, use transaction SE38 and execute program RSDDS_DELETE_BY_SOURCE.
- In SAPGUI, use transaction RSDPS, and navigate to Goto→Delete Data Subscriptions by Target.
To perform the mass deletion, specify the Target in the selection parameters. You can use the value help to find configured targets.
Hint
If a target no longer exists (for example, if a tenant was decommissioned), you can use the Force Deletion option to bypass standard validation checks.
You can view the outcome of the deletion operation in a log screen that appears after the deletion finished. Here you can also see how many data subscriptions have been deleted and any error messages or issues that might have come up.
Important Maintenance Considerations
Deleting the data subscription does not automatically delete the corresponding local table (file) as well. If the data subscription has been deleted, the local table (file) will remain in the SAP Datasphere tenant. However, there it will now become editable (losing the read-only tag) and can be deleted manually.
Ensure that the connection to SAP Datasphere is active before attempting a deletion. If the connection is broken, the local tables (file) in SAP Datasphere might retain a read-only status, which prevents their manual removal even after the subscription is deleted in the source system.