cancel
Showing results for 
Search instead for 
Did you mean: 

Location Of some of the DB tables

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

please have a look here:

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

Regards

Patrick

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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-ee8417ac...

Thanks & Regards

Abhishek Agrahari

Pls close thread if problem is solved by rewarding points .

Former Member
0 Kudos

Hi

URL where these tables are located ??

what do mean by this ??

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

Arun