How to XML Messages Export to Excel

[Former Member]

Hi,

In NW2004s PI7, under oracle 10g, windows 2003server...

TR: SXMB_MONI (Integration Engine XML Messsages) how to export these xml messages to in Microsoft Excel - Automatically ?

Do I have to writedown any ABAP program... or is that posible from SQL ?

Is that, XML messages only one table XI_AF_MSG or combine of tables?

Regards

Thank in Advance

[Former Member]

I think I have douplicate messages open so I am closeing this one

[former_member181962]

Hi Angeline,

Do you want to download the payload information (The actual XML message) or the report that you see in SXMB_MONI?

If you want to download the report, then there is an option just above the records "Export", then click on the Spreadsheet option in the list box that you see .

Regards,

Ravi Kanth Talagana

[Former Member]

Hi Ravi,

Thanks for reply, basically I want Interigration Engine all XML messages report to excel sheet or txt file... I know that option for export to excel... but our requirenment we have to export daily all messages to excel, I want that process will run automaticlaly

Regards

[Former Member]

I dont think this scheduler option is avaialble in PI.

You can write a ABAP Program to fetch the messages and write it in "Excel" format.

Regards

Ramg.

[Former Member]

All Moni messages are stroing the ABAP Table -- SXMSPMAST2

For more info,

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

Regards

Ramg

[Former Member]

Hi,

you can automate the monitoring process to export the report in spread sheet by writing a batch job that would collect the required data those you need from the table(SXMSPMAST2) which SXMB_MONI (program:rsxmsadm) accesses at runtime.

Your batch job will fetch data from the table SXMSPMAST2 itself and export that in spread sheet and you can schedule it on daily basis.

cheers,

Abhishek.

[Former Member]

Thanks you so much your reply... sound like very easy basically is not

Very strange, when I go SXMB_MONI all messages are displayed, but when I check SE16 Table: SXMSPMAST2 none of message there... also I treid SE38 to run program... I got ABAP dump error...

I check in SQL to display that table still no entries...

(here is that info. I found out)

Table:XI_AF_MSG has more then 25 fields match with moni records

Table: SXMSPEMAS has more then 3 fields

Table: SXMSPMAST has more then 5 fields

I am not sure I am right track or not

any ohter idea

[Former Member]

Check this blog, hope you will get some ideas!!

http://wiki.sdn.sap.com/wiki/display/Snippets/IntegrationEngineTables+Analyser

Regards

Ramg

[Former Member]

There must be combination of few more tables to fecth the messages!!

Regards

Ramg

[Former Member]

Hi,

Could you please say me what can be the implication of sending the xml file to a excel sheet as the xml is not a table kind of thing at all.

you can always export the XML content of SXMB_MONI to your local system and save it as a .xml or a .txt file.

cheers,

Abhishek,