How to delete Unused Master data in Info Object?

[Former Member]

Hi All,

         Currently, I'm facing the issue in master data as double. In my Material number got doubled one is preceding with zero and another one is without preceding zero.

Ex:

     00000128987789 - This is Wrong

     128987789 - This is Correct one.

In P table having, these kind of materials count is 4 million. But 2 million only valid.

In my case, we are not using preceding zero material in transaction data. We used only without preceding zero one.

Could you please tell me how to delete the wrong unused materials in P - table.? Is there any Common ABAP program/Functional modules  to delete these unused records?

Thanks in Advance... Please help me on this asap.

Regards,

Dinesh J

[Former Member]

Hi,

What exactly the problem you face when deleting the data?

As the data you want to delete is not included in transaction data, you can:

1) Right click and delete all data

2) Let it check for use

3) Confirm to delete all unused

4) Full load to make sure the unused valid data is not getting deleted and missing

It should work if you have the time and system resources.

Let us know if you hit any issue

Regards

Bill

[Former Member]

Hi Dinesh,

Try the program RSDMDD_DELETE_BATCH.

Screen for program is below:

Also details of screen fields:

Top of screen 'Filter Data' = Proide your deletion values

  p_iobjnm   = name of the InfoObject
  p_delsid   = delete SIDs?
  p_deltxt   = delete texts?
  p_simul    = simulate only ?
  p_log      = write log entries?
  p_prot     = get detailed usage protocol?
  p_smode    = Search Mode for MD Where-Used Check.
  p_chknls   = Search for usages in NLS

This program deletes the master data in batch so you can use this program to delete master data including options to delete the SIDs etc.

Please let me know if you have any questions.

Regards

Amit

[Former Member]

Other option could be to delete all your master data and reload it if you have only correct data in source system.

Thanks

Amit