SAP PI -Maintenance

[Former Member]

Hi Experts,

For the PI Maintenance work i am need of the following requirment, but i have no idea how to start this so kindly help me to solve this.

The Client need a Report in EXCEL about the details of data which are interfaced through SAP PI daily and need to send a mail.

This should be happen for each scenario. How can i do this?

Regard's

Preethi.

[Former Member · Accepted solution]

Hi Preeti,

SXMSPMAST is the master table that holds the key information about each of the messages going through the Integration engine.

With the help of an ABAPer, write a program that collects the data from the table and create an interface that triggers E-mail to the specific user.

Regards,

[Former Member · Accepted solution]

Thanks for your immediate reply , i will try i t out and response back.

[Former Member · Accepted solution]

HI

How can i view this table.

[Former Member · Accepted solution]

IN the PI system, enter the TX code Se11 or Se16 and enter the table name to view the table.

[Former Member · Accepted solution]

Hi,

I go through the table i couldn't find out the payloads how can i do it. Because i need to send a mail with detail report of the data

processed through PI.

Regard's

Preethi.

[Former Member · Accepted solution]

Preethi,

Check out this external link which explains the most of the PI tables and their uses.

[http://d.logosworld.com/?q=node/100|http://d.logosworld.com/?q=node/100]

OR

[|]

Regards

Ramesh

[Former Member · Accepted solution]

Hi Preethi,

Use this table name : SXMSPMAST2 and search.