code for R/3 look up table

[Former Member]

Hi,

1. Kindly explain how we can read values from a table in R/3, into the mapping in XI.

Please provide me the code and guidelines.

2. Also I want to know whether the follwing requirement is possible or not. if so, how?

Scenario: Is it possible to provide the path into the receiver file communication channel via the mapping program or any other means?

In short, we want the path in the channel to be dynamic.

Is it possible?, if so, how?

Thanks,

John

[udo_martens · Accepted solution]

Hi John,

1. best is [Value Mapping Replication Scenario|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/13812] [original link is broken] [original link is broken] [original link is broken];

2. Yes, use Variable Substitution at [Configuring the Receiver File/FTP Adapter|http://help.sap.com/saphelp_nw2004s/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/content.htm]

Regards,

Udo

[Marçal_Oliveras]

1. If you have PI 7.1 you can use RFC lookup function in message mapping easy without coding. Just insert the RFC lookup (from conversion functions) and enter the parameters that you need.

In other PI/XI versions the concept it's the same but I think it's more complicated and I don't know how to do it, sorry.

2. Yes, it's possible. The path must be into the target payload and then you can use "Variable substitution" in your communication channel definition, to extract the path and use it into path name.

You must enable variable substitution and do something like this to extract your path:

var1 = payload:MT_XXXX,1,path_field_name,1

path = %var1%

PD: If you use "/" for subdirectories into your path you must disable security checks

[Satyagadadas]

Hi,

This may help you.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a03e7b02-eea4-2910-089f-8214c6d1...