Read data from Table at XI during Mapping

[Former Member]

Hi experts

How we can pick data from one database table during Mapping, the table is at XI system.

when we are picking data from table at R/3, we are using RFC Function Module/ BPM, can we pick data from XI database table during mapping ?

what will be the steps to pick it ?

Please Help.

Regards,

Study SAP

[Former Member · Accepted solution]

hi Study Sap

You may use RFC lookup

kindly follow these links for RFC lookup

/people/francesco.bersani/blog/2007/03/05/data-lookup-optimized

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

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

/people/bhavesh.kantilal/blog/2006/07/25/triggering-xi-alerts-from-a-user-defined-function

Use this crazy piece for any RFC Mapping Lookups!

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

SAP XI Lookup API

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

Lookup’s in XI made simpler

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

regards

Sandeep Sharma

PS if helpful kindly reward points

[Former Member · Accepted solution]

Hi Chirag,

The table is on XI system,

In this case, We will use RFC Function Module ?

OR

You have idea to resolve this ?

Regards,

Study SAP

[Former Member · Accepted solution]

Hi,

U create FM in XI and make it as remote enabled and now call that RFC FM from ur UDF.

chirag

[Former Member · Accepted solution]

Hi,

We can use the DB lookup option to refer the data from XI database tables.

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

Thanks

Swarup

Edited by: Swarup Sawant on Apr 10, 2008 8:00 AM

[Former Member · Accepted solution]

Hi Chirag,

Its fine I can create my Function Module here in XI,

but for UDF code, I do not have idea for that code, like Import Parameters, export parameters in UDF and code in this UDF.

IF you have any code and structure for the same, please help,

Regards,

Study SAP

[Former Member · Accepted solution]

Hi,

U need to create the function module first, give import parameter and export parameter, make the function module remote enabled.

now in UDF u need to

Call that function module which inteurn return the values.

Links are already provided by me just refer that.

chirag

[Former Member]

Hi,

Use the RFC lookup rather than passing value to R3 FM use the XI FM.

Lookup method from GUI mapping can be called using any of the following ways.

• RFC lookup using JCO (without communication channel)

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

• RFC lookup with communication channel.

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

The steps are as follows:

• Develop and test ABAP function module.

• Develop and test Java method within Integration Repository/message mapping tool.

Notes:

• Ensure that the function module is RFC-enabled.

• Ensure that the parameters are passed by value and not by reference (mandatory for RFC-enabled function modules).

chirag