cancel
Showing results for 
Search instead for 
Did you mean: 

HOW CAN I ADD/UPDATE/INSERT IN A USER TABLE WITH MATRIX

Former Member
0 Kudos

Hi All,

I have one User table (Defined as No Object) and what i need to do is a form with a matrix to Add/Update/Delete data in my user table.

I already create the form and the matrix that already give me the user table data. But now i have several problems to solve.

First I try to add a new row but this new row get the data of the last row in the matrix. What i needed is a blank row to add new data in the user table.

Second, when i change data in matrix and do update in the form, sap show me the message that the operation is successfully done but the data in the user table in not updated.

I am trying to do one forma like whe can find in Setup-> General -> Freight.

Can anyone help me?

Best Regards,

Luis Duarte

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

If ur dealing with a simple form like that U can as well use the direct table form, and just provide a FMS to auto matically fill the code and name. U can directly use the form by.. Tools-->UserDefined Windows

Or

Comming to ur problem.... when ur adding a new row clear the data sources so that u'll get a blank row.

And for update the best thing to do is delete all the records in the table and again insert all the records directly from the matrix.

Hope it helps,

Vasu Natari.

Former Member
0 Kudos

Hi Vasu,

Tanks again.

Yes i can try to control the form in Tools->UserDefined Windows.

The matrix in the form have 5 Columns, can i change one of the columns to a linked button? Or associate linked buttons to a column in a system matrix.

What i pretend to do is that columns have linked buttons to items and when the user try to update that columns the add-on control if the code in the columns is a valid item code.

Best Regards.

Luis duarte

Former Member
0 Kudos

Hi,

We cannot add a link button in a system matrix.

Then u need to design and use a user form with matrix.

Vasu Natari.

Former Member
0 Kudos

Thank you very much.