Skip to Content
author's profile photo Former Member
Former Member

XI Tables

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 07:44 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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)

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 07:39 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 07:41 AM

    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:

    Where does SAP store Interface Objects, Mappings, and Imported object info?

    SXMB_MONI transaction table

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 07:42 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.