Deleting Master Data at Single Record Level

Use

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

  • In master data maintenance, you have a deletion mode at single record level. You can also create and change master data.

  • You can use the report RSDMDD_DELETE_BATCH.

  • You can use report RSDMDD_DELETE_BATCH_PACKAGE. Deleting master data using report RSDMDD_DELETE_BATCH can take a very long time if the InfoObject has a large number of entries in the master data tables. In cases like this, you can use report RSDMDD_DELETE_BATCH_PACKAGE instead.

Procedure

Selective Deletion in Master Data Maintenance:

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

    A selection screen appears for restricting the master data.

  2. Use the input help to select the required data.

  3. You get to the list overview for the selection and have two options:

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

    • First select additional master data using Data Selection, highlight the master data records that are to be deleted, and choose Delete. Repeat the selection on demand where 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 no longer being used in other objects is deleted.

Selective Deletion Using Report RSDMDD_DELETE_BATCH

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

  2. Execute the variant.

  3. Specify the InfoObject with the master data that 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.

Selective Deletion Using Report RSDMDD_DELETE_BATCH_PACKAGE

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

  2. Execute the variant. The steps which follow are the same as when executing report RSDMDD_DELETE_BATCH. There is an additional parameter however, which you use to set the maximum number. The default value for this parameter is 50000.

  3. You can specify that all master data values should be generated.