Choose From List Condition on Detail table field rather than Master table

[Former Member]

Dear All,

I have a master detail udo having udts @master @detail

I need to filter my cfl object on bases of field in @detail table.

Can you tell how do I do this.

[Former Member]

Hi Nazir,

If your question is resolved can you please close the thread by marking it as answered.

Regards

[Former Member]

Hi Nazir,

You can't assign CFL on a @detail table.

If you want to search on the basis of fields from the detail table then you have to design your own customized search form .

Hope it helps ..

Regards

[Former Member]

Hi Nazir Salman,

If you are using Screen painter, then u have to create CFL and GIve Object Id = your table name(master/details).

And call that CFL to particular field and give alias.

Regards,

Pradeep   

[ANKIT_CHAUHAN]

Hi Nazeer & Pradeep,

You cannot use Detail Table for CFL purpose. For this you need to design your own form or You can use FMS (Formatted Search).

Hope it helps.

Thanks & Regards

Ankit Chauhan

[Former Member]

     Try

            Dim oCFLs As SAPbouiCOM.ChooseFromListCollection

            Dim oCons As SAPbouiCOM.Conditions

            Dim oCon As SAPbouiCOM.Condition

            oform = sbo_app.Forms.Item("formuid")

            oCFLs = oform.ChooseFromLists

            Dim oCFL As SAPbouiCOM.ChooseFromList

            Dim oCFLCreationParams As SAPbouiCOM.ChooseFromListCreationParams

            oCFLCreationParams = sbo_app.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)

            ' Adding 2 CFL, one for the button and one for the edit text.

            oCFLCreationParams.MultiSelection = False

            oCFLCreationParams.ObjectType = "yourobjectname"

            oCFLCreationParams.UniqueID = "CFL1"

            oCFL = oCFLs.Add(oCFLCreationParams)

            ' Adding Conditions to CFL1

            oCons = oCFL.GetConditions()

            oCon = oCons.Add()

        'here which field u want to filter

            oCon.Alias = "CardType"

     'here condition

            oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL

            oCon.CondVal = "C"

            oCFL.SetConditions(oCons)

            ' oCFLCreationParams.UniqueID = "CFL2"

            'oCFL = oCFLs.Add(oCFLCreationParams)

        Catch

            MsgBox(Err.Description)

        End Try