ItemGroupCode as ItemGroupName

[Former Member]

Hey All

I'm trying to upload OITM table to the matrix, and in the Group Name i need to link the ItemGroupCode from the OITM to the ItemGroupName from the OITB.

For example, this is how i do it now:

oDBDataSource = oForm.DataSources.DBDataSources.Add("OITM");

oColumn = oColumns.Item("ItemCode");

oColumn.DataBind.SetBound(true, "OITM", "ItemCode");

how can i use the PK-FK table OITB??

Thank You!

[Former Member]

HI,

There is no PK-FK relation ship in fact, just logical.

Use the following:

Create a column with combo box, and set property displaydesc = true

Add validvalues, for all the item groups, and bind the combo box to the oitm.ItmsGrpCod field.

Dim oRs as sapbobscom.recordset = oCompany.GetBusinessObject(borecordset)
Dim vv as ValidValues = oCombobox.ValidValues
ors.doquery("select * from oitb")
while not ors.eof
  vv.add(ors.fields.items(0).value, ors.fields.items(1).value)
  ors.movenext()
loop

Take care, combo box description is only 30 chars long.

Now if you bind your data source, and load the OITM.ItmsgrpCod field into the combo box, the displaydescr property is true, and it will show the name of the item group.

Regards,

J.