Distribution of the Monthly Sales Report by
E-mail 
Objective
The responsible Sales Manager of a company would like provide his field sales representatives with regular updates of monthly sales data. He asks his assistant to distribute the monthly total sales report to all field sales representatives. In addition, the individual employees should also receive the sales result for the region for which they are responsible.
Procedure
Distributing Total Sales Reports
As the assistant to a Sales Manager, you receive the query that contains the relevant data (for example, the characteristics Region, Distribution Channel, Product, Product Group in the rows and the key figures Net Sales, Invoiced Quantity, Plan Sales, Percent Deviation in the columns and the characteristic CalYear/Month in the filter).from your company's IT department.
1.
You use the 
Standard Web
Template for Ad-hoc Analysis and open the query in the BEx Query
Designer.
2. Choose Publish ® BEx Broadcaster.
3. In the BEx Broadcaster, choose Create New Setting.
4. Enter a description, such as Monthly Sales Report.
5. Choose Send as E-mail as the distribution type and Standalone HTML File as output format.
6. In the Recipient tab page under User in Role, enter the role to which the field sales representatives are assigned. Choose your desired language. In the Texts tab page, enter a subject line for the e-mail. For example you could use the text variable Execution of the Setting: Calendar Year/Month (MONTH).
7. Choose the required importance and enter text under Content. So that employees also receive an online link to the total sales report and also have access to the current data as well as the document with the historic data, insert the text variable Online Link (PR_ONLINE_LINK) into the text.
8. Check your settings and choose Save.
9. Enter the technical name and choose Transfer. The new broadcast setting appears in the overview in the upper area of the BEx Broadcaster.
10. To distribute the broadcast setting monthly, choose Schedule.
11. Set the periodic indicator under Scheduling in SAP Background Processing and specify Every 1 Month(s) as the interval.
12. Choose Transfer.
Distributing Single, Personalized Sales Reports
...
You use the same query for this, save it as a copy and use variables for the Region characteristic. Employees only have authorization for their region. The query is precalculated according to user with the recipient authorizations and is filled with the corresponding variable values.
1. Open the query in the BEx Query Designer and choose Publish ® BEx Broadcaster.
2. In the BEx Broadcaster, choose Create New Setting.
3. Enter a description, such as Monthly Detailed Sales Report.
4. Choose Send as E-mail as the distribution type and Standalone HTML File as output format.
5. In the Recipient tab page under User in Role, output the role to which the field sales representatives are assigned????
6. So that the system can generate the document for each of the specified recipients with their personal settings (for example, language) and data authorizations, select User Specific.
7. In the Texts tab page, enter a subject line for the e-mail. Use a text variable as needed.
8. Choose the required importance and enter text under Content.
9. Check your settings and choose Save.
10. Enter the technical name and choose Transfer. The new broadcast setting appears in the overview in the upper area of the BEx Broadcaster.
11. To distribute the broadcast setting monthly, choose Schedule.
12. Set the periodic indicator under Scheduling in SAP Background Processing and enter Every 1 Month(s) as the interval.
13. Choose Transfer.
Result
Each field sales representative will receive two e-mails. One e-mail contains the monthly total sales report for all regions, the other e-mail contains the detailed sales report for the region that the field sales representative is responsible for.
You are also able to use the query as data provider in a Web application and you can distribute the Web application you created, which displays the data in a table and a chart, for example.
If your company prefers to work with MS Excel workbooks, you are able to use the query in a workbook, where you can schedule it periodically. Note that for the distribution of workbooks, you are unable to insert the additional online link to the total sales report.
In this case, you start the BEx Broadcaster from the BEx Web Application Designer or from the BEx Analyzer. For more information, see Functions of the BEx Broadcaster.
See also: