look up table in PI

[Former Member]

Hi Guys,

we are using a Ztable developed in ECC as a LOOK table in PI for validating the different legacy reciever system,.

Guys can some one help me as to how do i use this Ztable in PI as a look up table?

My scenario is IDOC to JDBC.

please do reply

Sahil

[santhosh_kumarv · Accepted solution]

You need to use RFC lookup in the Mapping. To do this you need to created an RFC enabled function module in ECC to read the Ztable values for the given input and return it. Use ths RFC Function Module in PI.

[SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/8661] [original link is broken] [original link is broken] [original link is broken];

You can also try ung the standard RFC FM RFC_READ_TABLE.

~SaNv...

[Former Member · Accepted solution]

Hi Santosh,

Thanks for you reply.

We are using PI 7.0 version.

Do you have any documnets on Buildin RFC look up for Ztable and using it in PI.

please reply

Thanks

Sahil

[former_member187339]

Hi Sahil,

Use RFC lookup in message mapping. You can search SDN for more info on this. As a start check these blogs:

/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

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

Regards

Suraj