Skip to Content
0

How to fast load Bulk Data to matrx using sap b1 addon

Oct 04, 2017 at 09:11 AM

32

avatar image
Former Member

I have 1000 records of data.I am loading the data to matrix it will take 20 min of time.How to reduce the time to load data to matrix in sap business one

10 |10000 characters needed characters left characters exceeded

Do you need just to show the data or you will need to save somewhere?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

ANKIT CHAUHAN
Oct 04, 2017 at 12:31 PM
0

Hi,

If it is a matrix on the User Form which is bound to the UDO, you can use something as below:

SAPbouiCOM.Matrix oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx_0000").Specific;
oMatrix.Clear();
oForm.DataSources.DBDataSources.Item("@LINETABLENAME").Clear();
SAPbouiCOM.DBDataSource oDB = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@LINETABLENAME");
oForm.DataSources.DBDataSources.Item("@LINETABLENAME").InsertRecord(oDB.Size);
oDB.SetValue("U_LineID", oDB.Size - 1, Convert.ToString(oRecSet.Fields.Item("LineID").Value));
oDB.SetValue("U_Code", oDB.Size - 1, Convert.ToString(oRecSet.Fields.Item("Code").Value));
oDB.SetValue("U_Name", oDB.Size - 1, Convert.ToString(oRecSet.Fields.Item("Name").Value));
oMatrix.LoadFromDataSource();

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP SME Support

Share
10 |10000 characters needed characters left characters exceeded