Report  Distribution via e-Mail 

Homepage for SAP Professionals Tips & Tricks

Ever wanted to get daily or weekly status reports, open sales order lists and more e-mailed directly into your inbox? If you are on the latest SAP release or if your SAP System can e-mail to regular e-mails, you can receive these alerts to your regular e-mail address.

If you want to keep the information within SAP, get the notification into your Workplace (SAP e-mail).

Let’s assume that you want a daily report that lists all locked or unused users on a daily basis into your inbox. What you have to do is to schedule the report in background and set the recipient by clicking the ‘Spool List Recipient’. Set the flag to ‘Express’ if you want an instant notification upon successful execution of the report.

If you have multiple recipients you want to be notified, setup a ‘Distribution List’ via transaction SO23 or select the Distribution List option on your Business Workplace (SBWP) screen:

Make also sure that the user will receive a pop-up notification as soon as they log on the system via transaction SO16 by removing the flag on ‘No notification…’

The recipients will get a notification that they have unread e-mails and can view the report.

The user can then view the report:

If download is necessary, this can be done by exporting the attachment to an external file:

If you need to send large spool files via e-mail, this method may not work as desired as there is a 1000 line limit set in SAP. This is due to possible performance issues as for example a 400 pages report can easily generate a 12MB file. You can try the following alternative solutions:

1. Increase the number of lines you want to allow to be processed (note: system performance may be an issue if you apply this note). Apply OSS Note: 329537
2. Setup a Device Type with access method 'M' to have the spool file e-mailed to a recipient directly. This method doesn't seem to have any limits on number of lines (as far as we could verify on our ECC5 system).
3. If you won't use the attachment for further processing, you can setup a PDF output device (ZPDF or PDF1) to convert the output in PDF format and e-mailing it by setting up your PDF device with access Method 'M'. See OSS Note 317851
4. Setup background jobs with a generic background ID that doesn't generate sensitive reports and allow users to access these spool files with SP01. Special security setup can be provided to users so that they cannot access any other spool files but own and for the generic background ID.


  Contact us


Advertising



Print This Page

 

 

Copyright 1997 - 2010 by Home4SAP.com  
For suggestions and comments, please click here - [an error occurred while processing this directive]