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