WHERE for UDT Handler Linked Table
I like to use the UDT Handler LInked Table with a Where condition to get a subselect from the Table in the Combobox. For Example I added a UDT-Handler to Business Partner and within one column of the UDT I like to fill the Combobox with all Names from OCPR (Ansprechpartner) from this special Customer (SELECT Name FROM OCPR WHERE CardCode='[%CardCode]'. How to realize this? Or is it possible with standard formatted search? But which Field_Id is the CardCode in the UDT-Handler Form?
I have nearly the same problem. Is it possible to use a user defined SQL statement for CFL or comboboxes in UDT Handles? Another way is to fill the combox manually but I don't know how. Any help is appreciated.