Unknown objects in ABAP Dictionary

[Former Member]

Hello

When I see

Db02old->Checks->Database<->ABAP Dictionary->Display

Then in Unknown objects in ABAP Dictionary,I see the below entries,Not Sure how to resolve the below issues.

Unknown objects in ABAP Dictionary

DB tables 1

SOFFCONT1#$

DB indexes 0

DB views 1

SAP_AUXSTATS

Please let me know how do I proceed to resolve these issues??

[Former Member]

Hi,

It means that those database objects are not exist on ABAP dictionary, but exist in the database. So, you can check the note "33814 - Warnings of inconsistencies between database & R/3 DDIC" for the further information.

Best regards,

Orkun Gedik

[Former Member]

Orkun

Thanks for replying,I have checked that note..,what I see at db level,the table does not exist at db level also but i can see it in SAP.

SQL> desc SOFFCONT1#$

ERROR:

ORA-04043: object SOFFCONT1#$ does not exist

SQL> select table_name from user_tables where table_name='SOFFCONT1#$';

no rows selected

SQL> select * from SOFFCONT1#$ where rownum=1;

select * from SOFFCONT1#$ where rownum=1

*

ERROR at line 1:

ORA-00942: table or view does not exist

and for db view "SAP_AUXSTATS" I found SAP note 1538681 - DBA Cockpit: Check for Note 706927,I have Basis release 701 and patch 08.Can you confirm that this is relevent to my issue please??/

[Former Member]

>> db view "SAP_AUXSTATS" I found SAP note 1538681 - DBA Cockpit: Check for Note 706927,I have Basis release 701 and patch 08.

This is another issue. I know that SAP_AUXSTATS table is belong to the DBA Cockpit, but implementing this note will not get removed SAP_AUXSTATS from "Unknown objects in ABAP Dictionary" list.

At this case, even those tables are looking inconsistent, I suggest you open a note to SAP and get the most correct answer by them. This is because they are original SAP objects and you shouldn't perform any action without the confirmation by SAP.

Best regards,

Orkun Gedik

[Former Member]

Sometimes a # sign will be used as a placeholder for a non-printable character.

So please try this:

select table_name, dump(table_name,16) from user_tables
where table_name like 'SOFFCONT1%';

[Former Member]

Orkun, Thank you very much will check .

Joe , Have executed your query ,output is no rows selected.

SQL> select table_name, dump(table_name,16) from user_tables

2 where table_name like 'SOFFCONT1%';

no rows selected

SQL>

Any other expert ideas please???

[Former Member]

no rows selected

So I assume your are not logged in as SAP schema user.

As which user did you connect in sqlplus?

[Former Member]

I would ask the view DBA_TABLES to check whether the table really exists and who is the owner:

select owner, table_name from dba_tables where table_name like 'SOFFCONT1%';

SOFFCONT1#$ sounds like a leftover from a brspace reorganization. You can remove it by performing a brspace cleanup as written in SAP note 541538:

ORA-00955: name is already used by an existing object
           If this error occurs when you are creating the target table (with the suffix "#$"), it is probably because a preceding reorganization was canceled without the target table being deleted. In this situation, perform a cleanup:
brspace -f tbreorg -t "*" -a cleanup 

[Former Member]

Joe - I was trying with sysdba user,I tried with SAP Schema user and got it.Thanks.

SQL> select table_name, dump(table_name,16) from user_tables

2 where table_name like 'SOFFCONT1%';

TABLE_NAME

-

---

DUMP(TABLE_NAME,16)

-

---

SOFFCONT1

Typ=1 Len=9: 53,4f,46,46,43,4f,4e,54,31

SOFFCONT1#$

Typ=1 Len=11: 53,4f,46,46,43,4f,4e,54,31,23,24

Mark - Thank you very much,Got below output and cleaned up the table with command

brspace -f tbreorg -t SOFFCONT1#$ -a cleanup

SQL> select owner, table_name from dba_tables where table_name like 'SOFFCONT1%';

OWNER TABLE_NAME

-

---

-

---

SAPP10 SOFFCONT1#$

SAPP10 SOFFCONT1

Any ideas on DB view missing???

DB views 1

SAP_AUXSTATS

[Former Member]

SAP note 706927 speaks about the view SAP_AUXSTAT, but I cannot find such a view on any 701 system. So I believe it isn't needed. As Orkun suggested, open a call at SAP to clarify how to remove this warning. It looks like table DBDIFF needs to be adapted.

[Former Member]

All

Thank you very much,Will check with SAP for the Missing Iview.