Show TOC

Deleting Data from the DataStore ObjectLocate this document in the navigation structure


Deleting individual requests serves primarily to remove incorrect requests from the DataStore object.

Like InfoCubes, you can also delete all data from the DataStore object or even delete the entire DataStore object. See also Deleting InfoCubes and InfoCube Contents.


The following procedures apply to a standard DataStore object. In the case of a write-optimized DataStore object, any requests can be deleted as required. More information: Deelting Requests from Write-Optimized DataStore Objects


You have to differentiate between two situations:

  1. The request(s) to be deleted is (are) not activated yet. In these cases, the requests are simply deleted from the activation queue during the deletion process. Because they were not yet activated, no adjustment occurs for the table of active data or the change log.

  2. The request(s) to be deleted is (are) already activated.


    A prerequisite for this would be that the requests to be deleted have not yet been updated or are no longer updated in the connected InfoProviders. In this case, see also Deleting Already Updated Data.

    Since several requests can be activated in one activation run and you have the option of putting them together in a change log request, two cases have to be differentiated here:

    • For each downloaded request (called a PSA request later on), there is exactly one change log request. In this case, the change log request is deleted from the change log and from the table of active data.

    • Several PSA requests are assembled for a change log request in an activation run. In these situations, you have to delete all of the other PSA requests that are included in the same change log request when deleting a (PSA) request.


In both of the above-named cases, a rollback is executed during deletion. Rollback means that the status is restored that prevailed before posting the request to be deleted. As long as the request to be deleted is not the last one in the DataStore object, all requests that were activated after the one to be deleted have to also be deleted from the DataStore object.

In order to delete data from an DataStore object, you have several different options. All of these options can be reached from the Management of DataStore Objects. The option you choose depends on your application scenario.

  1. If you want to delete entire requests that are incorrect, then choose Delete by Request. With this, requests that are not activated can be deleted from the activation queue, or activated requests can be deleted from the active data table and the change log.

  2. If you only want to delete individual fields instead of an entire request, choose Delete Selectively. With this, you can delete data, for example, from a time period that is no longer used. In doing so, only data from the table for active data is deleted, while the change log remains unchanged.

  3. If you only want to delete data from the change log, choose Delete from the Change Log. With this, you can reduce the scope of the change log if several requests have already been loaded, and only a limited history needs to be retained. Thus, the data volume of the change log is reduced.