Objects missing from the database - any reason to not create them?

[PaulRR]

When I go to:

Run SAP transaction ST04.

• Diagnostics
• Missing Tables and Indexes
• Objects missing in the database
• Views

It shows that there are 70 views that exist in SAP (ECC), but not in the database.

SAP Library - BC R/3 Database Guide: MS SQL Server says:

If the database structure has been changed since the last consistency check, choose Refresh.

You can:

·  Create objects that are defined in the ABAP Dictionary, but not found in the database, by selecting the object and choosing Create on DB.

·  Display the definition of an object by double-clicking the object.

To ensure consistency between ABAP Dictionary and database, the consistency check should be performed once a month or when database structure changes have happened:

Are there any reasons why views listed there should not be created in the database?

[Former Member · Accepted solution]

Hi Paul,

You can create them if you wish, but they are not always required.  No harm done either way.

Regards,

Graham

[Reagan]

If there is no SAP note suggesting that those views can be ignored then I would have them created at the DB level.

Reagan