Skip to Content
0
Former Member
Nov 18, 2006 at 03:54 AM

unable to use LIST_TO_ASCI to convert into excel during background job

684 Views

Hi there!

on my report, i have a checked box to download result output into exce file. I use FM <b>'LIST_TO_ASCI'</b>, but it is only able to download a complete result when i execute it on foreground.

when i execute it as background job, only last page is converted to excel file. I found that I have to add <b>'SUBMIT reportname EXPORTING LIST TO MEMORY AND RETURN'</b> and <b>'LIST_FROM_MEMORY'</b>, but I have to fill in a lots of value on my selection screen such as company code, date range. User might also fill in many company codes in order to retrieve result as they expected.

Is there oher way of using the <b>'SUBMIT...EXPORTING LIST TO MEMORY AND RETURN'</b>? Can i use spool number generated to get the result & convert it? Will this affect the performance?

thanks a lot!