thanks for this fast response
i tried this solution and it's working good
but we buy sapconnector in order to have good fields definitions directly
we made some "SELECT * FROM TABLE"
and to apply this solution we have to specify all fields
and to correct all actual scripts
i will use your solution in production
thanks a lot one more time
Glad that it worked and you are welcome
The different Formats in SAP and different formats in Qlikview cannot be made to define the definitions directly. SAP connector is only for fetching the data as it is in the tables but these settings in your Qlikview suggest the basic Settings as below:
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
Some settings in the Qlikviewscript must be done if the format is not correct or if there is change in the transformation from one format to other.
when we have this in the database:
It should be not possible that QV+SapConnector load something like this:
Why QV add a ".E" --> I think it should have nothing todo with the different Formats!
QV can interpret "6307" as text or number --> but should not add a ".E"!
But of course, your solutiuon with the text(MFRPN) is working --> but I think this is only a workarround for this problem.
I have open a ticket bei QV and I waiting for an answer......