Spool output

[Former Member]

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.

[rui_nunes]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

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