Need a Report for PI Messages for Selected Period of Time

[Former Member]

Dear experts,

I need to have one report for my Businees case:

For a particular period of time Eg: say (01/01/2008 to 01/12/2008) i need a report with following details

as follows:

Interface , Nos of Message , Error Msgs , Processes Msg, Cancelled Msgs ,Nos of bytes(Size)

Kindly help me how to generate a report for this fields in PI.

Thanks in advance guys.

[prateek]

The tables required to accessed for creating the report would be SXMSPMAST, SXMSPERRO2 and SXMSPFRAWH.

Regards,

Prateek

[Former Member]

Hi,

Are we not having any standard report to generate for this requirement.

[prateek]

Your requirement doesnt seem to be a standard functionality of PI. So you will have to write your own report.

Regards,

Prateek

[former_member206760]

use table SXMSPMAST2

[Former Member]

The messages persist in the database tabls: reference the tables described in following blog, and write ABAP report based on your requirment:

Interesting ABAP tables in XI u2013 Part I

/people/gourav.khare2/blog/2007/12/12/interesting-abap-tables-in-xi-150-part-i

Regards

Liang