How to find who did a selective deletion, when and what was deleted

Summary

Whenever you make a selective deletion, there is a log that keeps that information in the same place that you did the selective deletion.

Details

In the same place that you did the selective deletion, right-mouse click on the InfoCube, and select the menu option “Manage”

Select the “Contents” tab

At the bottom of the tab, click on the “Delete Selection” button

In the window that pops-up, click on the button “Log”

You will see a log that details date, time, user, fact table, numbers of records and the number of the log

 

The job that runs the selective deletion has a prefix of “BI_INDX” and executes the ABAP/4 report RSINDEX1.

The tables that contain this selective deletion log are:
RSDRDLOGHEADER Log Delete Actions (Header Table)
RSDRDLOGPOSITION Log Delete Actions (Positions)

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.