CreateObject("SAP.Functions") Doesnt work in Qlikview ?

Fri, 03 Jan 2014 03:53:00 GMT

Hi, Im getting frustated, I want to extract data from R3 SAP system tables, I know there are other options like SAP Connector, several third party, etc. But arent free.

I use the OCX to connect with SAP to be able to call a RFC function. My problem is that the Macro in qlikview doesnt work, It just open my module windows I know that the problem is in the first line (in red). The thing is that the exactly same code used in Excel works fine.

Set R3 = CreateObject("SAP.Functions")

R3.Connection.client = "MANDT"

R3.Connection.User = "USER"

R3.Connection.Password = "PASS"

R3.Connection.Language = "EN"

R3.Connection.ApplicationServer = "HOST"

If R3.Connection.logon(0, True) <> True The


	msgbox ("CANNOT Log on to SAP")

else

msgbox ("Logged on to SAP")

end if

Anyone knows why this doesn't work on Qlikview 11 ? and why If I put this code inside the script is doesnt works gives me syntax error. Only can be used when the function is in the module windows.

Thx

Re: CreateObject("SAP.Functions") Doesnt work in Qlikview ?

Mon, 06 Jan 2014 20:16:51 GMT

The problem was this.

You have to allow the security level, like the image.

topic Re: CreateObject("SAP.Functions") Doesnt work in Qlikview ? in QlikView

CreateObject("SAP.Functions") Doesnt work in Qlikview ?

Re: CreateObject("SAP.Functions") Doesnt work in Qlikview ?