Missing tables

[Private_Member_742467]

Hi everyone,

In DB02 I have a lot of missing tables in our BW system (/BIC/B000* tables). The issue is that those tables exist in the ABAP dictionary but not in the DB. I have the possibility to create them at the DB level but I don't want to do that, as I am going to export the DB and migrate it.

Can someone suggest me how can I get rid of those tables?

Thank you.

[MarioDeFelipe]

Hello you need to delete ABAP data dictionary, this is done from SE11, enter the table name and click on delete, you can do this from 000, and it will ask you for a transport request.

then you can check the consistency, its very important to be clean on consistency before export/import

You can verify the inconsistency using one of the following methods:

• Call SE11 and choose the menu path "Utilities" > "Database Object" > "Check".
• Call SE14 and choose the menu path "Check" > "Database Object".
• Call SE14 and choose the menu path "Extras" > "Database Object" > "Check" (F6)
• You can execute DB consistency from DB02 until you are clear of objects missing between the abap dictionary and the DB

Please don't hesitate reply to this thread if you have further questions