Local lookup in message mapping

[Former Member]

Hi all,

I've a table on the SAP PI system filled with data. From my message mapping, I want to do a lookup.

What's the best way to perform this lookup.

Again, this is a local table. So not a table residing on the SAP ECC system.

Thanks a lot.

Dimitri

[MichalKrawczyk · Accepted solution]

Hi,

>>>I've a table on the SAP PI system filled with data. From my message mapping, I want to do a lookup.

What's the best way to perform this lookup.

the best/easiest way would be to use ABAP mapping (right after your message mapping - as in interface

determination you can have many mappings)

just to do the lookup in XI table (in abap mapping you juse use a select to get this data)

so map the data in message mapping

then do the lookup in abap mapping just for this one field

Regards,

Michal Krawczyk

[prateek]

As said, best approach would be to go for ABAP mapping. However, if in case you cannot use ABAP mapping, then you need to create a wrapper RFC on PI to fetch data from local table and use RFC lookup in message mapping.

Regards,

Prateek