on 07-04-2017 6:39 AM
Hi All,
I have a requirement in file to Idoc scenario there are 10 fields having 10 RFC lookup's from 10 tables of ECC. will it cause any performance issue?
In this case which one is better approach can you please suggest me
and please share any blog which is appropriate to this RFC lookup scenario.
Thanks in Advance
Regards,
Venkatram
Hi Venkatram,
First of all you should do one module function and to set it like RFC to wrap the ten selects and you will need only one RFC lookup.
Also depending, your scenario you can do a bridge, for example if you have a file to file with the RFC lookup, you could do an async/sync bridge without lookup but you should tell us your entire scenario.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For data that is extracted in the target system you may also have the option of user-exits to enhance it based on the IDoc context without the performance overhead. We have such instances in our system and favor that approach over even a single RFC lookup.
Regards,
Ryan Crosby
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
I'd prefer to create provider proxy on ECC side with the method performing extraction of all needed data with single request, as Inaki has already suggested, expose it with SOAMANAGER and use SOAP lookup to fetch the data.
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
See the below link and select the best option as per the requirement.
https://blogs.sap.com/2013/08/13/value-mapping-which-is-the-best-option/
For RFC its better to make a single call instead of 10 calls.You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In general I would recommend to avoid RFC lookups in mappings that you are likely to drive a lot of traffic through as they can indeed become a performance issue. If you have to do an RFC lookup, ensure that you are minimizing the number of calls and be extra cautious about the performance of the function your are calling.
Depending on the nature of the data you are looking up you could also consider setting up a value mapping replication scenario that writes the needed lookup data to the PI value mapping cache periodically. If the data is very static you could even consider maintaining it in an ID value map but your support process needs to be set up to handle changes if they occur. That way you could avoid the RFC lookup but obviously these won't be viable options for data that is changing frequently.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In general you want to avoid remote lookups from the mapping if you can. In some situations that will be unavoidable. RFC lookups can be a viable option then. Maybe somebody can pitch in on the performance of RFC lookups vs JDBC and SOAP lookups as I have no practical experience with the latter in a production environment.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.