Qlik Community

QlikView Connectors

amitarusi
New Contributor II

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

Tags (3)
6 Replies
yfe
Contributor III

Re: sap value unconverted field length trimmed

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
New Contributor II

Re: sap value unconverted field length trimmed

thanks Yaniv your solution helped me.

hugocesar
New Contributor

Re: sap value unconverted field length trimmed

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
New Contributor II

Re: sap value unconverted field length trimmed

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

hugocesar
New Contributor

Re: sap value unconverted field length trimmed

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
New Contributor II

Re: sap value unconverted field length trimmed

Try opening an OSS to SAP,

please update me if you find a solution.

Community Browser