PI Tables

[Former Member]

Dear Experts

I was going around a few tables in XI mentioned in the blog /people/gourav.khare2/blog/2007/12/12/interesting-abap-tables-in-xi-150-part-i

When I compared the two tables

SXMSPMAST: This table contains runtime information on XML messages processed by XI; and

SXMSPFADDRESS: this table is master table for addresses in XI i.e. Party, Service, Interface and namespace, key of this table is address id that is used at many places in XI runtime.

The entries in the two tables are not same. Is there a table or a group of tables which can give us all the information that is visible in SXMB_MONI including the Service Interface, Message id, status etc.

Reggards:

Sourabh

[former_member463616]

Hi,

Please see the below links, it will contain lot of tables which will might be useful to you.

http://wiki.sdn.sap.com/wiki/display/XI/XI+Tables

http://wiki.sdn.sap.com/wiki/display/XI/UsefulABAPtablesinSAP+XI

http://education.feedfury.com/content/34604749-list-of-sap-xi-tables.html

Regards,

Rajesh

[Former Member]

Dear All

Thank you for the replies, I am still struggling to find the group of tables from where the data in the SXMB_MONI is collected and displayed.

Can anyone help?

Regards

Sourabh

[Former Member]

hi,

check this blog: /people/dhanabal.thangavel2/blog/2009/12/16/getting-daily-failed-message-list-in-xi-and-sending-an-alert-mail-with-attachementcsv-file-of-that-list

it should give you the code on how to select messages (in this case failed). I've seen better ones but I can't find them right now

[Former Member]

Hi Sourab,

Check the tables and what info. it can get.

Transaction Codes - (SE11, SE 16)

SXMSPMAS XI Messages - Master

SXMSPHIST XI Messages - Master History table

SXMSPEMAS Integration Engine: Enhanced Message Queue (Master)

SXMSPVERS Integration Engine: Message Version

SXMSPERROR XML Message Broker: Message Queue (Incorrect Entries)

SMPPMAP3 Mapping Runtime: Mapping

SMPPREL3 Mapping Runtime: Mapping Relation

SMPPSPLIT XI Mapping: Merge and Split

SXMSPFRAWH Integration Engine - Header Table for Raw Data for Performance Evaluation

SXMSPFRAWD Integration Engine: Data Table for Raw Data for Performance

Adapter Engine Tables -

Schema Name - SAPSR3DB

XI_AF_MSG AF XI Message

XI_AF_MSG_AUDIT audit log entries

If runing on PI 7.1, table names are as follows -

BC_MSG AF PI 7.1 Message

BC_MSG_AUDIT PI 7.1 audit log entries (**)

Thanks,

[Former Member]

Hi,

Try this table

SXMSPEMAS

Regards