How to track communication channel audit log status

[former_member204873]

Hi All,

We have a requirement to send status (Delivered or not delivered) of all messages passed through PI (ECC - XI - File) for a particular channel, so is there any table(ABAP or Java Stack) in PI, where details of communication channel audit logs are stored.

In case these details are stored on java stack, how can we read those tables/details from ABAP stack.

Thanks,

Mayank

[Former Member]

Mayank,

Check the tables and what info. it can get.

Transaction Codes - (SE11, SE 16)

SXMSPMAS XI Messages - Master

SXMSPHIST XI Messages - Master History table

SXMSPEMAS Integration Engine: Enhanced Message Queue (Master)

SXMSPVERS Integration Engine: Message Version

SXMSPERROR XML Message Broker: Message Queue (Incorrect Entries)

SMPPMAP3 Mapping Runtime: Mapping

SMPPREL3 Mapping Runtime: Mapping Relation

SMPPSPLIT XI Mapping: Merge and Split

SXMSPFRAWH Integration Engine - Header Table for Raw Data for Performance Evaluation

SXMSPFRAWD Integration Engine: Data Table for Raw Data for Performance

Adapter Engine Tables -

Schema Name - SAPSR3DB

XI_AF_MSG AF XI Message

XI_AF_MSG_AUDIT audit log entries

If runing on PI 7.1, table names are as follows -

BC_MSG AF PI 7.1 Message

BC_MSG_AUDIT PI 7.1 audit log entries (**)

also -

http://wiki.sdn.sap.com/wiki/display/XI/FastgrowingtablesinPI+7.0

[former_member204873]

Deleting repost

Edited by: Mayank Gupta on Nov 25, 2011 11:27 AM

[former_member204873]

Hi,

How can i check Adapter engine tables?

Adapter Engine Tables -

Schema Name - SAPSR3DB

XI_AF_MSG AF XI Message

XI_AF_MSG_AUDIT audit log entries

Also is there any way i can read records in these tables through an ABAP Report(or some other solution).

Thanks,

Mayank

[markangelo_dihiansan]

Hello,

How can i check Adapter engine tables?
Also is there any way i can read records in these tables through an ABAP Report(or some other solution).

You use an external DB tool to connect to it and read the contents.

Hope this helps,

Mark