Major issue in Data Extract from SAP HANA DB using ODBC connection
Hi Guys.
we are having SAP HANA as our ERP. To extract data from different tables of SAP HANA we are using ODBC Connection provided by SAP. While extracting data I found
1. In MBEW table (Inventory table of SAP HANA) , the Quantity and Amount field is showing 0 (zero) whereas in actual table there are values > 0
2. One table named MSEG which has all data related to material movement is retrieving zero records whereas in actual table there are huge amounts of data.
Earlier I faced this issue in SAP ECC6 / Qlikview, but then, by changing few parameters in SAP Extractor string, I could resolve this problem, but how to correct this in ODBC connection?