Scheduling background job.

[Former Member]

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.

Regards,

CHetan Dabke

[former_member220028]

Hi,

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.

regards

Stefan Seeburger

[raymond_giuseppi]

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.

Regards,
Raymond