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.

[Reagan]

If you are migrating the SAP system using R3load export/import then you better get the table created at the database level or else you will run into issues during the migration. As the table is still known to the ABAP dictionary, adding an exception is also not advised. Check note 1870843 - Missing Tables and Indexes - How to edit exceptions. You should consider creating the table at the DB level. Moreover the DB utility tool will only create the table at the DB level and nothing more is done. While migrating the tool will do the same as well.

[FCI]

Hi Gabriel,

Normally, your DB should be consistent with the DDIC. The normal way to handle this is to create the missing tables in the DB.

You can actually delete the DDIC tables but you will need a key and the system may stay inconsistent (at an upper level). This table is a PSA table and should be linked to a dataSource. Is this datasource still exist ? Still used ?

Regards,

Frederic

[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