hi xi gurus

[Former Member]

i got one scenario like i have to transfer data from file to SAP-ISU using xi.

here i have to migrate data from external file to RFC USING XI.

after all the process is done how i can send the list of files that have been processed successfully to the sender using file adappter 2.

can anybody explain me clearly .

regards.

seeta ram.

[bhavesh_kantilal]

Hi,

Such feature is not available in standard.

One option is to read the filename in your mapping and then write this filename with the time stamp in a ZTABLE in XI using the LookupAPI.

A separate report can be used to read the data from this ZTABLE and send the list as needed.

Regards

Bhavesh

[Former Member]

Bhavesh,

I remember reading while using JDBC lookups, we are not permitted to write any values to db since this may lead to incosistency. Couldnt remember where I read this info.

If this is true, does it apply only for JDBC lookup and not for RFC lookups?

Regards,

Jai Shankar

[bhavesh_kantilal]

Jai,

You are correct. This holds true for both JDBC and RFC.

Reason it is not recommended to do this is that if you face an error in your mapping or at any other step of the message processing and you restart the message you might effectively write the same data twice to the database which in most cases is not wanted.

In this case, as the list of filenames is used as a indiviual referecen, the RFC code can also check for the Filename andthe timestamp and make sure that this is a unique value. XI allows you to pick up the timestamp and the filename from the soap header ( select these in the ASMA in the sender file adapter) and thereby ensure that every record is unique.

Regards

Bhavesh

[Former Member]

thanku bavesh.

but here in my scenario iam using one file sender adapter,one rfc reciever adapter,one file reciever adapter.

sender file adapter for sedninf the files from external party.

rfc reciever adapter for recieving file info and adding it to rfc.

file reciever adapter is on external party side to recieve all succesful file info.

here

iam sorry to say that my lead is saying that if we use fiel reciever adapter then we can send all sucesful file info to external perty using that file recievr adapter.

if you conform on any one i can justify and i can change my procedure.

waitng for your response.

regards.

seeta ram.

[Former Member]

hi bavesh thanks for your suggestion.

and one more thing is what do u mean by jdbc lookups.

can u please send me jdbc lookup code and what is the purpose of this.

waiting for u.

regards.

seeta ram

[Former Member]

Hi Bhavesh,

Many thanks for the info.

@Seeta Ram,

Same concept as RFC look up. Instead of having the table in R/3, you have it in a db like SQL server and you can get values from th table.

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Regards,

Jai Shankar

Message was edited by:

Jai Shankar

[Former Member]

thanks jai shankar.

but i dont know how to write code for my lookup.

can u just give me the sample code with necessary tegs,header files,classes.

so that i can understand.

remember just can u give me code which is closer to my scenario.

waiting for u.

regards.

seeta ram.

[prateek]

Hi,

U ll find the code that suits ur scenario here

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a03e7b02-eea4-2910-089f-8214c6d1...

Regards,

Prateek