Skip to Content

Automation of PI/PO message dashboard monitoring

Hello All,

This automation enables monitoring of PI/PO system by using ECC system(You can use any third party system which can send HTTP request and get response).

We can access PI message overview data by using external tools via MessageOverviewQueryServlet.

This servlet is provided by sap which can be used any time when you need to send the RWB message overview data to an external system.

You can access the servlet by using below URL


It will display all components in which you can make a query

Select PI component and append it to query string

http://<host>:<port>/mdt/messageoverviewqueryservlet ?component=<XIComponentName>

Now select view as per your requirement and build query

http://<host>:<port>/mdt/messageoverviewqueryservlet ?component=<XIComponentName>&view=<ViewNameKey>

Available options of views are as follows

  1.  R_ENTRY_VIEW_XPI– Message status sorted by receiver
  2. S_ENTRY_VIEW_XPI– Message status sorted by receiver
  3. SR_ENTRY_VIEW_XP– Message status sorted by sender and receiver (detail view)
  4. SR_ENTRY_OVERVIEW_XPI– Message status sorted by sender and receiver (overview)

Now you have to specify interval in your query which completes your query

Format of StartDateTime and EndDateTimeis YYYY-MM-DD hh:mm:ss.0

which can be obtained from above qeury

Final Request Query will be

http://<host>:<port>/mdt/messageoverviewqueryservlet ?component=<XIComponentName>&view=<ViewNameKey>&begin=<StartDateTime>&end=<EndDateTime>

Now to retrieve and process response you need xsd which will be obtain from below URL


For detailed information of above mention steps refer below blogs

Now lets get started with PI configuration

Here I have used ECC system hence I have created sync proxy

Its Proxy SOAP to REST scenario

ESR Objects

To send interval dynamically we havecreated a program in ECC system.

Create data type to send request which will send StartDateTime & EndDateTime

Create message type of the same

Now import xsd file external definition to request and get response from servlet

Create data type to transform received response from servlet

Create Message type of the same

Create Outbound and Inbound Service interfaces

Create Request and Response Mapping

Create Operation mapping and assign Request and response mapping to it

Now lets Configure the ID objects

ID Objects

Create proxy Sender channel

Receiver channel

Create Rest channel with GET operation, and use basic authentication option.

URI till View name will be constant and we will be passing interval parameters through payload

Final step is to configure ICO as below

ABAP Program

Selection screen

This program has two variants one which will run on hourly basis to fetch data on basis and another variant run only once a day to fetch daily data.

Input to proxy

Synchronous proxy call

Output Received in proxy


Request Payload

Response Payload


You must be Logged on to comment or reply to a post.
  • Hi Chetan,

    I am not able to understand how to add RowData in response mapping? Please help me out with any reference link or something else.


    Pratik Gavas

  • Hi ,


    I want to develop the same scenario , but not receiving the response correctly , Response is coming in the below format :

    var inPortalScript = false
    var webpath = “/logon_ui_resources/”

    <BASE target=”_self”>
    <link rel=stylesheet href=”/logon_ui_resources/css/ur/ur_ie5.css”>
    <title>User Management, SAP AG</title>
    <script language=”javascript”>
    function restoreWindow() {
    } catch(ex){}
    <script language=”JavaScript”>
    function putFocus(formInst, elementInst) {
    if (document.forms.length > 0) {

    function setValuesAutoCreation() {
    var form = document.getElementById(‘logonForm’);
    function submitForm() {
    var form = document.getElementById(‘logonForm’);



    Can you please help me in this regard .

    • Hi,

      First try to fetch response using any tool which supports REST/HTTP request like postman or soapUI.

      Also dont just post blind copy response, provide all the details of your configuration.


      Chetan Risbud