How to find out spool requist number respective Sales Order

[Former Member]

hi,

I need spool number respective to Sales Order, after print out script.While taking print out of sales order by selecting respective output type i am able to get spool request number in table TSP01 .Upto eveything fine .But how to find this spool request number is belongs to that Sales order.

Regards,

Eswar

[Former Member]

SELECT * FROM tsp01 WHERE

rq0name = sy-repid AND

rq1name = d_suffix1 AND

rq2name = d_suffix2 AND

rqowner = sy-uname.

WRITE:/ 'Spool request issued',

/ 'Spool Number:', tsp01-rqident,

/ 'Spool Name :', tsp01-rq0name,

/ 'Suffix 1 :' , tsp01-rq1name,

/ 'Suffix 2 :', tsp01-rq2name,

/ 'Owner :', tsp01-rqowner,

/ 'Device :',tsp01-rqdest,

/ 'Copies :', tsp01-rqcopies,

/ 'Processed :', tsp01-rqpjreq.

SKIP.

ENDSELE

[Former Member]

if same user may create number of Orders same day, then it will not work.

thanx,

Eswar

[Former Member]

No way to find out ...

[Former Member]

The program that creates the spool request should be able to determine it.

Rob

[amit_khare]

Spool request are not binds to modules.

Check the spool number in SP01.

Regards,

Amit

Rewad all helpful replies.