Finding the Background job name from Spool request number

[Former Member]

Hi All,

Is there any table where I can get the job name providing the Spool number from where its generated.

If possible please provide me the table names where Jobs and Spool are stored.

I tried some tables but of no use...

Please help me out.

Thanks,

Sagar

Edited by: Sagar@MM on Jul 23, 2009 7:58 PM

[former_member404244]

HI,

TSP01 is the table where you can get the spool request.

Regards,

Nagaraj

[Former Member]

Hi Nagraj,

Thnx for the quick response...but I tried that table and there is no details about the job.

I have the spool request number with me but asked to findout the Job which made it generated.

Can you please let me know if there are any other tables which can provide some link between Job and Spool.

Thanks,

Sagar

[former_member404244]

HI,

Check this tabel TBTCO FOR Jobs.Also check this TBTC_SPOOLID and TBTCA

Regards,

Nagaraj

Edited by: nagaraj kumar nishtala on Jul 23, 2009 2:12 PM

[Former Member]

Hi,

U can get the Job detials from Transp. Table : TBTCP. The Feilde name is LISTIDENT [ ID of batch job output list in the spool ].

U may also try checking if any function module exists for the same (Byt doing a Where Used for TBTCP-LISTIDENT).....

Regards,

Bhargava

[Former Member]

Very helpful, thank you.  TBTCP worked for me also.

[Former Member]

Hi Bhargava & Nagaraj,

Thanks a lot....TBTCP is working.....

Thanks,

Sagar

[Former Member]

Hi,

I found in TBTCP table.

Thanks,

Jena.