ABAP Program to connect PI Java Schema Tables

[Former Member]

All,

I am working on a requirement to send alerts for messages in delireving status for more than 30 mins on AE. For that I need to create a ABAP program.

I have done the same for messages on the ABAP stack (in Running status for more than 30 mins) and it works fine. Now would like to move forward to do the same for messages on Java stack.

Please let me know if someone has worked on a similar thing and any suggestions on how to go about this.

[iaki_vila]

Hi Vicky,

I think if your basis team give you the schema and corresponding permisions you can access that PI Java DB schema like another DB schema with ABAP native SQL: http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

From another side, perhaps you find interesting retrieve information about the services excecuting a standard webservice like Michal Krawczyk's pointed in his blog.http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/04/13/pixi-how-to-get-a-pi-message-from...

Also, this thread deals about this theme: http://scn.sap.com/thread/1794255

Regards

[Former Member]

Thanks Inaki,

But where do I create the actual database connection to Java schema...would it be a system level setting on abap stack or from within my abap program.

The webservices as mentioned in Michal blog does not have an option of searching the messages by status. So I am guessing the ABAP program is the only route.