Need to extract/export spool files

[Former Member]

We have a solution which is sending most reports to our report repository (separate product).

Unfortunately, the tool we're using can't handle some reports which we're currently leaving in the spool. We've excluded these from normal cleanup, but it's not where we want to leave them.

We can select these via queries, but what we don't know is how to extract/export these reports to a directory so that we can copy them into our target repository.

I'm hoping that someone has some example code of how to use data we have in TSP01 about these reports to actually get the file to a file share on our server for this (we're running SAP on Windows).

Can someone post any examples of how to do this? We know it won't be exactly what we want to do and will need to modify the ABAP (if that's what the example is), but we'd like a jump start.

[Former Member]

We have a solution which is sending most reports to our report repository (separate product).

Unfortunately, the tool we're using can't handle some reports which we're currently leaving in the spool. We've excluded these from normal cleanup, but it's not where we want to leave them.

We can select these via queries, but what we don't know is how to extract/export these reports to a directory so that we can copy them into our target repository.

I'm hoping that someone has some example code of how to use data we have in TSP01 about these reports to actually get the file to a file share on our server for this (we're running SAP on Windows).

Can someone post any examples of how to do this? We know it won't be exactly what we want to do and will need to modify the ABAP (if that's what the example is), but we'd like a jump start.

[Former Member]

BTW, we need to do this from a batch job, not interactively. We create too many of them to have to have someone do this.

We want to create an ABAP to select the spool entries that are relevant, extract some data for those and also the spool file. Then we'll load that into our reports repository (based on Documentum).

So we want to run a batch job daily (maybe more often) to do this.

[Former Member]

Seems like RSPO_DOWNLOAD_SPOOLJOB may be the FM we need.

Bascially in order to retain the spool beyond the cleanup retention time period we're creating them by running the jobs under a specific account who's spools we're excluding from the cleanup.

So our goal is to select spools created by that account within a date range (say the last 24 hours) and export those along with a number of related fields from TSP01 about them.

Is that reasonable? Are we in the weeds? Any simple example?