Submit 'xxx' Exporting List to Memory returns no records for Extractor

[Former Member]

Hi Gurus,

I have created an extractor that remotely calls a report and retrieves data into SAP BW

When I'm testing the extractor in RSA3 it works perfectly fine however, when called from SAP BW it retrieves no data.

The reason is that in the extractor I'm calling the report in ERP the following way:

DATA: BEGIN OF list_tab OCCURS 0.

                INCLUDE STRUCTURE abaplist.

           END OF list_tab.

SUBMIT zmrmm_xx WITH SELECTION-TABLE rspar_tab WITH p_nozero = p_nozero

   EXPORTING LIST TO MEMORY

   AND RETURN.

It turned out that this statement works fine when testing it in RSA3 however when called remotely the table LIST_TAB is empty.

Do you guys have any idea what may be the reason and how to overcome it?

I supposed it must be some memory management-related issue.

Any suggestion will be appreciated!

Thanks,

Maciej

[horst_keller]

OCCURS 0 ???

[Former Member]

Okay so I declared my internal table the more appropriate way so it's something like this now:

DATA: list_tab type table of abaplist.

Still, my problem remains unsolved.

The piece of code from my initial message works perfectly fine tested in RSA3 in ECC but when invoked from SAP BW it returns 0 records.

[horst_keller]

EXPORTING LIST TO MEMORY exports to the ABAP memory that is local on the app server and available during call chains.

You must explain in more detail what you mean with "remotely"and "from SAP BW".

[Former Member]

Okay so just to let everyone know it was not memory-related issue.

Turned out technical user ALEREMOTE - used for data extraction -  did not have sufficient authorizations to run the report which was my source of data and failed at authorization check.

Always check your authorizations first!

Thanks for help,

Regards,

Maciej