Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amitarusi
Contributor III
Contributor III

sap value unconverted field length trimmed

hi,

i'm trying to load data from sap

table :cgpl_project

field: guid

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)

thanks

amit

6 Replies
Anonymous
Not applicable

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:

ConvRoutine=1

Cheers

Yaniv

amitarusi
Contributor III
Contributor III
Author

thanks Yaniv your solution helped me.

hugocesar
Partner - Contributor II
Partner - Contributor II

Hello Amit!

Good Afternoon

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

César

amitarusi
Contributor III
Contributor III
Author

Try to add the parameter ConvRoutine=1 to the connection string maby it will help you.

hugocesar
Partner - Contributor II
Partner - Contributor II

Hi Amit!

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.

Thank you

César

amitarusi
Contributor III
Contributor III
Author

Try opening an OSS to SAP,

please update me if you find a solution.