Skip to Content
avatar image
Former Member

Location Of some of the DB tables

Hi Experts,

Can someone help me to locate the following tables:

SXMSPMAST

SXMSPEMAS

SXMSMSTATT

SXMSMSTAT

I need the URL where these tables are located.Are they in XI, BI or MDM?

plz help

Regards,

Sushama

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 11, 2008 at 11:37 AM

    Hi,

    please have a look here:

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/909760cb-0ec8-2a10-4a96-ee8417acfbc9

    Tables for XI messages

    Regards

    Patrick

    Edited by: Patrick Koehnen on Apr 11, 2008 1:39 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2008 at 11:36 AM

    Hi

    URL where these tables are located ??

    what do mean by this ??

    these tables are avail in XI..not sure abt BI & MDM

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2008 at 11:43 AM

    Hi ! Sushama

    The SAP XI stores the monitoring trace data in the multiple tables. Before I go further, I would like to give some overview on the tables which I have used to fetch the basic XI interface monitoring data.

    1.

    SXMSPMAST: (Integration Engine: Message Queue (Master)) The table is the master table for the monitoring information. You can get the timestamp, interface status, message id, and many more information.

    2.

    SXMSPEMAS: (Integration Engine: Enhanced Message Queue (Master)) The table provides the namespaces, the business systems and message interfaces involved in the interface.

    3.

    SXMSMSTATT: (Exchange Infrastructure: Message Status Description) This table provides a message status description.

    4.

    SXMSMSTAT: (Exchange Infrastructure: Message Status) This table is helpful if you want to show the process status icon for the corresponding message state.

    refer this pdf for more details

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/909760cb-0ec8-2a10-4a96-ee8417acfbc9

    Thanks & Regards

    Abhishek Agrahari

    Pls close thread if problem is solved by rewarding points .

    Add comment
    10|10000 characters needed characters exceeded