Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Downloading in excel from sqvi report format in the background

Former Member

‎04-23-2014 11:57 AM

0 Kudos

Dear All,

We have developed couple of report using SQVI format for couple of reports. Now for those reports my client wants to download them in excel sheet and attach to the email, when email is triggered automatically to the specified email id's. This is urgent issue which need to be given b this week end. Thanking everyone in advance for your replies.

Regards

V. Srinivasa Ranganath

3 REPLIES 3

Former Member

‎04-23-2014 2:09 PM

0 Kudos

Hi Ranganath,

you can run SQVI in a background job and send the output to an email. But it won't be in excel format, although it can be opened in excel.

For more functionalities it will be required to use more advanced tools like ABAP.

regards,

Edgar

Former Member
In response to Former Member

‎04-23-2014 2:26 PM

0 Kudos

Hi Edgar,

Can you explain in detail how to run SQVI in background job. Also how to open the output in excel sheet if the output is not excel format. Also can you throw light on what you mean by more advance ABAP tools as I could not get the point that you are trying to convey.

Thanks in advance for your valuable reply.

Regards

V. Srinivasa Ranganath

Former Member
In response to Former Member

‎04-23-2014 2:40 PM

0 Kudos

Hi,

  1. Get the report name in selection screen of SQVI, something like AQ30SYSTQV000002MARA==========.
  2. Create a new job in SM36 with a step with this report
  3. In this job add a SPOOL Destination with defined email or list of emails

When job is executed the spool will be automatically sent to the mailing list. If email attachments configuration is to generate an attachment in html format, that html can be saved from Outlook to local disk and opened in excel, as many html files.

If you want something more professional you'll need to create a program in ABAP that actually does the same as the SQVI but creates a file in excel format, using abap2xlsx probably, and then sends it to the distribution list.

Most excel functions in SAP requires the Excel in the frontend computer, so they cannot work in background or in the server side. abap2xlsx is useful in this cases.

Regards,

Edgar