Start of Content Area

Procedure documentation Deleting Requests from the PSA  Locate the document in its SAP Library structure

Use

If you do not regularly delete data from the PSA, the PSA tables can grow to an unlimited size. Large tables increase the costs of data retention, the downtime for maintenance tasks and the performance of the loading process. This function allows you to delete requests from the PSA. This reduces the volume of data in the PSA.

Examples of applications are deleting incorrect requests or deleting delta requests that have been updated successfully in an InfoProvider and that no further deltas should be loaded for. You can create selection patterns in the process variant Deleting Requests from the PSA and thus delete requests flexibly.

Procedure

Including the deletion of requests from the PSA in process chains

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

...

       1.      To insert a process variant for deleting requests from the PSA in the process chain, select process type Deletion of Requests from the PSA 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.      On the next screen, enter a description for the process variant and choose Continue. The maintenance screen for the process variant appears. Here, you define the selection patterns to which requests should be deleted from the PSA.

       4.      Enter a DataSource and a source system. You can use the placeholders Asterisk * and Plus + to select requests with a certain character string flexibly for multiple DataSources or source systems.

Example

Character string ABC* results in the selection of all DataSources that start with ABC, and end with any other characters. The character string ABC+ results in the selection of all DataSources that start with ABC followed by any other single character.

       5.      If you set the indicator Exclude Selection Pattern, this pattern is ignored in the selection. Settings regarding the age and status of a selection pattern (request selections) are ignored for excluded selection patterns.

Example

For example, you define a selection pattern for the DataSources ABC*. To exclude certain DataSources for this selection pattern, create a second selection pattern for the DataSources ABCD* and set the indicator Exclude Selection Pattern. This selects all DataSources that start with ABC, with the exception of those that start with ABCD.

       6.      Enter a date or a number of days in the field Older than, in order to define the time when the requests should be deleted.

       7.      If you only want to select requests with a certain status, set the corresponding indicator.

You can select the following status indicators:

This graphic is explained in the accompanying text Delete Successfully Updated Requests Only

This graphic is explained in the accompanying text Delete Incorrect Requests that were not Updated

Note

With  This graphic is explained in the accompanying text Copy Request Selections you can copy the settings for the age and status of a selection pattern (request selections) to any number of selection patterns. Select the selection pattern to which you want to copy the settings, place the cursor on the selection pattern from which you want to copy, and choose This graphic is explained in the accompanying text Copy Request Selections.

       8.      Save your entries and return to the previous screen.

       9.      On the next screen, confirm the insertion of the process variant into the process chain.

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

Deleting requests for a DataSource in the Data Warehousing Workbench from the PSA

You are in an object tree in the Data Warehousing Workbench.

...

       1.      Select the DataSource that you want to delete requests from the PSA for and choose Manage.

       2.      On the next screen, select one or more requests from the list and choose This graphic is explained in the accompanying text Delete Request from DB.

       3.      When asked whether you want to delete the request(s), confirm.

The system deletes the requests from the PSA table.

You can also delete requests in DataSource maintenance. Choose Goto    Manage PSA (pushbuttonThis graphic is explained in the accompanying text). Follow the instructions above, starting from step 2.

Result

If you delete requests from the PSA, they remain physically in a partitioned PSA table for the time being.

The requests are first deleted logically (from table RSTSODSREQUEST) and are given a deletion flag in PSA partitioning administration (table RSTSODSPART). You can no longer access these requests.

The requests are not deleted physically from the PSA table until all requests in a partition have been logically deleted and have thus been given the deletion flag in PSA partitioning administration.

Note

The change log is stored as a PSA table. For information about deleting requests from the change log, see Deleting from the Change Log.

 

 

End of Content Area