Table Names of Processed XML Messages

[Former Member]

Hi ALL,

We are facing space problem in PRD box with one of our client, due to increase in large number of Messages .

Our basis tryed to do archiving, but endup with no luck.

Could any one tell us in which tables processed idoc xml messages will get stored.

.Any help is highly appreciated.

Kind Regards,

Vijay

[Former Member]

Hi,

you should not delete XI Message directely from database table. Please schedule archive or delete jobs. If you never define which interface should be archived, it could NOT be done afterwards. This is also documented clearly on the help.sap.com. What you could do is delete the old messages to free table space. You could configure now interface which should be archived, in this case the message processed in XI in future could be archvied.

XI message is actually stored in different tables,

SXMSPMAST, SXMSPMAST2 XML Message master Table, contains runtime information on XML messages processed by XI; in this table you can find all the information that is visible in SXMB_MONI.

SXMSCLUP XI Message Payload Tabelle

SXMSCLUR XI Message Payload Tabelle

SMPPREL3 this table contains information about interfaces; here you can find information on sender (party, service, interface and namespace) and receiver (party, service, interface and namespace) as well as information on maps (their GUID and name as well as namespace).

SXMSPFRAWH Performance Head Data, Audit Log,

SXMSPFRAWD Performance Data, Audit Log

There are could be more tables used to store information about XI messages, as I mentioned don't modify database table by your own risk. You will not get support by SAP, it could cause fatal error.

regards,

Hai

[Former Member]

Hi,

Thanks Hai ..for the useful Information, We will work on this and will update our findings and results on this.

regards,

Vijay