topic Spool Requests in Application Development and Automation Discussions

Spool Requests

Former Member — Fri, 18 Aug 2006 11:12:41 GMT

Hi all,

besides TSP01 & TSP02 are there any other ways of looking at spool request history ?

Thanks

Re: Spool Requests

Former Member — Fri, 18 Aug 2006 11:15:38 GMT

Try transaction sp01.

Re: Spool Requests

Laxmana_Appana_ — Fri, 18 Aug 2006 11:22:35 GMT

Hi,

You can see the spool requests from SP01 and SP02 transactions.

Regards

Appana

Re: Spool Requests

Former Member — Fri, 18 Aug 2006 13:01:38 GMT

Hi Guys

Thank you for your replies, I forgot to mention that we delete spool requests after 7 days so SP01 & SP01 are not much good in this case - I need to look at spool request history (3- 6 monts ago) Look for DB tables or history txn's - any ideas

Re: Spool Requests

Former Member — Fri, 18 Aug 2006 13:06:12 GMT

Hi Conor,

Check Table TBTCP.

Regards,

Vidya.

Re: Spool Requests

Former Member — Fri, 18 Aug 2006 13:06:55 GMT

Hi Conor,

the table tsp01 has a field RQDELETED which will be set to 'X' for spools that are deleted. Thety will still be there in the table i guess.

Regards,

Ravi

Re: Spool Requests

Former Member — Fri, 18 Aug 2006 13:18:40 GMT

Thanks Guys

Re: Spool Requests

kishore_soma — Mon, 03 Sep 2007 12:47:33 GMT

Hi ravikanth,

I also have the same problem, but can i recover that spool request which is deleted

Thnx

Kishore