Thank you Yaniv
I tried this parameter in the connection string. It did not change anything.
The field ZC_MAt in BW is a Char 18
The values can be anything. Here is a sample
And the issue is "217"- become -"217" when it is fetched in Qlikview
Hope this will provide more hint on the issue.
You don't say which connetor release you are using. However in release 6.1.1 there was a change that probably will fix your problem. Before that release character strings containing only digits (and '-' sign') were regarded as numeric and the '-' sign was moved to the left.
From the Release notes for 6.1.1:
The SAP data types CHAR (character) and NUMC (numeric character) were previously interpreted (in the Qlik script) as ‘numeric’ if they contained only digits. Leading zeroes were removed. (0000141000 became 141000).
Now they are always interpreted as ‘text’. Leading zeroes are kept. These data types are not often used in calculations, but if they are the new behavior might require script changes since calculations expects numeric values
Please consult the QlikView/Sense documentation on how to work with number and text formatting in QlikView/Sense. http://help.qlik.com/