DB Tables

[Former Member]

Hi,

I see a lot of DB tables inconsistencies in DBACOCKPIT.

Please advice what is the cause and impact of this and how do I get rid of.

Refer to screenshot

P

[former_member188883]

Hi Paul,

From the screenshot, the information tells that these objects are available in database but missing in ABAP dictionary.

Please expand the list and check what kind of objects are these. Is you system BI ?

Regards,

Deepak Kori

[Former Member]

Yes I understand. This is ECC

[Sriram2009]

Hi Paul

1. Could you explain in detail about the upgrade from to levels?

2. SAP ABAP Team having access in the Database level (Without SAP Menu direct DB access)?

3. Could share the missing objects in DB table list?

BR

SS

[Former Member]

1)ehp1->ehp5

2)no

3)There are lots i will share few.

DB2CCMO_PARMS~

DB2COPYI~

SWD_HEADER~

[Sriram2009]

Hi Paul

1. Once again you can check with ABAPer if it is not require better you can remove those object from db.

2. For sake you can raise the incident to SAP support check those objects 

3. Before removing any objects from DB take full backup and then remove

BR

SS

[Sriram2009]

Hi Paul

You can check with ABAPer / Function consultant, whether those many tables(Which are shows as Unknown objects in ABAP Dictionary) are required or not? In case those tables are required you can maintain in the ABAP dictionary.

Have you done any SAP upgrade or DB migration?

BR

SS

[Former Member]

I see, possible that it might be the upgrade.

Any steps just in case want to eliminate if not required?

[Former Member]

Hello,

try to look at this document, which ixplains you what is wrong: R/3 Consistency - Database Administration in CCMS: MaxDB - SAP Library

And then check this SAP Note 33814 - Warnings of inconsistencies between database & R/3 DDIC

By the way, what are you using as a database? Oracle 10?

Kind regards

[Former Member]

Thanks. will check it out

DB is DB2 10