lookup performance

[Former Member]

any idea on the performance of the mappings in lookup

[Former Member]

Hello,

<b> The inclusion of the Lookup in MAppping is not suggestable...unless the scenrio demands for it .Becaouse Lookup consumes more resources as it is nothing but logical jump of the Control flow from IR to R/3 or External data base and retrieving the info and getting back...

</b>

Lookup in mapping is the feature provided by SAP to lookup the data in the target R/3 or DB systems with the API provided.

You need to write UDF in order to implement the API's provided by SAP.Consider the below example

VendorNumber-UDF--CURR

The scenario is legacy to SAP. The legacy system doesn't provide the currency details. But the target field need's to be populated with currency value.

"The business rules says there are values maintained in SAP Table where if you pass VendorNumber it will return thr currency to you"

So what you can do? You can write UDF implementing SAP Provided API's and do a lookup in the SAP System and get back the currency value and populate them in CURR field.

I hope it clears a bit.

Please find the below blogs

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

Edited by: BVS on Jun 27, 2008 1:08 PM

[former_member240483]

Lookups performance always a problem.

its always depends on the source system perofrmance..

[Former Member]

Hi,

if u r doing lookup in SAP R3 system through mapping using jco ro RFc lookup then there is a performance issue.

because u r switching from java stack to abap stack. from mapping u r calling R3 system and then getting response back which slow down the performance.

thnx

chirag

[Former Member]

The common approach to do cross-reference is using a data-source (a JDBC connector service, defined on J2EE Server). A generic java class is defined where methods for making connection and performing lookup would be handle. The Graphical mapping program or Java mapping could use this generic code for doing lookup.

Coding effort and Maintenance of Graphical mapping is easier compared to Java mapping at a comparable performance provided by both type of mapping.

Recommendations for order of preference of mapping program:-

1. Graphical Mapping

2. Java Mapping

3. ABAP Mapping

4. XSLT