topic Re: Spool number in Application Development and Automation Discussions

Spool number

Former Member — Fri, 12 May 2006 13:05:29 GMT

I have to find out the spool request number created by my report , so as to convert the spool output into PDF.

or let me knwo how do i convert the spool output into PDF

Regards

Alok Pathak

Re: Spool number

suresh_datti — Fri, 12 May 2006 13:07:51 GMT

did you try the system variable SY-SPONO? & then pass the spool id to the function call 'CONVERT_ABAPSPOOLJOB_2_PDF' ?

Regards,

Suresh Datti

Re: Spool number

Former Member — Fri, 12 May 2006 13:14:04 GMT

Hello Alok,

If you are looking for spool number with a program then u can check syst-spono which has the spool number.

Re: Spool number

Former Member — Fri, 12 May 2006 13:25:19 GMT

see the std report RSTXPDFT4 to convert spool to pdf

If you want to go to PDF, there is another approach. There are SAP functions to convert SPOOL to PDF. They are CONVERT_ABAPSPOOLJOB_2_PDF and CONVERT_OTFSPOOLJOB_2_PDF. What you can do here is schedule your report as one step in a job and then your post processing as another step. You can use GET_JOB_RUNTIME_INFO to get the jobcount and jobname of the currently running job. You can then read back in table TBTCP to get the spool list number (listident) of a previous step.

Example:

clear jselect.

jselect-jobname = ''.

jselect-username = '*'.

****Have this program get its own Job Name

call function 'GET_JOB_RUNTIME_INFO'

importing

EVENTID =
EVENTPARM =
EXTERNAL_PROGRAM_ACTIVE =

jobcount = jselect-jobcount

jobname = jselect-jobname

STEPCOUNT =

exceptions

no_runtime_info = 1

others = 2.

****Read the spool number for this job step.

clear tbtcp.

select single listident from tbtcp

into tbtcp-listident

where jobname = jselect-jobname

and jobcount = jselect-jobcount

and stepcount = step.

if tbtcp-listident = 0.

message i009 with step.

endif.

data: spool_id like tsp01-rqident.

move tbtcp-listident to spool_id.

****Is this ABAP List Processing?

if abap = 'X'.

call function 'CONVERT_ABAPSPOOLJOB_2_PDF'

exporting

src_spoolid = spool_id

NO_DIALOG =
DST_DEVICE =
PDF_DESTINATION =
IMPORTING
PDF_BYTECOUNT =
PDF_SPOOLID =
LIST_PAGECOUNT =
BTC_JOBNAME =
BTC_JOBCOUNT =

tables

pdf = ipdf

exceptions

err_no_abap_spooljob = 1

err_no_spooljob = 2

err_no_permission = 3

err_conv_not_possible = 4

err_bad_destdevice = 5

user_cancelled = 6

err_spoolerror = 7

err_temseerror = 8

err_btcjob_open_failed = 9

err_btcjob_submit_failed = 10

err_btcjob_close_failed = 11

others = 12.

if sy-subrc <> 0.

message i016 with sy-subrc.

endif.

else.

****Or is this SAPscript?

call function 'CONVERT_OTFSPOOLJOB_2_PDF'

exporting

src_spoolid = spool_id

NO_DIALOG =
DST_DEVICE =
PDF_DESTINATION =
IMPORTING
PDF_BYTECOUNT =
PDF_SPOOLID =
OTF_PAGECOUNT =
BTC_JOBNAME =
BTC_JOBCOUNT =

tables

pdf = ipdf

exceptions

err_no_otf_spooljob = 1

err_no_spooljob = 2

err_no_permission = 3

err_conv_not_possible = 4

err_bad_dstdevice = 5

user_cancelled = 6

err_spoolerror = 7

err_temseerror = 8

err_btcjob_open_failed = 9

err_btcjob_submit_failed = 10

err_btcjob_close_failed = 11

others = 12.

if sy-subrc <> 0.

message i016 with sy-subrc.

endif.

Thanks&Regards

Naresh

Re: Spool number

athavanraja — Sat, 13 May 2006 07:13:51 GMT

within the same program if you are calling FM

GET_PRINT_PARAMETERS with new-page print on parameters wf_params no dialog. and write statements to create the spool then simply refer to sy-spono , it will have the spool created by your program

Regards

Raja

Re: Spool number

Former Member — Sat, 13 May 2006 07:26:21 GMT

Hai Alok Pathak

Check the following Code

Save Report Output to a PDF File

This report takes another report as input, and captures the output of that report. The output is then converted to

PDF and saved to a local file. This shows how to use some of the PDF function modules, as well as an easy way to

create PDF files.

Source Code Listing

report zabap_2_pdf.

*-- Enhancements: only allow to be run with variant. Then called

*-- program will be transparent to users

*-- TABLES

tables:

tsp01.

*-- STRUCTURES

data:

mstr_print_parms like pri_params,

mc_valid(1) type c,

mi_bytecount type i,

mi_length type i,

mi_rqident like tsp01-rqident.

*-- INTERNAL TABLES

data:

mtab_pdf like tline occurs 0 with header line,

mc_filename like rlgrap-filename.

*-- SELECTION SCREEN

parameters:

p_repid like sy-repid, " Report to execute

p_linsz like sy-linsz default 132, " Line size

p_paart like sy-paart default 'X_65_132'. " Paper Format

start-of-selection.

concatenate 'c:\'

p_repid

'.pdf'

into mc_filename.

*-- Setup the Print Parmaters

call function 'GET_PRINT_PARAMETERS'

exporting

authority= space

copies = '1'

cover_page = space

data_set = space

department = space

destination = space

expiration = '1'

immediately = space

in_archive_parameters = space

in_parameters = space

layout = space

mode = space

new_list_id = 'X'

no_dialog= 'X'

user = sy-uname

importing

out_parameters = mstr_print_parms

valid = mc_valid

exceptions

archive_info_not_found = 1

invalid_print_params = 2

invalid_archive_params = 3

others = 4.

*-- Make sure that a printer destination has been set up

*-- If this is not done the PDF function module ABENDS

if mstr_print_parms-pdest = space.

mstr_print_parms-pdest = 'LOCL'.

endif.

*-- Explicitly set line width, and output format so that

*-- the PDF conversion comes out OK

mstr_print_parms-linsz = p_linsz.

mstr_print_parms-paart = p_paart.

submit (p_repid) to sap-spool without spool dynpro

spool parameters mstr_print_parms

via selection-screen

and return.

*-- Find out what the spool number is that was just created

perform get_spool_number using sy-repid

sy-uname

changing mi_rqident.

*-- Convert Spool to PDF

call function 'CONVERT_ABAPSPOOLJOB_2_PDF'

exporting

src_spoolid= mi_rqident

no_dialog = space

dst_device = mstr_print_parms-pdest

importing

pdf_bytecount = mi_bytecount

tables

pdf = mtab_pdf

exceptions

err_no_abap_spooljob = 1

err_no_spooljob = 2

err_no_permission = 3

err_conv_not_possible = 4

err_bad_destdevice = 5

user_cancelled = 6

err_spoolerror = 7

err_temseerror = 8

err_btcjob_open_failed = 9

err_btcjob_submit_failed = 10

err_btcjob_close_failed = 11

others = 12.

call function 'DOWNLOAD'

exporting

bin_filesize = mi_bytecount

filename = mc_filename

filetype = 'BIN'

importing

act_filename = mc_filename

tables

data_tab = mtab_pdf.

----

FORM get_spool_number *

----

Get the most recent spool created by user/report *

----

--> F_REPID *
--> F_UNAME *
--> F_RQIDENT *

----

form get_spool_number using f_repid

f_uname

changing f_rqident.

data:

lc_rq2name like tsp01-rq2name.

concatenate f_repid+0(8)

f_uname+0(3)

into lc_rq2name separated by '_'.

select * from tsp01 where rq2name = lc_rq2name

order by rqcretime descending.

f_rqident = tsp01-rqident.

exit.

endselect.

if sy-subrc ne 0.

clear f_rqident.

endif.

endform." get_spool_number

Thanks & Regards

Sreenivasulu P

Re: Spool number

Former Member — Sat, 13 May 2006 09:37:56 GMT

Hi,

Try this :To get spool number.

DATA : lv_spool_no TYPE TSP01-RQIDENT .

SELECT RQIDENT into lv_spool_no

UP TO 1 ROWS

FROM TSP01

WHERE "Put some restriction ..like last 5 days, to improve performance

ORDER BY RQCRETIME DESCENDING.

ENDSELECT.

<b>Convert spool to PDF:</b>

SAP have created a standard program RSTXPDFT4 to convert your report spools into a PDF format.

Specify the spool number and you will be able to download the spool into your local harddisk.

rgds,

latheesh.

Re: Spool number

Former Member — Mon, 15 May 2006 18:40:18 GMT

Hi,

Plz check view V_OP.

Thanks,

Ravi