Import conversion data table from SAP R/3 into value mapping table in XI

[Former Member]

Hi:

Somebody knows how to import a table with conversion data that are in SAP R/3 and to take it to a value mapping table in XI?

The purpose is to use a mapping table that can change in the future. Must I use a ABAP programming that retrieve data and build the value mapping table?

If so, how I specify in the ABAP programming the group id, the scheme, the agency and the corresponding value?

Please, help me.

Regards!!!

[Former Member]

Hi,

watever you have said is correct. check this weblog,

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1301. [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

now the only problem is to generate the input XML. This can be done in any way as you wish.

1. You can write a RFC and use RFC sender adapter to get data from tables.

map it to the required format in the mapping and give it to the receiver as said in the weblog.

2. You can write ABAP client proxy.

>>how I specify in the ABAP programming the group id, the scheme, the agency and the corresponding value

all these things can be hardccoded in the RFC, or the ABAP proxy.

Group ID should be 32 Digit hex number. TO get the mapping properly, you need to take care of group IDs properly.

hope this helps.

regards,

P.Venkat

[Former Member]

Hi Jin:

Thanks for your help, but that way you say serves to me to handle a great amount of data to transform without hitting the response times?

I've look the value mapping groups examples in Directory and I have realized that I must have a group for each registry of a data to transform. Exists an optimal method for mapping that does not use the creation of these value mapping groups?

Regards!!!!

[Former Member]

Hi David -

You raise a good point. If you have a large mapping/message and you end up needing to execute a lookup very frequently, there could be some network overhead to consider. This varies by mapping/lookup requirement. Sometimes, depending on the mapping requirement, you can perform a lookup and store it in a container and reuse it as necessary.

If you need to do conversions in your mapping, value mapping or mapping lookups are your main two options.

Regards,

Jin

[Former Member]

Hi,

with SP13 or so, the feature of Java initialization blocks was introduced. If you know, that you'll need a certain lookup within a mapping, you can look it up once for all values and store it in an internal variable. So you would cache all applicable values during the mapping execution and just access your internal variable. I think, with such a lookup you'ld be more flexible than with the value mapping within xi, which only supports 1:1 mappings.

Regards

Christine

[Former Member]

Hi David -

This isn't directly relevant to your question, but another consideraton for you may be to maintain the data in R/3 and use the Mapping Lookup API to perform lookups against the R/3 table. You can find more information at the following link:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

Best regards,

Jin

[Former Member]

Hi David,

please refer to this section in the help: http://help.sap.com/saphelp_nw04/helpdata/en/2a/9d2891cc976549a9ad9f81e9b8db25/content.htm

There is an interface for mass replication of mapping data. The steps you need to carry out to use this are:

+Activities

To implement a value-mapping replication scenario, proceed as follows:

...

1. Register the Java (inbound) proxies.

To do so, call the following URLs in the following order in your Internet browser:

¡ http://

:

/ProxyServer/register?ns=http://sap.com/xi/XI/System&interface=ValueMappingReplication&bean=localejbs/sap.com/com.sap.xi.services/ValueMappingApplication&method=valueMappingReplication (for the asynchronous replication scenario)

¡ http://

:

/ProxyServer/register?ns=http://sap.com/xi/XI/System&interface=ValueMappingReplicationSynchronous&bean=localejbs/sap.com/com.sap.xi.services/ValueMappingApplicationSynchronous&method=valueMappingReplicationSynchronous (for the synchronous replication scenario)

You only need to perform this step once (for each installation).

2. Application programming

The ABAP program must perform the following tasks:

¡ Read the value mapping data from the external table

¡ Call the outbound proxy used to transfer the data to a message, which is then sent to the Integration Server

3. Configuration of the replication scenario in the Integration Directory

This involves creating all the configuration objects you need to execute the scenario successfully. One special aspect of the value-mapping replication scenario is that the receiver is predefined (it must be on the Integration Server). The sender, however, is not predefined in the replication scenario and can be defined to meet your individual requirements.

For example, you can use the shipped ABAP proxies.

In the case of the receiver communication channel, choose the adapter type XI. Ensure that you configure a channel for the Java proxy receiver in this case.

Enter the path prefix /MessagingSystem/receive/JPR/XI for this purpose.

+

Regards

Christine