Discussion Board for collaboration on QlikView Scripting.
I'm trying to use the SAPQueryConnector. I was able to use the wizard to generate this script:
CUSTOMCONNECT TO "Provider=QvSAPQueryConnector;ASHOST=epq;SYSNR=01;CLIENT=060;XUserId=JXSEaYRNJbaMXUVMXLQA;XPassword=DJMfRSBORLcYWUNNRZGA;";[Table0]: // Invoice with G/L Condition detail - Qlikview queries - BrasilLoad *;Select SAPQUERY (QUERY (INVOICE_COND), VARIANT (BRASIL), USERGROUP (QLIKVIEW), WORKSPACE ( ), EXTERNAL_PRESENTATION (S));
However, when I run it I get this:
Error: File .\extdata.cpp, Line 1826Select SAPQUERY (QUERY (INVOICE_COND), VARIANT (BRASIL), USERGROUP (QLIKVIEW), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))
Go to Solution.
It turns out this error is caused by the qlikview user in SAP not having the right security to execute the query.
To determine what is missing:-Logging into SAP using the qlikview account,-Executing the query via SQ00-Checking SU53 to see what authority object is missing.
Shouldn't there be a FROM somewhere in that statement?
The code provided was generated by the query wizards.So far I've no been able to locate an documentation on using the connector for ABAPQuery.
Any example of a working extract would be helpful.