RFC to file

[Former Member]

I have a scenario...where i am doing RFC to file.

I transfer some bank details from RFC to File.....My problme here is...the data which i sent should not stay in XI and should be deleted immediately...I know archiving and deleting concept can be used.....but i need only for this single interface.....how can this be done...

please some one guide me......

[agasthuri_doss · Accepted solution]

Hi,

>I transfer some bank details from RFC to File

You can Lock in Sxmb_moni & The Successful messages passing SAP XI / PI are stored in Table for some days ( As a default 30 days ) but we cannot read those messages in the Table because It is stored in Compressed mode / hash code / binary.

Cheers

Agasthuri Doss

[Former Member · Accepted solution]

how to lock in SXMB_MONI, and also let me know what is the table which stores this information....

[Former Member]

Hey

you can use the following

Thanx

Aamir

[Former Member]

Hi Harsha

I have performed this by creating a report which is nothing but a copy of RSXMB_SELECT_MESSAGES and with this i selected all messages where "Sender service = My Sender service" and deleted the records from the table. This report i executed along with receiver maintaining order at runtime

For me it was an encrypted message that need to be read from FTP location still we need to delete it -

I dont know this will help you or not

Thanks

Gaurav

Edited by: Gaurav Bhargava on Oct 15, 2008 4:50 AM

[Former Member]

Even i need the answer for this....

Doss,

Can you elaborate on the lock concept.I want to know this.

Gaurav,

When i execute the report,Its taking me to the SXMB_MONI..I didnt get how you deleted the table entries.Can you please elaborate it.

[Former Member]

HI

We created copy of RSXMB_SELECT_MESSAGES as this will check for authorizations, status etc.

Main requirement was to remove data after taking backup from SXMSPMAST. You can find the messages for a sender or receiver, message type (A or S), time range and QOS etc. My requirement was very specific and i had to delete report. and keep the delta.

As my ERP was using PowerConnect to a DW and i need to remove data from SXMB_MONI only and need to keep the backup(Delta).

We achieved in this manner..

I think this could help you understandl

Thanks

Gaurav

[Former Member]

Gaurav,

Can you please elabaorate the steps u did for deleting messages in sxmb_moni...

as for ur answer, I exceuted the program,which would take me to SXMB_MONI...after that what should i do...?

i still didnt get you....Can you please explain what needs to be done step by step....

i even checked the table SXMSPMAST but couldn't find any answer

Edited by: Harsha reddy on Oct 15, 2008 2:47 AM

[Former Member]

Hi Harsha

Cannot go to code level details

I would suggest go to SE11 and use SXMS* and look for XI and Integration engine tables.

You can use this to remove the content of messages from SXMB_MONI as well as RWB logs.

Steps can be

1. Look for the report this will allow you to get the authorization etc. I used it because some people were authorized to see the content and in that case i should not delete it.

2. Look for the tables that store various set of data and you can stop the display of content using conditions.

For me it was when i receive sensitive information after receiving successfully we need to remove the content. It should not be a failure case as the support person can look for SXMB_MONI to debug.

I know information is not complete but this can help.

Thanks

Gaurav

[Former Member]

any ideas please...