DB02 - unknown Objects in ABAP-Dictionary - DBAN_CHECK*

[Former Member]

Hello Guys,

we´re facing some trouble with strange DB-Views in our Develop and Productive System.

Please have a loock onto the attached screenshot from DB02 “Missing Tables Indexes” -> “unknown Objects in ABAP-Dictionary” -

We don´t know how to handle these Views. And these are not customer specific.

So can we just drop these views?

Note 1122725:DB02: Unknown objects in SAP Dictionary after Upgrade is not valid for us, cause we didn´t upgrade the system.

Do you have any further idea or suggestions how to handle these views?

Thanks

Regards

Benjamin

[former_member182967 · Accepted solution]

Hello Benjamin,

If your DB is MaxDB, please refer to 1423935 - FAQ: SAP MaxDB Database Analyzer

12. Which view tables are created due to the database parameter check with the Database Analyzer?

The Database Analyzer creates the following DBAN_* view tables during the database parameter check:

DBAN_ACTIVEDIAGNOSTICFUNCTIONS

DBAN_CHECK_NUM_CLUSTERED_TABLES

DBAN_CHECK_NUM_DATA_VOL

DBAN_CHECK_NUM_UKTS_USERTASKS

DBAN_CHECK_NUM_TRACES_ACTIVATED

DBAN_CHECK_OS

DBAN_CHECK_SYSTEMHEAP

DBAN_CHECK_UNICODE_USER

DBAN_UPDATE_INSTANCE_HAS_CHECKED

When calling the database parameter check, make sure that you execute it as a database system administrator. The view tables are then created in the schema of the database system administrator.

Note:

If you inadvertently execute the database parameter check under a different user, the view tables are created under the user schema of this user.

This does not affect the database parameter check. However, you can display these view tables in the SAP system as Unknown objects in ABAP Dictionary. In this case, delete the view tables; they will be created again during the next database parameter check.

Regards,

Ning Tong

[Former Member · Accepted solution]

Hi Guys,

just one more question, how to delete these views? 😉

SE14 doesn´t show the option to delete it...

Or do I have to recreate it in ABAP Dicionary and then delete both database and dictionary?

Thanks

ben

[hemanth2 · Accepted solution]

Hi benjamin,

Hope you are doing good.
Did you try SE16? Please see:

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e076abe3-6e2c-2e10-b7ab-f1ae650de...

Hope this helps.

_ _ _ _ _ _ _ _ _

Kind Regards,

Hemanth
SAP AGS
_ _ _ _ _ _ _ _ _
 

[Former Member · Accepted solution]

Hello Hemanth,

thanks for the reply, i know the cheat in SE16, but I´d like to delete the whole tabe/view and not just the entries... ;-(

Thanks,

ben

[hemanth2 · Accepted solution]

Ben, in that case, did you try the DROP VIEW command? Please see:

drop_view_statement - SQL Reference Manual - SAP Library

drop view <scehma> <View name>

Kind regards,
Hemanth

[Johan_sapbasis]

Hi,

Refer to sap note 1423935 - FAQ: SAP MaxDB Database Analyzer

Point 12 it is created due to database parameter check with db analyzer.

Kind Regards,

Johan