How to delete the MD from IBP tables

[SUNIL_JOHN]

Hi Folks,

What are the options to delete the MD from IBP tables?

Thanks

Sunil.

[satish_waghmare3 · Accepted solution]

Hi Sunil

There are two ways which I know -

1. Using Web UI : Follow path Data Integration-->New Import Job-->  Operation Type as “Delete”  -- > CSV File Upload

2. Using IBP Excel Add-in :  Master Data-->Manage-->Single-->Customer Product MDT--> Select both and Delete--> Ok and Continue

Delete Combinations from Excel Add-in (Optional) :  Please check if you require to run Delete Combinations from Excel Add-in, once the master data records are deleted. This is to ensure combinations which exist with those master data IDs/Values are deleted as well. Otherwise you will still see the keyfigure data for deleted master data IDs.  This may or may not be required.

Hope this will help.

Thank you

Satish Waghmare

[Former Member]

To add further, if you have version specific master data you can delete using version -> Manage -> Delete functionality in Excel UI. Select the master data and version from which you want to delete and then run the job.