How to figure out which job generated which spool?
Given a spool number, how to know which job created this spool?
 
Solution:
 
Table TBTCPV has the spool-number in field LISTIDENT. 
 
You will have to join TBTCO/P to get at the job count, which will take you to the information in TBTCPV.
 
There are no transaction that leads you from a single spool in SP01 back to the job that generated it. 
 
Yes, there's a function 'where used' but obviously it doesn't do anything, neither on NW640 nor on NW700.
 
Now, stop a second and think about it - how could there be? 
 
Not every spool is generated by a job.  There are manual ones, ones coming from dialogue processes etc -> so, obviously: backtracking coming from the spool will not do, you have to go forward, starting with the cause: the job.
 
And then: start with queries now, you'll need them anyway - might as well do it from day #1.
 

Also,
 
Take a look at OSS Note 422136 which states:
 
"2. You can only store one spool request even if a step generates several spool requests during processing. The application is responsible for a "spool overview" in this case. If a step generates several spool requests during processing, only one request can be stored. In this case, the application report should issue the number with a message when writing a spool request so that it is then displayed in the job log."
 
Also take a look at OSS Note 519059 which further supports the case that you must capture the individual spool numbers as they are being created (i.e. within the job step's program). The note contains the following:
 
8] Question: How are the spool requests assigned?
 
Answer: The step information is stored in table TBTCP. This has space for exactly one spool request (field LISTIDENT). If a step generates several spool requests during the processing, only one can be stored. In this case the application is responsible for a "spool overview".

Get help for your Basis problems
Do you have a SAP Basis Question?

SAP Basis Admin Books
SAP System Administration, Security, Authorization, ALE, Performance Tuning Reference Books

SAP Basis Tips
SAP BC Tips and Basis Components Discussion Forum

Administration In SAP - Sapgui, Unix, SAP ITS, Router, Client Copy and IDES 

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com