topic Re: Generate the spool no in Application Development and Automation Discussions

Generate the spool no

Former Member — Mon, 01 Dec 2008 10:51:45 GMT

Dear friends,

I have to generate the spool request no by self written code.

I want to creat this against an invoice no. TC : vf02

Can any one help me pelase.

Thanks and Regards

vivek srivastava

Former Member — Mon, 01 Dec 2008 11:05:31 GMT

i am not sure if its gonna help u

RSPO_RPRINT_SPOOLREQ.

but u can try it.

one more thing u can do is configure ur output type and associate a smartform and then supress its preview so only spool gets generated.

u can supress the preview by changing the amsrtform control parameters in the driver program

Former Member — Mon, 01 Dec 2008 11:09:58 GMT

Before submitting get the latest spool number from TSP01 table(with date,user,latest one),which will store the spool numbers.

after submitting again get the latest spool number from

TSP01 table(with date, user,latest one)and compare both of them previous one and present one.

if they are same then no spool, if they are not same then take the present one as new spool generated.

hope this helps

regards

Aakash Banga

Former Member — Mon, 01 Dec 2008 11:12:56 GMT

i think friend, it will work after the spool request generate.

i need the story befor generation of spool request.

Former Member — Mon, 01 Dec 2008 11:13:42 GMT

friend, it will work after the spool request generate.

i need the story befor generation of spool request.

Former Member — Mon, 01 Dec 2008 19:04:21 GMT

You can get the current spool number from TSP01.

select MAX(RQIDENT) into <Variable> from TSP01.

Add 1 to it..that will be your spool number.

Regards

Raj

Former Member — Thu, 04 Dec 2008 14:18:22 GMT

thanks