Communication Channel information in abap tables

[Former Member]

Hi ,

Could you let me know any abap table which contains information about communication channels in PI 7.0.

I have checked the following link

But the table SMPREL3 is not active in our data dictionary. is there any other table which stores this information.

-

---

My requirement is to get the list of all channels which have quality of service as EOIO in the processing tab of the comm channel.

Let me know if there are any other ways of checking this.

[former_member235681]

Here Is complete solution:

select * from XI_DIRKEYCHANNEL; --- Channel Name and Channel ID

select * from XI_DIRSYNCADMIN; --- Channel ID and Channel Date

select * from XI_DIRDATACHANNEL; -- Channel ID and Channel whole XML as field ATTRBTS

To decipher LOB data type ATTRBTS field of above table to get channel data.

use below string:

select cast(BINTOSTR(cast(ATTRBTS as binary)) as varchar) from XI_DIRDATACHANNEL;

Navdeep Swami

PI Expert

[Former Member]

Hi,

Some tables in following blog:

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417800)ID0366444450DB00849302769976173098End...

Regards,

Giuseppe

[Former Member]

Hi Varun,

Check "SSRVCHANNEL" table in the PI server.

This table contains the communication channels information.

Regards

Ramesh

[Former Member]

Hi,

Try this as well...

SSRVBINDING

Regards,

Giuseppe