RFC mapping Lookup

[Former Member]

Hi,

Is there any Other RFC Lookup program other than the following way.

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

i want to do the validation on two incomming fields and get the corresponding value from mapping table.

Regards

Bopanna

[Former Member]

Solved the problem by self.by providing the space like " AND " in the following line of code. here it is a space problem

String WHERE_CLAUSE = sourcefld[0]" = ""'"fldvalue[0]"'" + " AND " + sourcefld2[0]" = ""'"fldvalue2[0]"'";

[Former Member]

May be these one can help you.

RFC Lookup.

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

SAP XI Lookup API: the Killer - /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

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

SOAP Lookup - /people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

Check this weblogs with some screenshots on how to achieve this:

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

/people/sravya.talanki2/blog

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Lookups with XSLT - https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8e7daa90-0201-0010-9499-cd347ffb...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/05a3d62e-0a01-0010-14bc-adc8efd4...

[henrique_pinto]

This method is deprecated (directly using JCo).

Check the code samples in these javadocs:

https://help.sap.com/javadocs/pi/SP3/xpi/com/sap/aii/mapping/lookup/LookupService.html

https://help.sap.com/javadocs/pi/SP3/xpi/com/sap/aii/mapping/lookup/RfcAccessor.html

Regards,

Henrique.