Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 - Brasil
Load *;
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 1826
Select SAPQUERY (QUERY (INVOICE_COND), VARIANT (BRASIL), USERGROUP (QLIKVIEW), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))
Thanks,
Ben
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.
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.