Skip to Content
avatar image
Former Member

Scheduling background job.

Dear Experts,

We have created one ALV report with near about 100 columns in it. When we try to get output of same report in excel from SAP in foreground, it gets disturbed and it would not be readable at all, but when we transport the same through excel in MHTML format from SAP it would be fine.

My client requirement is to schedule the background job for same report and auto mail needs to be send to user mailbox. Hence now my requirement is how to schedule background job for which output will receive EXCEL in MHTML format to user mailbox.

Please give your valuable suggestions.


CHetan Dabke

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 22, 2016 at 07:42 AM

    You could build a wrapper or add in the code of a customer program. Use following classes

    • cl_salv_bs_runtime_info to get internal table, set metadata and data parameters (wrapper)
    • cl_salv_ex_util to convert to 'regenerate' the ALV session from data and metadata (wrapper)
    • cl_salv_bs_tt_util to convert to xml (always)

    Attach the xml to a mail (class cl_bcs, etc.) or store it on application server for further download.


    Add comment
    10|10000 characters needed characters exceeded

  • Dec 22, 2016 at 10:28 AM


    You can click on Download-Button in every ALV. unformated, tab-fomrated, Excel and HTML. you can do your own coding if u want to do some sort of this automatically at the end of the Report. In Background, the ALV-List you see with "display-ALV" gets automatically converted into a spool. this spool attached to the Job is kinda unformated.


    Stefan Seeburger

    Add comment
    10|10000 characters needed characters exceeded