Deleting from the Change Log 

Use

Deleting data from the change log of a DataStore object is recommended if several requests which are no longer needed for the delta update and are no longer used for an initialization from the change log have already been loaded into the DataStore object. If a delta initialization for updates to connected InfoProviders is available, requests have to be posted first before the corresponding data can be deleted from the change log.

A temporary, limited history is retained. In some cases the change log becomes so large that is advisable to reduce the volume of data and delete data from a specific time period.

Procedure

Including the deletion of requests from the change log in the process chain

You are in the plan view of the process chain in which you want to insert the process variant.

...

       1.      To insert a process variant for deleting requests from the change log in the process chain, select process type Deletion of Requests from the Change Log from process category Further BI Processes by double-clicking.

       2.      In the next dialog box, enter a name for the process variant and choose Create.

       3.      In the next screen, enter a description for the process variant and choose Continue.

The maintenance screen for the process variant appears.

       4.      Under Type of Object, select Change Log Table.

       5.      Under Name of Object select one or more DataStore objects for which requests should be deleted from the relevant change log tables.

       6.      Specify the requests that need to be deleted by determining the days or dates. You also have the option to specify whether you only want to delete successfully updated requests, and/or only incorrect requests, that are no longer updated in an InfoProvider (this is only valid for transaction data).

       7.      Save your entries and go back.

       8.      On the following screen, confirm the addition of the process variants in the process chain.

You arrive in the plan view for the process chain. The process variant for deleting requests from the PSA is included in your process chain.

Deletion of requests from the change log in the administration of the DataStore object

...

       1.      In the main menu in DataStore object administration, choose Environment ® Delete Change Log Data.

       2.      Specify the requests that need to be deleted by determining the days or dates. You also have the option to specify whether you only want to delete successfully updated requests, and/or only incorrect requests, that are no longer updated in an InfoProvider (this is only valid for transaction data).

       3.      Define the start date values under Start Conditions.

       4.      Select Start (Schedule Deletion).

The deletion is scheduled in the background according to the selection conditions.

You can also display a request list for the change log. You can also mark requests and then delete them directly.