So the BW team raised an issue where a table could not be activated after they added an attribute to it.
Important tools to check tables included transactions SE16 ,SE14 , SE11
But turns out the problem was with the temporary tablespace , no more data files could be added so this was done using BRTOOLS to extend the tablespace.