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.
Relevant read:
NACH To Find The Modules Output Device
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".
