We tried limiting the List by restricting the Qlik extraction user to a dedicated Qlikview query user group, that contains just 3 queries. Still, when we connect it looks that SAP keeps checking All queries..... Maybe there is an additional setting in SAP that we need to do?
We are using SAP connector 5.8
Yes, it is possible to write the query directly in the script, but maybe not easy to get right.
A simple query could look something like this:
CUSTOM CONNECT TO "Provider=QvSAPQueryConnector.dll;ASHOST=x1.x2.x3.x4;SYSNR=00;CLIENT=800;XUserId=xyz;XPassword=xyz;";
[Table0]: // Material Tesx
Select SAPQUERY (QUERY (ZMAKT), USERGROUP (QLIKVIEW), WORKSPACE (G), EXTERNAL_PRESENTATION (S), VARIANT (TEST_LANGU_01));
Otherwise, restricting the user groups is a good method as mentioned previously. Try checking the transaction SQ03 in the SAP Gui to verify the groups your user has access to.
Please attach your connector log which shows the issue.