cancel
Showing results for 
Search instead for 
Did you mean: 

XI Tables

Former Member
0 Kudos

Dear Experts

Exchange Infrastructure has been known for many of its dazzling features and one of them is the effective and efficient message tracing facility through the transaction - SXMB_MONI. The transaction provides a detailed tracing information for each and every XI interfaces.

But where does XI store this information?

What is the name an location of that database?

Edited by: Sourabh Nirmal on Apr 11, 2008 9:38 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Are you looking for this.

Location of XI objects.....

You can find the repository API’s in the SE24 class builder that can be used for accessing repository objects from the ABAP stack of SAP XI. Check CL_SRAPI* in the SE24 transactions for digging further.

location of interface objects

CL_SRAPI_DATA_TYPE---data type

CL_SRAPI_DATA_TYPE_ENH---data type enhancement

CL_SRAPI_FAULT_MESSAEG_TYPE--fault message type

CL_SRAPI_MESSAGE_TYPE--message type

CL_SRAPI_INTEGRATION_SCENARIO--integration scenario

Chek this blog for more info

/people/sravya.talanki2/blog/2007/01/11/ripping-off-sap-xi-stack-133sharing-the-goodies-of-abap-api146s

Regards,

Sarvesh

Former Member
0 Kudos

Thanks for the good response.

Can you please help me a little further by telling me how to access this database, I know it can be done using webservices but that wont solve my purpose.

How can I do that using JDBC or any other way?

Former Member
0 Kudos

hi sourabh

do reward points if solution found helpfull......

Former Member
0 Kudos

Hi,

What is ur exact requirement.

chirag

Former Member
0 Kudos

Hi Chirag

I need to access the XI tables to fetch data.

It is my clients requirement and dont know where the data is stored.

Although now I know about the tables but still need to know how to access them..

Former Member
0 Kudos

Hi,

What all data u wanted to fetch.

U can fetch the below details in mapping itself by writing UDF.

http://help.sap.com/saphelp_nw04/helpdata/en/78/b4ea10263c404599ec6edabf59aa6c/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/78/b4ea10263c404599ec6edabf59aa6c/frameset.htm

chirag

Edited by: Chirag Gohil on Apr 11, 2008 2:14 PM

Former Member
0 Kudos

Hi Chirag

I need to fetch data related to message errors from the tables.

Can you tell me the URL of the database..

Former Member
0 Kudos

Hi,

In my opinion, you can create an outbound proxy and then after fetching the data you can send it to XI and then to your target system.

But you can use Proxy only when all your tables are in R/3 only, not in XI. Then you can use pxoxy. I guess upto this moment you have find your table locations.

Let me know if this is what you want.

Regards,

Sarvesh

Edited by: Sarvesh Singh on Apr 11, 2008 3:14 PM

aashish_sinha
Active Contributor
0 Kudos

HI,

What information you want to fetch.

In my opinion go to SE16/SE11 and put alert you will get all tables related with alerts. so similarly you can get info for other components and then you can write your logic in ABAP to fetch info.

Regards

Aashish Sinha

PS : reward points if helpful

Former Member
0 Kudos

Hi Sarvesh

I still need to locate my tables, I have all the names but donot have the locations. Can you tell me where should be the following tables located..

1. SXMSPMAST: (Integration Engine: Message Queue (Master)

2. SXMSPEMAS: (Integration Engine: Enhanced Message Queue (Master)

3. SXMSMSTATT: (Exchange Infrastructure: Message Status Description)

4. SXMSMSTAT: (Exchange Infrastructure: Message Status)

5. SMPPMAP3: (Mapping Runtime: Mapping)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

check the below ones

BUSINESS SYSTEM TABLESSLDAGADM

SLDAGID

SXISLDAEC

ALSLDUPD

ALSLDCTRL

MAPPING TABLES

SMPPMAP3 and SMPPREL3 and SMPPSPLIT

Some of the important cache system tables used by SXI_CACHE:

1. TRD_RELATION- Meta Data for Receiver Determination

2. TRD_RULE- Meta Data for condition based routing

3. TRD_NAMESPACE-Meta Data for XPATH rules

4. TRD_EXTRACTOR- Meta Data for containers used in ccBPM

5. SMPPREL3-Meta Data for Mapping runtime

6. SMPPMAP3- Meta Data for Mapping runtime

7. SMPPSPLIT- Meta Data for Mapping runtime

8. SXI_SWCV_LAYER- Meta Data for SWCV

9. SSRVBINDING- Meta Data for Service Bindings

10. SSRVPARTY- Meta Data for Parties

11. SSRVSERVICE- Meta Data for Services, Party Identifiers for a Service

12. SSRVCHANNEL- Meta Data for Communication Channels

13. SWFXICACHE- Meta Data for ccBPM’s

14. SWFXICLOG- Meta Data for ccBPM message logs

15. SWFXIOBJS- Cache: Objects of a Process Definition (Proxy, CRL..)

note:reward points if solution found helpfull.....

regards

chandrakanth.k

Former Member
0 Kudos

Hi,

Function module SXMB_GET_MESSAGE_LIST through which you can get the messages in SXMB_MONI.

Refer teh below thread for the same information:

Interesting ABAP tables in XI – Part I

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

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/usefulABAPtablesinSAP+XI&

chirag

Edited by: Chirag Gohil on Apr 11, 2008 1:11 PM

Former Member
0 Kudos

Hi,

Check this

Regards

Seshagiri