Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Rahul
Contributor
Contributor

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?

 

Labels (4)
0 Replies