One table is missing in R/3 DDIC

[Former Member]

Hi Experts,

While I am monitoring the db02 T-code, Under tables and indexes it is showing that one table is missing in R/3 DDIC.

Tables Indexes

Total number 68,514 82,026

Total size/kb 43,431,936 43,282,240

More than 1 extent 2,957 3,470

Missing in database 0 0

Missing in R/3 DDIC 1 0

Space-critical objects 0 0

Please let me know how can i find out this missing table in R/3 DDIC

Regards,

Reddy V

[Former Member]

Hi

Someone has created or deleted a table in the db, and it is not accessed to sap level , so check that whether it is existing in the db or not with the database rights user.

What are the names of the tables that u have seen.

Mention here.

Regards

Bhaskar

[Former Member]

Hi Bhaskar,

I have done the below process

In T-code DB02 Menu "Go TO" -> Table and Indices -> DB <-> ABAP Dic<->Display

It is showing the below details

Other checks

Tables 1

SCI_TEMPT Should not be created in DB

I have select the SCI_TEMPT table and clicked on create in DB.

After that again I have checked the db02 t-code again it is showing the same.

Please let me know how can fix this issue.

Regards,

Reddy V.

[Former Member]

Hi,

check SAP Note 849692 - Temporary SCI_TEMPT table

regards,

kaushal

[Former Member]

Hi

Better to activate the table from SE14,

Go through the tp log, and analyze it before activating.

And check the note given by kaushal

Regards

Bhaskar

Edited by: bhaskar1818 on Jul 16, 2008 6:04 PM