Hi to all,

I configured Lookup with SAP HANA database using ODBC but as Quickfield Lookup not compatible with SAP HANA I am facing issue with records which some of the field value is empty.

for example

Invoice No | Amount |Salesman Code | Name | Location

001123       |0010       |                      123|     ABC |   Loo1

001124       |1200       |                             |             |   L002

001452       |9999        |                     002|    Tony |   L124

so what happen Lookup bring the record which row all field with value but what happens with the row which field some value is blank Lookup return with "0 Record Found"

My Lookup configured with Invoice Number.FI

which is the best alternate option to pull data from SAP HANA View to any other DB.

like MS-Access, MS-SQL, etc..

Regards,

Shiraj