Skip to Content
author's profile photo Former Member
Former Member

Choose From List - Is it possible to populate CFL by using a query?

Hi Experts,

I need to fill the CFL based on a transaction where there are 10 to 15 items.

But Item master contains more that 1000 items.

Is it possible to populate / fill the Choose from list by using a query or a recordset?

I cannot use any condition there as the filtering is based on items in another transaction.

Please help.

Thanks in advance.

Regards,

Toms

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2010 at 11:35 AM

    Hi Toms,

    Offcource its possible to filter CFL by query

    On et_CHOOSE_FROM_LIST And pVal.Before_Action = True try the code as

    .....
    .....
    oCondition.Alias = "ItmsGrpCod"
    oCondition.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL
    Dim strSQL As String
    rs = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
    strSQL = "Select ItmsGrpCod,ItmsGrpNam From OITB WHERE U_CompoCat = '" & strCondition & "'"
    rs.DoQuery(strSQL)
    oCondition.CondVal = rs.Fields.Item("ItmsGrpCod").Value
    oChooseFromList.SetConditions(oConditions)

    Thanks,

    Mahesh

    Edited by: Mahesh on Sep 3, 2010 5:06 PM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.