i'm trying to load data from sap
the data that qlikview loads is the unconverted value of the field, i can live with that.
the problem is that the unconverted value length should be 32 chars but i get only 24 char to qlikview after the sql select.
i'm using the latest version of the sap connector (5.8 SR4)
I'm not sure I could help with the 24 chars issue..
However, you may try extracting the external format (converted) of the field by setting the following parameter in the connection string:
thanks Yaniv your solution helped me.
i´m having exactly the same problem. in some tables i have 24 chars and other with 32 in PPM module. Could you solve the problem?
Thank you so much
Try to add the parameter ConvRoutine=1 to the connection string maby it will help you.
Thank you for your response. Yes, i did it but it does not work because it changes the guid value. I will looking for the solution.
Try opening an OSS to SAP,
please update me if you find a solution.