Skip to Content
Author's profile photo Sander van Willigen

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.jpg

Figure 1: Message Class (1)

 

Figure_2_Message_Class_2.jpg

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.jpg

Figure 3: Exception Class (1)

 

Furthermore, specify on the Properties tab Message Class YDTPMAIL.

 

Figure_4_Exception_Class_2.jpg

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.jpg

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.jpg

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.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      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é
       

      Author's profile photo Sander van Willigen
      Sander van Willigen
      Blog Post Author

      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