Mass change of component in Task list

Hi Experts

I have thousands of material and there are changes done for them to use them in maintenance order task list as stock or nonstock.

The task is to change the item category (from L to N or from N to L) of those materials used as components in task list and also find out those materials in BOM , Equipment TL and FL TL and change the item category.

1.can this be done using a BDC (checking all task list / BOM for that material and change the item category)

2. table to check component assigned to which operation in task list.

Any help for this requirement

Thanks

Jey