Skip to Content

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.
To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. André PIRES

    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é
     

    (1) 

Leave a Reply