It is always good to test a BAPI using the 'Test tool' in transaction SE37 in SAP, before you execute it from the connector. There you can find out more about which output table to use. Don't forget to check that the function module is 'Remote-Enabled' (Attributes tab).
The content of the output table sent to Qlik is only temporary, so there is no need to clear any memory in SAP after executing the BAPI.
Is there any possibility to get a solution for the following problem?
I have a function which takes a long time to run. I need to run it 2 times, to get 2 different table.
Or I will ask to our abap developer for changing the function.