Inactivate Master Data with CSV

[Former Member]

Hi SAP Experts,

I have a requirement where in I need to inactivate Product Category Master Data in my system, I can do this task manually by editing each product Category and checking the Inactive button bt there are a lot of product categories to be inactivated.When I tried to achieve this using CSV import, I found that there is no field called INACTIVE which could be set to TRUE. If anyone has any solution to inactivate multiple Product catogories in one shot , please help.

regards,

Vishal

[former_member200421]

Hi Vishal,

You can just add the column "INACTIVE" to the Product Category import template and set the value to "TRUE" for all product categories that you want to inactivate.  The only columns you should need in the template are the product category id and the INACTIVE column.  You should be able to import this using Product Category as the object and it should do exactly what  you want.  If later you determine that some of the Product Categories should be active again, you can run the same import with the value set to "FALSE' and it will activate those categories again.

Hope this helps,

Rosemary