on 08-11-2016 6:50 AM
Hello experts,
I am new to this mapping lookup concept in SAP PI. Can anybody explain me the basic idea and the scenario in which this mapping lookup can be used?
I referred this below link but not able to understand exact meaning and purpose of mapping lookup in SAP PI. Also would be helpful if any scenario is used an example for the explanation
Thank you!
BR,
Omkar Desai
Hi Omkar,
Lookups used to access values in a back-end system when the mapping program is executed (runtime). By using a mapping lookup, a mapping program can call functions from other application systems while a mapping program is being executed.
please, have a look of RFC lookup step by step process. you will get clear idea about this.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Omkar,
Mapping lookups are used to fetch or enhance business data that is not present in the original message.
In its strictest sense (as intended by SAP), it should only be used in retrieving data.
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Omkar,
The lookup concept is when you need a value or a set of them at mapping level. For example you have a file and you want to send their values to an ECC but you have in an external DB or a third system a set of values to complete the information originally in that file, then at mapping level you can access to the with the lookup. For example you have a second codification for materials in a third system and you want to have in in the ECC endpoint these values and in the file you have one codification, in that third system you can have the union between the source and the ECC system codification.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Omkar,
Lookup is used to fetch values from external system in to the mapping.
There are possibilities.
1.RFC
2.JDBC
3.SOAP
Even file lookup is possible I guess.
For example you have customer number you wish to pick customer name, you can make a RFC lookup from mapping and fetch the values and send it to target.
Check the below link
SAPTechnical.COM - Usage of SOAP Lookup and RFC Lookup in a single Mapping Program
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raghuraman,
Thank you for your brief explanation about the mapping lookup concept in SAP PI.
Referring to your scenario about the explanation, Do you mean that if we have customer number in the XML message and we wish to pick customer name based on it from the Ztable in SAP ECC, we can make RFC lookup for it and send the value to the target?
Please clarify my doubt.
Thanks
Omkar
Hi Omkar,
Do you mean that if we have customer number in the XML message and we wish to pick customer name based on it from the Ztable in SAP ECC, we can make RFC lookup for it and send the value to the target?
Yes this is the idea. But you should think that in PI you can have alternatives like:
1, To use a bridge instead of a lookup. For example if you scenario is FILE(async)-RFC(sync)-PROXY(async), you can do the lookup with module beans instead of to do a java lookup, concept similar but optimized.
2. If the ztable is in the endpoint and your scenario ends up in the same place where is the ztable, it could be better to do the access in the final code.
You should think that the RFC o JDBC lookup can affect to the performance.
Regards.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
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.