topic Re: Spool Extract/Reformat Program in Application Development and Automation Discussions

Spool Extract/Reformat Program

Former Member — Fri, 02 May 2008 11:56:41 GMT

Does anyone know of a process/program that can reformat/download a spool file (non-ALV)? We’re trying to automate a download of various reports one of which is from t-code co28. When we run the program in the background we want to auto download and reformat the spool files that get generated (Removing header rows, blank rows, and page number rows, etc). The intent of the files is to be loaded into an external database like access or even pulled up in Excel without having to manually remove any of the extra “header” row info. Any insight is greatly appreciated.

Thanks, David

Re: Spool Extract/Reformat Program

Former Member — Fri, 02 May 2008 12:34:28 GMT

Hi David,

There is a function module to download the spool data. Later we need to reprocess that data, and then prepare it in a way suitable to usby downloading the whole spool data into an internal table and format it according to our interest.

While executing your background job, try and hold the spool id in a variable and then use this FM,

'RSPO_RETURN_SPOOLJOB'.*

Example of using this FM:

*********************************************************************

CALL FUNCTION 'RSPO_RETURN_SPOOLJOB'

EXPORTING

rqident = wa_it_spool_attr-spoolid

first_line = startline

last_line = endline

desired_type = 'RAW'

TABLES

buffer = it_buffer

EXCEPTIONS

no_such_job = 1

job_contains_no_data = 2

selection_empty = 3

no_permission = 4

can_not_access = 5

read_error = 6

type_no_match = 7

OTHERS = 8.

*********************************************************************

Hope this is helpful to you. If you need further information, revert back.

Reward all the helpful answers.

Regards

Nagaraj T

Re: Spool Extract/Reformat Program

Former Member — Fri, 02 May 2008 12:41:32 GMT

Hi David,

you can get the spool file data with FM RSPO_RETURN_ABAP_SPOOLJOB. This will just return a flat internal table with the text of the spool. With this you can do whatever you need. You can probably also do some smart things with other function modules in package SPOO, like determining the page length etc.

Good luck,

Gert.

Re: Spool Extract/Reformat Program

Former Member — Fri, 02 May 2008 12:52:16 GMT

Thanks those will be helpful hints but I was hoping there would be something standard in the SAP ABAP programs to reformat spool files. Do you know if there is anything?

David

Re: Spool Extract/Reformat Program

Former Member — Tue, 20 May 2008 18:04:06 GMT

These will help us to develop something in-house as I was hoping there was something standard that SAP provided but there isn't. I also find Compelo software thru symtrax which will accomodate this but you have to purchase and manage the software. The site is http://www.symtrax.com/

Not sure if we will use Symtrax yet or not.