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.
Did you specify the default value for your newly added key field in CDS ? Just a thought..
Regards,
Nithin