Skip to Content
0
Former Member
Jun 09, 2009 at 12:19 PM

Matrix row update fails

34 Views

I have created a Master type of User defined object in sap b1.

For its UI, I have created a form having a matrix. Its columns are bounded to database fields.

Whenever this form, is in update mode, it always needs to have a blank last row (for addition of new entries).

When I update any of the existing entries, without adding a new entry, the update fails with the error message "System cannot add NULL value to Code field".

So I delete the last blank row of the matrix, when before action is true for the Update button of this form.

And when before action is false for this form , in the OK mode, I append a blank row to matrix to meet the requirement (new addition of entries).

Now the system error message does not occur and displays operation successful message.

BUT, the updated entries are not reflected in the database.

Please HELP.