Skip to Content

How to extract historic data from SAP PI/GRC

Hi All,

My client is migrating from SAP NFE solution to third-party nfe solution. So we need to move all the historic data from from the year 2008 to till date [From SAP GRC/PI to third-party solution] and generate xml files for each message with the access key number "Available in the payload". We could see the messages in moni from Feb 2015 only.

As per my knowledge all the message payloads, that were processed will be stored in tables SXMSPMAST, SXMSCLUP, SXMSPCLUR.

1) From Feb 2015 to till date we have message entries (2200) in MONI, but it will be very difficult to do it manually.. Do we have any standard reports in SAP PI / GRC which will fetch the message payloads based on message id and generate xml file?

2) How to extract the data from the above tables? how to identify and filter message payloads related specific interface and generate a file with access key?

3) Old messages (2008 to 2015) were archived, How to extract these messages?

Please help us..

Thanks in advance.


Bhargava Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 04, 2017 at 12:12 PM

    Hi Bhargava,

    What is your PI version?, since PI 7.1 you have a set of webservices that you can use to retrieve certain data from PI, check this link

    In this way, for example you can do a java program to retrieve the monitoring data required and to give your goal output.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Inaki,

      Thanks for your response. I will go through the blog and get in touch with you in case of any queries.

      We are on SAP PI release 702 / SP 16.


      Bhargava Krishna