Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trouble with SAP connection

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.

Duda CGPL_TEXT.png

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:

Duda CGPL_TEXT_1.png

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.

Bucket_D.png

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

Thanks in advance!

Agus

0 Replies