Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am able to see all tables for all owners but not able to see tables for SAPABAP1 user as owner via ODBC. I have granted ABAP_READ and ABAP_SYS_REPO to user for Qlik Sense.
I tried OLEDB but it is taking hell lot of time and even after 2 Hrs not able to view anything only wait / in progress circle is there.
Any help thanks in advance.
Regards
Have you managed to solve this issue? I have run into the same problem and perhaps we can exchange experience.
Hi Sorry for delay in response, I was not able to view tables but able to manage via script. I you know the table names and simple select statement you can do that.
Click on "Data Load Editor"
and write the connections and select commands in the end of the std script.
LIB CONNECT TO '<ODBC_Connection_NAME>';
SQL SELECT *
FROM SAPABAP1.KNA1;
SQL SELECT *
FROM SAPABAP1.BSAD;
SQL SELECT *
FROM SAPABAP1.BSID;
Now click on load data, then you are able to get above tables available for working in click sense.
Do let me know if it helped you.