lookup for values from XI to R3

[Former Member]

Hi Experts,

i need to get values from r/3 table whenever i pass two values from XI.

Can I write a function module(RFC), which imports these values from XI and exports the values needed by XI from R/3 custom table.(infarct I'm going to of RFC lookup)

Is there any other way to get values from R/3 custom table.

let me know your thoughts.

[Former Member · Accepted solution]

Hey

As you said,you can do a RFC lookup to get the values from R/3.

Thanx

Aamir

[Former Member]

look up issues

[Former Member]

>

> Hi Experts, 
> 
> i need to get values from r/3 table whenever i pass two values from XI. 
> 
> 
> Can I write a function module(RFC), which imports these values from XI and exports the values needed by XI from R/3 custom table.(infarct I'm going to of RFC lookup) 
> 
> Is there any other way to get values from R/3 custom table. 
> 
> let me know your thoughts.

You write a Function Module in R/3 with the import parameter being the 2 values from XI. The export parameter will be the looked up value.

You can call this Function Module using an RFC lookup.

Other way of doing the same is using a JCO call like in this blog,

BR

[Former Member]

thanks for your responses.

which is a better approach RFC lookup or JCo call

(considering the load, I will get 10000 records, for each record, i need to pass values from XI to R/3 to do lookup and return back to XI)

[Former Member]

Hi,

RFC lookup will be better approach.

Thanks

Amit

[former_member181962]

In view of the Native Support that XI offers to the Backend R/3 system it is better to go for RFC based look ups.

Regards,

Ravi Kanth talagana

[Former Member]

can I pass all 10000 records values at once to RFC to get the corrersponding vlaues from R/3 table.

I cannot call RFC for each record, it would be overhead.

how to pass all 10000 record values to RFC and get corresponding values at one shot.

[Former Member]

Hi,

For performance wise JCO call is better than RFC Lookup.

[former_member181962]

Yes, it is the right way to go about it.

Check these weblogs on the same: