Skip to Content
May 18, 2010 at 03:04 PM

Value Mapping Replication Vs RFC Lookup API Usage Pros and Cons


Hi All,

We have scenario in which there is a need to lookup ECC tables to fetch values for few fields (around 5 to 8).

Number of records from source data: around 30,000 Line items per message

Number of records in ECC Lookup table: 1500 to 3000 max (with 5 to 8 fields in each record)

We are thinking about using either of the two methods:

1.Value mapping replication triggered by ECC table insert/change event as suggested in the blog:[Value Mapping Replication Scenario|] [original link is broken] [original link is broken] [original link is broken];

2.Writing custom RFC lookup UDF/Java code to fetch all the records once and save it in memory then do the mapping from memory for each line items.

We need advice on pros and cons of the above said techniques and also would like to know which techniques is best suited for this purpose. Please let us know your thoughts and experiences in this area.

NOTE: Graphical RFC lookup is ruled out because we do not want to call the RFC lookup for each line item.

Thanks and Regards,

Ananth Chinnaraj