Deleting Master Data Selectively 

Use

If you want to delete master data selectively, you have two options:

●      Besides creating and changing master data, you can also use a deletion mode at single record level.

●      You can use report RSDMDD_DELETE_BATCH.

You can only delete master data records if no transaction data exists for the master data that you want to delete, the master data is not used as attributes for an InfoObject, and there are no hierarchies for this master data.

Procedure

Selective Deletion in Master Data Maintenance:

...

       1.      You are in the Modeling functional area in Data Warehousing Workbench. In the InfoObject tree, choose Maintain Master Data from the context menu of your InfoObject.

A selection screen appears for restricting the master data.

       2.      Use input help to select the required data.

       3.      The list overview for the selection is displayed, and provides two options:

○       In the list, select the master data records to be deleted, choose Delete and Save your entries.

○       Select additional master data by choosing Data Selection, select the master data records that are to be deleted and choose Delete. Repeat the selection as many times as necessary and choose Save to finish.

The records marked for deletion are first written into the deletion buffer. If you choose Save, the system generates a where-used list for the records marked for deletion. Master data that is not being used in other objects is deleted.

Selective Deletion Using the Report

...

       1.      Enter report RSDMDD_DELETE_BATCH in ABAP Editor (transaction SE38) and create a variant for it.

       2.      Execute the variant.

       3.      Enter the InfoObject whose master data you want to delete.

       4.      In Filter Data, you can specify which data you want to delete.

       5.      You can specify a deletion mode for the data (parameter P_SMODE).

More information: Deleting Attributes and Texts for a Characteristic

       6.      You can simulate the report before running it (parameter P_SIMUL).

       7.      You can schedule the report in the background. If you want to clear up your master data at regular intervals, you can also integrate the report into a process chain using process type ABAP Program.