RSAQ_REMOTE_QUERY_CALL is there possible to limit columns to be returned?

[shokarta]

Hello all,

im using this FM/BAPI RSAQ_REMOTE_QUERY_CALL to retrieve data from SAP queries (SQ00/01) from my external program in VBA (not relevant information tho)

However the amount of data are huge and im consuming too much memory and execution time.

Therefore my question is, regarding this FM, is there possible to determine only which colums to be returned when i .CALL the BAPI?

I have tried several (even unlogical) ways to achieve that, with no luck tho...

[shokarta]

can I kindly ask if any developer can check?

[Tomas_Buryanek]

In RSAQ_REMOTE_QUERY_CALL you can filter returned rows with SELECTION_TABLE parameter. But you are asking for limiting columns. I do not know if is is possible using just the FM.

But one solution could be create a copy of the SAP query (yes in the SAP system) and modify this query to just return columns you want. Then call FM for this new query.