Implementing an Add-on for Sending DTP Monitor Log to E-mail
Monitoring data loads can be considered as a recurring daily activity for any BW Support Organization. In some cases it is also required to have a deep-dive into the DTP Monitor Log, e.g. for observing any “data related issues”. Often this task is assigned to a Functional Application Manager or Business User who might not have access to the BW back-end. It would be convenient to automate the process by sending DTP Monitor Log entries by e-mail to one or several receipients.
Please refer to my blog Introducing an Add-on for Sending DTP Monitor Log to E-mail for an introduction of a comprehensive ABAP Add-on which I developed for facilitating this process. In this document I would like to share detailed implementation instructions.
Please have a look here to download the attachments.
Step 1: Create Message Class
SAP Menu: Tools > ABAP Workbench > Development > Programming Environment > Messages
T/code: SE91
Create Message Class YDTPMAIL as shown in the screenshots.
Figure 1: Message Class (1)
Figure 2: Message Class (2)
Refer to the attached file YCX_DTPLOG_TO_EMAIL_and_YDTPMAIL_v1.txt (Part 1) for an overview of all messages with their short text.
Step 2: Create Exception Class
SAP Menu: Tools > ABAP Workbench > Development > Class Builder
T/code: SE24
Create class YCX_DTPLOG_TO_EMAIL as shown in the screenshots. Make sure that you flag checkbox With Message Class.
Figure 3: Exception Class (1)
Furthermore, specify on the Properties tab Message Class YDTPMAIL.
Figure 4: Exception Class (2)
From here you can quite easily build up the class using copy & paste:
- Refer to the attached file YCX_DTPLOG_TO_EMAIL_and_YDTPMAIL_v1.txt (Part 2) for the source code to be inserted in the public section of the class (via menu: Goto > Sections > Public Section);
- Refer to the attached file YCX_DTPLOG_TO_EMAIL_and_YDTPMAIL_v1.txt (Part 3) for the source code to be inserted in method CREATE_MSG
- Refer to the attached file YCX_DTPLOG_TO_EMAIL_and_YDTPMAIL_v1.txt (Part 4) for all descriptions used in the class.
Step 3: Create Class
SAP Menu: Tools > ABAP Workbench > Development > Class Builder
T/code: SE24
Create class YCL_DTPLOG_TO_EMAIL as shown in the screenshot.
Figure 5: Class
From here you can quite easily build up the class using copy & paste:
- Refer to the attached file YCL_DTPLOG_TO_EMAIL_v1.txt (Part 1) for the source code to be inserted using the Source Code-based maintenance mode;
- Refer to the attached file YCL_DTPLOG_TO_EMAIL_v1.txt (Part 2) for all descriptions used in the class.
Step 4: Create Program
SAP Menu: Tools > ABAP Workbench > Development > ABAP Editor
T/code: SE38
Create Program YBW_DTPLOG_TO_EMAIL as shown in the screenshots.
Figure 6: Program
Refer to the attached file YBW_DTPLOG_TO_EMAIL_v1.txt. From here you can quite easily build up the program using copy & paste:
- Source code can be found in Part 1 of the attached file;
- Description of Title, Text Symbols and Selection Texts can be found in Part 2 of the attached file.
Hi,
I dont find the attachment here with. Can you please let me know how can i get the source code for the class
Thanks
Dhinesh
Hello
I'd be very interested in checking out this DTP send mail process, this looks great (almost a standard missing feature). Where can I find the files containing source code for Class methods and ABAP reports?
Thanks for answer
André
Hi André,
Thanks for your positive feedback and sorry for my late reaction. The attachments were lost during migration and cannot be added anymore in the blog.
Please have a look at Q&A https://answers.sap.com/questions/106524/where-can-i-find-attachments-of-blog-implementing-2.html to download the attachments.
Best regards,
Sander