PI to RFC to file sync

[Former Member]

Hello Experts

i need create an scenario like these, i have send with PI three parametres to an RFC in

system R3 then the RFC's Responce have to send to table in Data base.

any suggestions or any scenario to example to give myself an idea

Thanks

[former_member206760]

you have to use a receiver jdbc adapter

in the mapping u have to use a RFC lookup that would llokup values from R3 and those values will then be mapped to trget JDBC structure..

/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

[Former Member]

Hope you are using PI7.1. Standard function RFCLookup will solve your purpose...

Have a look at these...

/people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

/people/shabarish.vijayakumar/blog/2010/01/28/graphical-rfc-lookup-and-how-you-can-design-lookups-for-multiple-values-to-be-retrieved-in-a-single-call

[Former Member]

Sorry i m using PI 7.0

thanks for your fast answer

the parametres are two dates dateStart and dateEnd and one flag (Y), i'm doing this

in de source message maping the dataStar with the function currentDate currdate and

same thing for dateEnd and the flag is maping with a Constant

Edited by: jaime eduardo alvarez reyes on Feb 26, 2010 9:08 AM

[Former Member]

Hi,

Yes u can do it.

1.Create a Function module, with 3 import parameters(2 dates and 1 string) and a 1 exportparameter(table).

2.Implement the code in function module. Note:The FM should be Remote Enabled.

3.First check the FM is wrkng fine or not.

4,If correctly working...

5.Import the FM into PI using credentials under Basis->RFC.

6.Use it in mapping.

Apart from this..... to design mapping and test it locally.... please see the above links given

If problem still persist.. pl do post

Babu

[Former Member]

No issues...All you need to do is write a UDF for RFC lookup...

http://wiki.sdn.sap.com/wiki/display/Snippets/User-defined%2bMapping%2bFunction%2bfor%2bRFC%2bLookup

P.S : I asked you about PI7.1 because hereon standard functions have been provided for RFC/JDBC lookups but before that we used to write a UDF in XI 3.0 for RFC Lookup.