DataTypeLegacyMode in SAP Connector

The connection string property ”DataTypeLegacyMode” is an undocumented property that tries to mimic the way older (legacy) connector fetches data. It will try to convert the data to numeric format and use that if the conversion succeeded, or else use the string representation. It’s undocumented because it’s not very well tested, and can have other unexpected side effects. So the customer is free to use it, but support for it is sparse. And R&D may potentially remove it in upcoming releases. R&D will however look more into datatype handling and formatting for upcoming releases.
 

It may resolve problems when the formatting of SAP data seems to be wrong. In particular with leading 0 
 

QlikView
Change the parameter "DataTypeLegacyMode=false;" to "DataTypeLegacyMode=1;" in the connection string. 
If the parameter does not exist, add "DataTypeLegacyMode=1;" within the connection string. For example:

CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=0;SNC_MODE=false;SNC_QOP=9;advancedProperties=1;ConvRoutine=false;CheckSeparator=false;Nulldate=true;
RemoveAllBlanks=false;ReplaceNullvalue=true;Trace=false;DataTypeLegacyMode=1;PacketSize=20000000;FetchBuffers=99999999;BufferPercentage=30;TimeOutBatch=6000;
TimeOutFetch=12000;TimeOutStartBatch=24000;BatchJobName=/QTQVC/READ_DATA;";

Qlik Sense
1. Change "DataTypeLegacyMode=false;" to "DataTypeLegacyMode=1;" in the connection string in QlikView. 
2. Disabling Standard mode of Qlik Sense. 
    http://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/LoadData/disable-standard-mode.htm 

3. In Data load editor, copy and paste the QlikView connection string to Qlik Sense app.