Thursday, February 28, 2019

Selective deletion logs – reviewed outside RSA1

Selective deletion of data in InfoProvider can be performed on manage screen in RSA1. There is a tab called Content and button Delete Selection that allows this activity. This button displays a pop up window that contains several other button for particular activities.

Main function of the popup is behind Deletion Selection that allows entering selection for the deletion. Once this is done, a job can be setup that will perform physical deletion.

Another button of the popup that I want to focus on is called a Log. This displays an ALV grid display of all selective deletions done on particular InfoProv in past. The grid can be further drilled down to details of each deletion.  Thsi shows all condition/selection that was used for deletion. 

Sometimes I want to evaluate deletion logs outside the RSA1 t-code. In order to this there is a Function Module called RSDRD_LIST_ACTION_LOG. Via the FM for which just InfoProv needs to be provided as input parameter the same ALV grid with the all selective deletions done on particular InfoProv in past is displayed.

The FM has another input parameter that is optional called I_WITH_AGGREGATES. This enables to display aggregate deletions at InfoProv as well.

Table which stored deletion logs is called RSDRDLOGHEADER. This si a header table with info on who, when, which InfoProv, Delete Mode and number of records that were deleted.

Detail information on which fields were used for the deletions is stored in table RSDRDLOGPOSITION. Key which links both tables is POSITION_ID.

No comments: