I have a table created using CDS file. This table is used in an attribute view(attribute view is because the created model is old -- i don't think this matter) and this attribute view is used in different calculation views.I wanted to add a field to key(already 5 key fields are there).

When i changed the definition it thows an exception of not null for the newly added field, so i have deleted those records having null values. And activated,even this time it failed and said model is inconsistent(no specific error here)

Lot of data existing in the table, as a work around I have created another table(using cds with 6 key fields this time) and loaded the whole data into this table. the data loaded successfully.

How can i make the change.