Dropdown on a UDF, pointing to a standard SBO table (any)

Answered

Gerard Mengerink

• August 10, 2016 12:53

SBO allows to link a UDF to a business object (but only standard SBO objects) or to a linked entity (but only UDT's). We would like to set a drop down on a UDF, that points to a standard table like OSLP (sales persons). The UDF should show the name, but "under the covers" it stores the primary key of the OSLP table.

Vote

0

• Official comment

  

  Naama Aharoni

  • August 11, 2016 10:33

  Hi Gerard,

  Once you have placed the UDF in the main window using the Item Placement Tool, you can create a dropdown list for a UDF field in the valid values column using an SQL query. However, that query must have two values (which will be shown to the user) and those are code and name.

  
  
  

  Thanks, Naama
• 

  Kevin Cunningham

  • February 27, 2018 16:52

  Thank you Naama, this is exactly what I have been looking for.  Kevin Cunningham.

Please sign in to leave a comment.