Generate the spool no

Former Member · ‎2008 Dec 01

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 · ‎2008 Dec 01

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 · ‎2008 Dec 01

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

i need the story befor generation of spool request.

Former Member · ‎2008 Dec 01

hi

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 · ‎2008 Dec 01

friend, it will work after the spool request generate.

i need the story befor generation of spool request.

Former Member · ‎2008 Dec 01

Hi

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 · ‎2008 Dec 04

thanks