topic Re: Spool output in Application Development and Automation Discussions

Spool output

Former Member — Tue, 31 Oct 2006 19:14:58 GMT

Hi,

I have a Z report that has a character width of approx 2000 characters. We cannot run this report in the background since the spool gets truncated(list format max being 1023) and the output is useless. Can someone suggest a way to run this report in the background so that the output can be downloaded in excel with each record in a single row and not divided into multiple rows.

Thanks in advance.

Re: Spool output

rui_nunes — Wed, 01 Nov 2006 15:40:13 GMT

You can change the program to download the report directly into a file instead of using the spool/report output. I think it's the best way to do it if you want to run the report in background mode.

Hope it helps,

Rui

Re: Spool output

Former Member — Wed, 01 Nov 2006 20:24:31 GMT

Hi Rui,

Thanks for the reply. I am not a technical consultant. Can you please tell me what you mean by writing directly to file? Do you mean write a custom ABAP code to write it to an excel file once the program is run in the background or would it be a basis function?

Re: Spool output

Former Member — Thu, 02 Nov 2006 18:27:30 GMT

It has to be ABAP code change.

You mentioned that it is a Z report. This report needs to be modified.

In the code have something like this


IF SY-BATCH EQ 'X'.
* Program is running in background.
* Download to file code here. 
* Also, you will have to do it using the OPEN DATASET
* commands. IN background, you cannot use any of the
* GUI/OLE related functions
* Since you said that you are not technical, please consult your ABAP programmer regarding this.
ELSE.
* Current online report code.
ENDIF.

Hope it clarifies your doubt.

Regards,

-Ramesh

Re: Spool output

Former Member — Mon, 13 Nov 2006 12:48:26 GMT

When the job is running in batch, the files can be stored in Application server - Unix.

Better Use INDX table to store the data in Unix and retrive the same using EXPORT and IMPORT statments. Download the data to the presentation server from application server and you can get the output as you wish.If you need the format also I can help you.

Warm Regards,

Baburaj