Implementing an Add-on for Sending DTP Monitor Log to E-mail

[sander_vanwilligen]

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.