Skip to main content
Nintex Community Menu Bar

Drop down box returning duplicate entry - SAP BAPI

  • Feb 17, 2017 12:49 AM UTC
  • 3 replies
  • 82 views
  • Translate All

Forum|alt.badge.img+8

Hi

We have a drop down box quering a SAP table via BAPI.  when running the Method in the Cockpit, it returns 9 entries

When running the form, and using the drop down box, it shows 10 entries, with 1 of the entries being duplicated.


Any ideas as to why

3 replies

Forum|alt.badge.img+5
  • Aug 1, 2017 10:31 AM UTC

Hi braddo.


I would like to help, is it possible that I can have your design view screenshot?

Translate

Forum|alt.badge.img+8

Braddo,

 Instead of creating a table you should think about creating a SQL view and in that view filter out duplicate values. Create a smartobject from that view and use it for your dropdown. This should solve your problem.

 

Thanks,

Bryan Peters

Translate

  • Jan 10, 2022 5:33 PM UTC

how can I create a SQL View out of my list? 

Could you kindly assist me on this? 

Translate