ABAP tip : Download Spool Data

Download Spool Data

When the program is executed in background mode, the result written by ‘WRITE’ statement is saved into spool. In order to check the result, we use the spool button via T-CODE:SM37 to display the spool information. At this time, there is a restriction that it’s only possible to display spool within 10 pages. So, in case of lots of result lists, it’s very trivial to display the results and it’s sometimes impossible to do.

To display next 01 page, you should press the ‘settings’ button, and enter the page number from value and to value.

 

If you download the list at this screen, only 10 pages displayed are downloaded. It’s very difficult to download all data.

We usually use the below 2 methods to download spool data.

1. T-CODE:SP01 and download.

2. T-CODE:SE37 : function RSPO_DOWNLOAD_SPOOLJOB.

1. T-CODE:SP01 download

By using the spool number with SM37, you can download the spool into file. Enter the spool number and execute.

 

Press Menu : Forward -> Export as text

 

Once download is done, the file information is displayed on a status bar with the name of file and folder.

 

You can see the file in the folder.

 

2. T-CODE:SE37 and function RSPO_DOWNLOAD_SPOOLJOB

You can also download the spool by using function RSPO_DOWNLOAD_SPOOLJOB in T-CODE:SE37.

Enter the spool number in ID parameter and input the file name and folder for the rest of parameter.

 

There is a file downloaded in a destination folder.