Tables/arrays as input and output for RFC Look up

[Former Member]

Hi,

My Requirement: I have a message that throws thousands of lines to PI, and I need to make a look up in SAP, making it line per line RFK look up will make the system suffer, how to handle this? I thought of passing everything into a single table and make one RFC call.

Can someone tell me how to make an RFC Look up that accepts a table and outputs a table.

How do I define the parameters in the RFC?

Thanks a lot for the help.

[MichalKrawczyk · Accepted solution]

Hi,

have you seen Shabz's blog?

/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

it shows direcly how to achive that

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Thanks Michal, I've been looking for this for quite a while now. (Also got the chance to look at your blogs )

I'll try this and hopefully things would be ok.

[MichalKrawczyk · Accepted solution]

Hi,

I'm sure it will work if you do exactly as in this blog:)

good luck,

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Hi Michal,

I tried exactly the same one from the blog. It did not work for me.

I have to pass multiple values to the RFC 92 input values) and get one single output. I have declared my input as a table and exporting parameter as a table type. RFC alone works fine but the look up in PI failed. It gives me null value.