topic Re: spool request no. in Application Development and Automation Discussions

spool request no.

madan_ullasa — Fri, 07 Jul 2006 12:31:57 GMT

Hi frnds,

Can i anyway get the spool request no. within the print program dynamically once the form is output.

points assured to all replies.

Regards,

Madan..

Re: spool request no.

Simha_ — Fri, 07 Jul 2006 12:39:30 GMT

Hi,

after firing the print.

Get the latest spool number from TSP01 table(with date,user,latest one),which will store the spool numbers.

use F.M LIST_FROM_MEMORY

By this u can able to get the number.

Cheers,

Simha.

Re: spool request no.

Former Member — Fri, 07 Jul 2006 12:42:11 GMT

Hi,

Please check the Function Group SPOX for all function modules

Also check out FM RSPO_FIND_SPOOL_REQUESTS

RSPO_GET_ATTRIBUTES_SPOOLJOB

Hope this helps

Got another FM for it.

Message was edited by: Dominic Pappaly

Re: spool request no.

Former Member — Fri, 07 Jul 2006 13:39:30 GMT

Hi ,

Can use the following code :-

----

FORM get_spool_number *

----

Get the most recent spool created . *

----

--> F_REPID (prog. name) *
--> F_UNAME (user name ) *
--> F_RQIDENT *

----

form get_spool_number using f_repid

f_uname

changing f_rqident.

*-- Declaring local variables.

data:

lc_rq2name like tsp01-rq2name,

lc_rqident like tsp01-rqident.

*-- In TSP01 table, the 'RQ2NAME' field holds the combined

*-- ( first nine characters of the program name followed *-- by first three characters of the user name)value of

*-- the corresponding program and username.

concatenate f_repid+0(9)

f_uname+0(3)

into lc_rq2name .

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