Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Spool request download to Excel-Automatically

Former Member
0 Kudos
2,797

Hi,

I want to know whether it is possible to download (i.e either thru' some customisation) the output from the spool request to a excel sheet without any manual intervention ie.automatically.

Thanks

Suresh

1 ACCEPTED SOLUTION

Former Member
0 Kudos
168

Hi,

It is possible. You can use the folowing FM for converting the Spool to PDF

CONVERT_ABAPSPOOLJOB_2_PDF

CONVERT_OTFSPOOLJOB_2_PDF

If not you can get the Tempse id of the spool and use the FM

RSTS_OPEN_RB

RSTS_READ

This will give you the contents of the spool. Tempse object for the Spool can be found in the Spool Request Header

4 REPLIES 4

Former Member
0 Kudos
169

Hi,

It is possible. You can use the folowing FM for converting the Spool to PDF

CONVERT_ABAPSPOOLJOB_2_PDF

CONVERT_OTFSPOOLJOB_2_PDF

If not you can get the Tempse id of the spool and use the FM

RSTS_OPEN_RB

RSTS_READ

This will give you the contents of the spool. Tempse object for the Spool can be found in the Spool Request Header

0 Kudos
168

Hi Siva,

Thanks for your reply,

I tried to use FM: CONVERT_ABAPSPOOLJOB_2_PDF but the value in SRC_SPOOLID field is getting displayed as 30,611 instead of 30611 and because of this, the file is not downloaded.

Thanks

Suresh

0 Kudos
168

Hi,

Try passing the Spool ID programatically? That will not have separators and should work.

or else hard code the spool number.

Edited by: Siva Prakash on Jul 7, 2008 1:47 AM

Former Member
0 Kudos
168

close