Show TOC

Deleting Master Data at Single Record LevelLocate this document in the navigation structure

Use

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

  • In master data maintenance, you have a deletion mode at single record level as well as being able to create and change master data.

  • You can use 0RECORDMODE.

  • You can use the report RSDMDD_DELETE_BATCH.

Note

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 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 0RECORDMODE

  1. You are in the InfoObject editing screen in Data Warehousing Workbench.

  2. On the Attributes tab, set the Delete Master Data Using 0RECORDMODE flag. InfoObject 0RECORDMODE is added as a time-dependent attribute.

  3. You can now flag data records for deletion by loading data with 0RECORDMODE = ‘D’.

  4. In the ABAP Editor (transaction SE38), enter report RSDMDD_DEL_BY_RECORDMODE , create a variant for it and run it.

  5. Specify the InfoObject with the master data that you want to delete. The records that have been flagged for deletion will be deleted.

Selective Deletion Using the Report

  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.