Since your version is not 7.1, you cannot use Graphical RFC lookup. One solution is create UDF in the message mapping and do some RFC lookup. This is the possible solution.
Thanks for the prompt respose, Bhaskar.. but do I need to create RFC channel for XI and mention those details?? there's no other way to read data from table directly since it's in the same server?
in PI 7.0, another solution is to use two mappings in your Interface mapping:
- Soure_2_Intermediate: an abap mapping, to be configurated (see sap help and blog) in order to be able to select "abap mapping" in mapping type of Interface Mapping . Then in your abap mapping, you can easily do your SQL request to your Ztable stored in PI.
- Intermediate_2_Target: a Message Mapping, if the rest of your mapping is complex... (like an Idoc structure)
if your mapping is not so complex, maybe to acheive it completly within only one abap mapping,
Anyway, try the solution providen by Baskar, before to do that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.