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

  • 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.
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 editing screen for the InfoObject.

  2. In the BW modeling tools: Go to the Master Data/Texts tab and select the Delete Master Data Using 0RECORDMODE checkbox. InfoObject 0RECORDMODE is added as a time-dependent attribute.

    In the Data Warehousing Workbench: On the Attributes tab, set the Delete Master Data Using 0RECORDMODE flag.

  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 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.