Save FTP log and data in FTP communication channel

[Former Member]

Hi experts,

in my scenario I have a receiver communication channel that put files in an external FTP server.

I've been asked to save the log (and eventually also the data of the message) of FTP in a table.

Is it possible to do that? maybe with a function module?

Thanks

Fabio Boni

[Former Member · Accepted solution]

which log r u referring to - log of communication channel - and which system table u wanted to put the data.

chirag

[Former Member · Accepted solution]

Hi Chirag,

hope you're fine!

I refer to the audit log of the message display tool of message monitoring of adapter engine.

We need to put data in a table, custom table or system table, we have no preference, the need is that the table is queryable.

Thanks

Fabio

[Former Member · Accepted solution]

Hi,

Here are the tables where the messages will saved in a Table in Adapter/integration engine.

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

Thanks,

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 (**)

[Former Member · Accepted solution]

check this

http://wiki.sdn.sap.com/wiki/display/XI/XI+Tables

chirag

[Former Member]

You can do this by using an UDF in message mapping, that call an RFC lookup (that save/insert in a abap side table the message, and the file transfer... i think is better use a BPM to call this RFC lookup.

Ciao!

[Former Member]

Hi Fabio,

You can write a script on the FTP server to create the log for the messages.

Thanks,

[Former Member]

Hi,

we cannot create a script on the FTP server of the receiver firm, we don't have the permission to do that.

Thanks!