Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Getting data from matix then saving it to a User-defined Table.

How can i get data from a matrix then save it to a specific table in database (user defined table).

i tried this code but doesn't work.

        Dim oform As SAPbouiCOM.Form
                        Dim DeliveryItemsMatrix As SAPbouiCOM.Matrix
                        Dim i As Integer

                        oform = SBO_Application.Forms.ActiveForm
                        DeliveryItemsMatrix = oform.Items.Item("38").Specific
                        PieceAndWeightBO.ItemCode = DeliveryItemsMatrix.Columns.Item(1).Cells.Item(1).Specific.value

                        For i = 1 To DeliveryItemsMatrix.VisualRowCount
                            With PieceAndWeightBO
                                .ItemCode = DeliveryItemsMatrix.Columns.Item("1").Cells.Item(i).Specific.ToString
                                .ItemName = DeliveryItemsMatrix.Columns.Item("3").Cells.Item(i).Specific.value
                                .Quantity = DeliveryItemsMatrix.Columns.Item("11").Cells.Item(i).Specific.value
                                .UoM = DeliveryItemsMatrix.Columns.Item("212").Cells.Item(i).Specific.value
                                .QtyInKG = DeliveryItemsMatrix.Columns.Item("U_QTYKG").Cells.Item(i).Specific.value
                                .Whse = DeliveryItemsMatrix.Columns.Item("24").Cells.Item(i).Specific.value
                            End With
                        Next

thanks!

Former Member
Former Member replied

Hi

Some examples how-to read data from the system matrix you can find here

[Thread: Set Value in Itemcode in Purchase Order Form|Set Value in Itemcode in Purchase Order Form;.

This is an example:

...
oItem = oForm.Items.Item("38").Specific.Columns.Item("U_MyFieldNameHere")
...

Regards

Andrei S.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question