Start of Content Area

-7004: DEFAULT not allowed  Locate the document in its SAP Library structure

Explanation:

...

       1.      Columns with DEFAULT specification cannot be added to a table with the ALTER TABLE statement.

       2.      The specification of NOT NULL DEFAULT NULL is not allowed.

User Action:

...

       1.      To add a column to one with an <ALTER TABLE statement>, specify it without a DEFAULT specification. Then define the DEFAULT in another <ALTER TABLE statement>. This how this column is given the DEFAULT value in all table rows.

       2.      Delete the DEFAULT specification from the SQL statement and execute the statement again.

 

End of Content Area