List of Item in Matrix Column

[Former Member]

Hi Experts

I've used a matrix on a ADD form using UIAPI in SAPB1 and I've binded each column with UDF.

I want to get the item list (List of item)when I'll use the "Tab" button in the column of item name, like Purchase Order form.

Is it possible?

If yes, then please guide me in coding of it.

[Former Member · Accepted solution]

Subrata,

Use the same procedure to itemlist but objecttype differs.

U refer the C:\Program Files\SAP\SAP Business One SDK\Help\SDK_EN.chm

There search for bolinked object.........

And also learn from

C:\Program Files\SAP\SAP Business One SDK\Samples\COM UI\VB.NET\17.ChooseFromList

If this answer is helpful give reward points,

Regards,

Anitha

[Former Member]

Hi,

First u have to add DBDataSource on ur form by

oDBItem = oForm.DataSources.DBDataSources.Add("table name");

Bind column to DBDataSource

oColumn.DataBind.SetBound(true,"table name","column name");

then assign the CFL to column by following code

SAPbouiCOM.ChooseFromListCollection oCFLs = null;

SAPbouiCOM.Conditions oCons = null;

SAPbouiCOM.Condition oCon = null;

oCFLs = oForm.ChooseFromLists;

SAPbouiCOM.ChooseFromList oCFL = null;

SAPbouiCOM.ChooseFromListCreationParams oCFLCreationParams = null;

oCFLCreationParams = ( ( SAPbouiCOM.ChooseFromListCreationParams )( SBO_Application.CreateObject( SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams ) ) );

// Adding CFL for the column.

oCFLCreationParams.MultiSelection = false;

oCFLCreationParams.ObjectType = "4";

oCFLCreationParams.UniqueID = "CFL1";

oCFL = oCFLs.Add( oCFLCreationParams );

//Assign the CFL Id to EditText

oColumn.ChooseFromListUID = "CFL1";

Regards,

Lalit Narayan

[Former Member]

Hi lalit..

I think u r right... can we use 2 dbdatasource for one matrix..

10 rewards points from my side.

thnx n warm regards

deepak gaur

[Former Member]

Hi Deepak,

Of course ,we can bind one matrix to two DBDataSource.

Thanks and Regards,

Lalit