To create BEx broadcast settings via ABAP program dynamically instead of via portal.
Author(s): Khaja Kamaluddin, Divya John, Vinay Singh.
Company: Larsen and Toubro InfoTech.
Created on: 07 April 2014
Khaja Kamaluddin has 6.4 years of experience in SAP BW and ABAP, started his career as an ABAP programmer over a period shifted to SAP BW/ BI, he worked in support, implementation, upgrade and enhancement projects.
Vinay Singh has 3 Year of experience as a BI ABAP consultant.
Divya John has 3 years experience as an ABAP Programmer.
The Requirement is for pushing mails with BEx workbooks to subscribing users at a given frequency. For every user , in order to broadcast mail , settings need to be created manually in Portal . For a large number of users/subscribers it would be difficult to maintain settings manually. Hence the need for creating settings dynamically using ABAP Program.
Initially required Users and their relevant details like email id , workbook id , report name etc are maintained in Z-Table. Settings and mail body are then created for each User and these settings are broadcast using Pre-Calculation server. Also if any settings have not been broadcast, then these settings are reprocessed and pushed.
In this document creation of BEx Broadcast settings using ABAP program is explained.
Users for whom BEx broadcast settings are to be created are maintained in a Ztable with details like their email id , workbook id , report name etc.
Enter the email address , authorization user in recipients tab.
Choose the method of distribution of document.
Provide email address, subject and body of mail.
Schedule the broadcast as per required frequency.
In above window assign variable and Pre calculation server and execute.
On successful execution, above log is displayed and the workbook is broadcast to the recipient.
The new settings created in this process is outlined in red.
The entire process is being done now with the ABAP program given below .
Advantages with the ABAP program:-
ABAP program flow is given below :-
And also maintains all the created settings for budget owners in Z-Table ZBROADSET
Here we also compose email body to which workbook will be attached and sent
The working of the program is as follows:
Figure 1.Program to create settings
Figure 2.Top include for settings program
Figure 3.Class used
Please include at least three references to SDN documents or web pages.