topic Re: Spool numbers stored in which table? in Application Development and Automation Discussions

Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:20:30 GMT

Hi,

Any idea where is spool numbers stored in sap table? Need to fetch based on job name........

Thanks in advance

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:22:14 GMT

TSP01

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:22:43 GMT

Hi,

The spool numbers are stored in the table TSP01.

The field name for spool no in the table is RQIDENT.

Regards,

Chetan.

PS:Reward points if this helps.

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:23:23 GMT

check table TSP01

based on job name

do like this tsp01-RQIDENT = TSPEVJOB-PJIDENT "ur need

query it on <b>TSPEVJOB-pjnumber</b> is the link. this will be ur job number.

table will be TSPEVJOB to look for and fetch the request from tsp01.

regards,

vijay

Message was edited by:

vijay k

Re: Spool numbers stored in which table?

srinivas_akiri — Wed, 13 Dec 2006 09:26:57 GMT

Try with

TSP01, TSP02, TSP03...TSP06

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:32:42 GMT

Hi,

Thanks but I need it based on job name. If I input jobname I shud get the spool.

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:34:41 GMT

You can use the fm:

BP_JOB_READ

the parameter-JOB_READ_JOBHEAD field-LISTIDENT will have the spool number.

or you can even check the table: TBTCP field LISTIDENT

Regards,

Ravi

Message was edited by:

Ravi Kanth Talagana

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:34:47 GMT

just chk with ur job number and spool request are present in this table

TSPEVJOB

regards,

vijay

Re: Spool numbers stored in which table?

Former Member — Wed, 13 Dec 2006 09:36:14 GMT

Hi,

Use this

LC_COVER is used as a title for spool. which can be used to get the spool id.

Latest can be fetched by sorting the LIT_SPOOL_ID in desc order.

SELECT RQIDENT

RQCRETIME

INTO TABLE LIT_SPOOL_ID

FROM TSP01

WHERE RQTITLE = LC_COVER.

Sort the table to pick up the latest spool number

SORT LIT_SPOOL_ID DESCENDING BY RQCRETIME.

Read the internal table to pass the latest spool id.

READ TABLE LIT_SPOOL_ID INDEX 1 INTO WA_SPOOL_ID.

Rgds,

Prakash