Skip to Content
author's profile photo Former Member
Former Member

Can't add field to table - Table is not activated

Hello,

I'm facing an issue that i cannot understand. It happens everytime i need to make changes to some tables we've created.

Example:

I'm trying to add a field to a table SAFTPT_IMAT, i add the field, but when i try to activate the table, the system responds with an error. Navigating to the log i get a red message "TABL SAFTPT_IMAT was not activated". Navigating further i get the following:

Table SAFTPT_IMAT could not be activated

(E- Table SAFTPT_IMAT (Error adjusting the database) )

I navigate into the log and get:

Activate table SAFTPT_IMAT

Field name VAT_RELEVANT can be provided in this system. Please do not use.

No data exists (structure change caused by DROP / CREATE)

SAFTPT_IMAT: Structure change at field level (DB is adjusted)

Adjust table in DB >>>

sql:

DROP TABLE "SAFTPT_IMAT"

ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-801:

internal error [56319]

DDL time(___1): .......108 milliseconds

SAFTPT_IMAT could not be removed

Table SAFTPT_IMAT (Error adjusting the database)

Table SAFTPT_IMAT was not activated

When i enter in the error i get this:

Table SAFTPT_IMAT (Error adjusting the database)

Message no. DT007

Diagnosis

The definition of the table in the database could not be adjusted to its

definition in the ABAP Dictionary.

System Response

Procedure

Look for further information about the error in the log.

Using the analysis tool of the database utility, check the consistency

between the definition of the table in the database and its definition

in the ABAP Dictionary.

This happens also in another table, where i want to turn a regular field into a "Primary Key" field and change the order of the fields. I get the exact same error, without the warning about the field inside the sap namespace.

Can anyone please guide me through this error?

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2010 at 05:51 PM

    Have you done any migration from 32 bit to 64 Bit or Vice versa or is this a fresh installed system?

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vitor,

      Yes i have faces this issue in DB migration once (not with SAP) , so followed the solution i mentioned above .

      You can raise this with Migration team as well, but for reliable soution its always better to take SAP's suggestion

      Regards,

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2010 at 06:15 PM

    Hi Vitor,

    Try checking Note 582427.

    Best Regards,

    Matt

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Matt,

      I'm replying as Gagan sugested we raise this problem to SAP Support.

      I've seen the noteyou've mentioned. Do you have any more information on this issue that can help me understand to do next, as we're not the ones responsible for the administration tasks.

      Thank you very much

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.