Spool numbers stored in which table?

[Former Member]

Hi,

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

Thanks in advance

[Former Member]

TSP01

[Former Member]

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.

[Former Member]

Hi,

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

[Former Member]

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

[Former Member]

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

[srinivas_akiri]

Try with

TSP01, TSP02, TSP03...TSP06

[Former Member]

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

TSPEVJOB

regards,

vijay

[Former Member]

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