Few days’ back I saw post in forum for shortcut to find number of interfaces in XI (he is counting interface manually), answer was very simple; count entries in table SMPPREL3, in this table you can find interface list with other interesting information. In this blog I try to introduce some of interesting tables available in XI and how we can extract some useful information from these tables.
Scope of this blog is to introduce you to these tables, technical detail you can explore yourself :).
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).
SMPPMAP3: this tables contains information about maps and also used in SMPPREL3, in this table you can find detail information on maps including what type of map it is (XSLT, Java, ABAP, Message etc), this table contains references from SMPPREL3.
SXMSPMAST2 (SXMSPMAST): This 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.
SXMSPFADDRESS: this table is master table for addresses in XI i.e. Party, Service, Interface and namespace, key of this table is address id that is used at many places in XI runtime.
SXMSPFRAWH: this table contains runtime performance data for successful message and sender and receiver information is stored as address id that derive information from SXMSPFADDRESS, from this table you can find out volume and latency also.
SXMSPERRO2: this table contains entries of error messages (only exception is NO_RECEIVER_STOP which is also mentioned in this table.)
So what you can do using these tables:
– How many interfaces are in my XI system?
o Check number of entries in SMPPREL3 tables, actual count can vary by 1-2% because wild card is used in this table for some relationships.
– How many XSLT maps (or Java/ABAP) we are using?
o Goto SMPPMAP3 table and from selection screen use MAPTYPE = “XSLT” filter and see number of entries.
– How many messages processed today (or any particular day) successfully?
o Well you can give this answer from SXMB_MONI also, but did you observe how much time it will take to give you information, so instead of giving answer from SXMB_MONI goto SXMSPFRAWH selection screen and enter time in FIRSTTS field (start time). Note that you must enter range (i.e. 00:00:00 hrs to 23:59:59 hrs) and time in UTC format (YYYYMMDDHHMMSS)
– How much volume processed today (or any particular day) successfully?
o Well repeat above process and then select column MSGSIZE and press Shift+F8 and you can see summation at end of column.
– How many error messages are today (or any particular day)?
o Use table SXMSPERRO2 for error messages and fill field EXETIMEST with range in UTC format.
There are many such answers you can extract from tables which is directly not available to us.
I also created page in wiki (http://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/useful+abap+tables+in+sap+xi& ) so you can also update information on interesting ABAP tables in XI.
In next part I’ll try to cover some more interesting tables and how we can exploit them using custom ABAP code for quick information.
* For SAP beginner: Transaction SE16 to view table.