Skip to Content
avatar image
Former Member

Item Master Data - Update UDF

Dear all,

I have created Matrix with three columns, ItemCode, ItemName and U_Location (UDF). What I need to achieve is to enter U_Location and after click Update to update data to table. I defined form ObjectType=4 and created two buttons with uniqueID 1 and 2. After I click update button I am getting an error "Item number is missing. Specify an Item Number".

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 23, 2017 at 02:10 AM

    Hi Arnes,

    Did you bind the matrix with the DBDatasource OITM ?
    And also, bind each of the matrix columns to the field OITM.ItemCode, OITM.ItemName, OITM.U_Location.

    Regards

    Edy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 12:23 PM

    oForm.DataSources.DataTables.Item("Location").ExecuteQuery("select ItemCode, ItemName, U_Location from OITM");
    SAPbouiCOM.Column oColumn = Matrix0.Columns.Item("ItemCode");
    oColumn.DataBind.Bind("Location", "ItemCode");
    SAPbouiCOM.LinkedButton oLink = (SAPbouiCOM.LinkedButton)oColumn.ExtendedObject;
    oLink.LinkedObject = SAPbouiCOM.BoLinkedObject.lf_Items;
    Matrix0.Columns.Item("Name").DataBind.Bind("Location", "ItemName");
    Matrix0.Columns.Item("Location").DataBind.Bind("Location", "U_Location");
    Matrix0.LoadFromDataSource();

    Am I doing it good?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27, 2017 at 04:37 AM

    Hi Ames,

    In order for the auto support of Update, you need to bind the Matrix to the BDDataSource 'OITM'
    Binding it to DataTable will not automatically update the changes.


    Regards

    Edy

    Add comment
    10|10000 characters needed characters exceeded