topic Re: Report in Background in Application Development and Automation Discussions

Report in Background

Former Member — Wed, 27 Jun 2012 05:58:27 GMT

Hi,

I have created a report. Selected all the data I require to pass to SAP Spool. I have all the data in Final Internal Table. Can anybody suggest how can i make this report to run in background. where I have to use FM's JOB_OPEN,JOB_SUBMIT,JOB_CLOSE in my report. Is it before the data selection. PLease suggest.

I need to understand the proper sequence of these FM's in my report.

Thanks,

Re: Report in Background

former_member209818 — Wed, 27 Jun 2012 06:08:29 GMT

Seems you are confused. If you have already selected all the data which you want in spool, then why don't you show all those details as a output of your own report and schedule that report in the background.?

The FM you are referring are mainly used for scheduling some background job. Support from program A you want to schedule a program B based on some condtions. Then you will call those FMs in Prog A to schedule the program B.

Re: Report in Background

Former Member — Wed, 27 Jun 2012 06:20:39 GMT

Background jobs are created using transaction SM36 and monitored using transaction SM37.

Get in touch with Basis guy to create a batch job.

Re: Report in Background

Former Member — Wed, 27 Jun 2012 06:24:06 GMT

Hi Vikas,

When you have all the data ready, just use REUSE_ALV_GRID_DISPLAY to show it as output. Then, execute the report in background. It will automatically create the spool and you can view your output in SP01.

Regards,

Sindhu Pulluru.

Re: Report in Background

RaymondGiuseppi — Wed, 27 Jun 2012 06:36:39 GMT

I'm not sure to understand you, the following trick will trigger background execution before start-of-selection.

AT SELECTION-SCREEN.
  CASE sscrfields-ucomm.
    WHEN 'ONLI' OR 'PRIN'.
        " You can add some checks here e.g. if a select-options is empty
        sscrfields-ucomm = 'SJOB'.
      ENDIF.
  ENDCASE.

Regards,

Raymond

Re: Report in Background

Former Member — Wed, 27 Jun 2012 06:40:03 GMT

In my last system REUSE_ALV_GRID_DISPLAY wont create a spool. Go for REUSE_ALV_LIST_DISPLAY. Not sure if the FM is modified or it was bug in our system.

Re: Report in Background

Former Member — Wed, 27 Jun 2012 06:45:59 GMT

Hi Chinmay,

May be you are true...But, I just used the same logic for one of my reports last week and I was able to create a spool with REUSE_ALV_GRID_DISPLAY.

Regards,

Sindhu Pulluru.

Re: Report in Background

Former Member — Wed, 27 Jun 2012 07:01:11 GMT

no need for job open close etc...

just use reuse_alv grid to display your report

on reuse alv parameters (is_print parameter)

is_print-no_print_listinfos = 'X'.

after scheduling your report, it will directly send to spool (se38->program->execute->background->schedule)