topic Re: Message after submit report in Application Development and Automation Discussions

Message after submit report

Former Member — Mon, 06 Jun 2005 15:06:44 GMT

Hello all,

I have a program that submits a report. This report sends the output to the spool. When the process executes the submit command I get the following message:

Spool request (number &) created without immediate output.

I need the spool request number for further processing. Does anybody know how to get the message and the spool request number at runtime? Kind of like the messages we get with a call transaction into the message table. By the way, the message is NOT available in the system structure SY(SYST).

Re: Message after submit report

RichHeilman — Mon, 06 Jun 2005 15:11:39 GMT

Here is what I've done in the past.

1) in the submitted program, export the sy-spono to a memory id. This should be the very last statement of the program.

2) in the calling program, after the SUBMIT statment, import the spool number into memory id.

3) do what ever you need to do with the sy-spono.

Regards,

Rich Heilman

Re: Message after submit report

Former Member — Mon, 06 Jun 2005 15:11:42 GMT

The table "tsp01" contain all the spool request.

Can you try to extract data from this table with report name, owner, date and title?

Gianluca

Re: Message after submit report

Former Member — Mon, 06 Jun 2005 15:23:31 GMT

Thanks Rich and Simeone for the prompt answers. I do not want to export to memory because that means I will have to modify ALL the reports that need to be submitted with the program in question. Anyway I have a work around but it is not clean and I was hoping somebody would have a better idea.

Re: Message after submit report

christian_wohlfahrt — Tue, 07 Jun 2005 06:31:20 GMT

Hi Enrique,

maybe I missed the problem, but did you try SY-MSGV1 (or maybe SY-MSGV2)? If a message is displayed, system variables should be filled.

Regards,

Christian

Re: Message after submit report

athavanraja — Tue, 07 Jun 2005 07:11:56 GMT

did you try the sy-spono immediately after returning to the main program?

Regards

Raja