cancel
Showing results for 
Search instead for 
Did you mean: 

How do I update the contents of a matrix cell?

Former Member
0 Kudos

Hi,

When a user exits the quantity column on the Sales Order matrix, a value in a user defined field is checked, and if this is a cetain value, I need to update the value in the quantity cell on that particular row.

How do I update the value of this cell? Is the column not editable as I am trapping the event on the et_LOST_FOCUS event of the column?

Here is the line of code I would expect to do it...

oMatrix.Columns(35).Cells.Item(pVal.Row).Specific.Value = iPackingUnit

Thanks for any help,

Robin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Updating a matrix cell is possible ..

Try

Set oForm = m_App.Forms(FormUID)

Set oMatrix = oForm.Items.Item("38").Specific

oMatrix.Columns.Item(11).Cells.Item(pVal.Row).Specific.Value = 35

(In the version 6.5 SP1 EF20 the quantity column is 11)

HTH

Regards,

Yaniv G.

SDK Consultant,

SAP Manage Israel.

Former Member
0 Kudos

Hi,

Thanks for your help. This has worked fine for me.

Regards,

Robin