topic Re: Spool number generation! in Application Development and Automation Discussions

Spool number generation!

Former Member — Wed, 12 Mar 2008 09:01:33 GMT

Hi friends!

I am trying to submit a report from a program and take the output into a Spool as it is dynamic.

Could you please tell me how can I get the dynamic SPOOL number.

I tried that by capturing the SPOOL NUMBER into memory via current system time and date but this will fail if 2 spools will generate at the same time.

Any thoughts!

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 09:14:31 GMT

Hi,

If you want to get the output of your report as spool, Just execute the report in Background. Then check the job in SM37, there you can find the Spool display.

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 09:18:45 GMT

Hi,

In SAP Easy Access Menu

System -->Own Spool request

You Can Get The Number there

Reward If Helpful

Regards

Sandipan

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 09:24:29 GMT

Thank you.

Guys, the spool will be created via program that too dynamically and I need to capture that spool to convert it to PDF.

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 09:31:18 GMT

Try using syst fields sy-SPONO.

Thanks

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 12:28:04 GMT

Have tried that too.

But that system spool field is not filled.

Thanks.

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 12:46:11 GMT

Hi Park.

DATA: print_parameters TYPE pri_params,

archi_parameters TYPE arc_params,

valid_flag(1) TYPE c.

CALL FUNCTION 'GET_PRINT_PARAMETERS'

EXPORTING

archive_mode = '3'

IMPORTING

out_parameters = print_parameters

out_archive_parameters = archi_parameters

valid = valid_flag

EXCEPTIONS

invalid_print_params = 2

OTHERS = 4.

IF valid_flag = 'X' AND sy-subrc = 0.

SUBMIT submitable TO SAP-SPOOL

SPOOL PARAMETERS print_parameters

ARCHIVE PARAMETERS archi_parameters

WITHOUT SPOOL DYNPRO.

ENDIF.

This Will work.

Pls Reply if ur prblm is resolved.

Thanks

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 12:56:45 GMT

Hi,

If there is no spool means no output has generated from your program. Try to check in SP01 or table: TSP02F where the generated spools will be displayed.

If you are sure that the spool will be generated, try to debug and find why no output is generated.

Re: Spool number generation!

Former Member — Wed, 12 Mar 2008 13:02:28 GMT

Thanks Mahammad!

I have done exactly the same but I need to know what spool number is created for that so that I can take that spool and convert to PDF.

Thanks.

Re: Spool number generation!

Former Member — Thu, 13 Mar 2008 12:17:27 GMT

Any inputs on this?

Re: Spool number generation!

Former Member — Thu, 13 Mar 2008 14:56:08 GMT

Hi Park,

DATA: number TYPE tbtcjob-jobcount,

name TYPE tbtcjob-jobname VALUE 'JOB_TEST',

print_parameters TYPE pri_params.

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

CALL FUNCTION 'JOB_OPEN'

EXPORTING

jobname = name

IMPORTING

jobcount = number

EXCEPTIONS

cant_create_job = 1

invalid_job_data = 2

jobname_missing = 3

OTHERS = 4.

IF sy-subrc = 0.

SUBMIT ytest TO SAP-SPOOL

SPOOL PARAMETERS print_parameters

WITHOUT SPOOL DYNPRO

VIA JOB name NUMBER number

AND RETURN.

IF sy-subrc = 0.

CALL FUNCTION 'JOB_CLOSE'

EXPORTING

jobcount = number

jobname = name

strtimmed = 'X'

EXCEPTIONS

cant_start_immediate = 1

invalid_startdate = 2

jobname_missing = 3

job_close_failed = 4

job_nosteps = 5

job_notex = 6

lock_failed = 7

OTHERS = 8.

IF sy-subrc <> 0.

...

ENDIF.

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

From this u will get the job no. ->JOBCOUNT = number

with this jobcount read table TBTCP with key jobcount.

u will get the spool no.(LISTIDENT) from tht table.

use tht spool no to convert the spool to pdf.

Thanks

Re: Spool number generation!

Former Member — Thu, 13 Mar 2008 15:39:17 GMT

Hi,

u can use this.....

submit <report name> to sap-spool.

check its syntax (F1 hlp) for options available...

thanks Amit..

reward if helpful..

Re: Spool number generation!

Former Member — Tue, 18 Mar 2008 10:47:25 GMT

Thanks much, Mahammad!