on 09-03-2010 12:14 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Mahesh,
Thanks for ur reply.
how can I set conditions if the query returns 100 rows?
Here is the scenario:
We have a Sales estimation transaction in which there are more than 10 items used.
I want those 10 items as CFL in another transaction.
In this case, how can I set the condition?
Is there any 'IN' clause available like SAPbouiCOM.BoConditionOperation.co_EQUAL ?
Regards,
Toms
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.