cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping lookup concept in SAP PI

0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

GauravKant
Contributor
0 Kudos

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.


http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40b64ca6-b1e3-2b10-4c9b-c48234cce...



Regards,

Gaurav

markangelo_dihiansan
Active Contributor
0 Kudos

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

iaki_vila
Active Contributor
0 Kudos

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.

former_member186851
Active Contributor
0 Kudos

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

0 Kudos

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

iaki_vila
Active Contributor
0 Kudos

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.

former_member186851
Active Contributor
0 Kudos

Hello Omkar,

We can fetch a data using RFC .

To be more specific consider flight availablity BAPI.

You can import it in ESR and make a call to it and get the flight details.

Refer the links for more understanding.