Trouble with SAP connection

Wed, 26 Aug 2015 15:28:29 GMT

Hi everybody!

I got a problem with SAP connection. I am using this connector:

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=192.168.142.9;SYSNR=10;CLIENT=100;KeepCasing=1;NullDate=1;XUserId=RYTUVIRJJaSMVEVIXSJA;XPassword=bZRLOBJNOJMCFLBOOTNaK;";

And I want to get the fields of CGPL_TEXT of PPM module.

But my problem is that the values of the GUID field in the CGPL_TEXT table have 24 chars and in SAP with 32 chars.

So, I can't get the real value.

I had read some Posts with this issue and I found that in the SAP connector some people add this parameter: ConvRoutine=1

But when I try this, I obtain this values in the GUID field:

The values of GUID field are completely changed. So, I need to get the values with 32 chars without changes. Another curious thing is that in other tables, i.e. RPM/BUCKET_D, I get the GUID field with 32 chars corresponding and I am using the same connector.

I need to get the GUID field with 32 chars to match it with others GUID of the others tables.

Thanks in advance!

Agus

topic Trouble with SAP connection in QlikView

Trouble with SAP connection