Skip to Content
0

How to extract historic data from SAP PI/GRC

Dec 04, 2017 at 09:30 AM

51

avatar image

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.

Regards

Bhargava Krishna

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Iñaki Vila Dec 04, 2017 at 12:12 PM
0

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

https://blogs.sap.com/2015/01/22/reading-messages-from-pi-system/

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

Regards

Show 1 Share
10 |10000 characters needed characters left 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.

Regards

Bhargava Krishna

0