cancel
Showing results for 
Search instead for 
Did you mean: 

Using a transparent table in XI3.0 mapping - How?

Former Member
0 Kudos

Hi All,

I am currently working through an issue were I have to map two very different data types that have a 1:1 relationship.

The solution, I thought, would be to create a simple transparent table and have the relationship between the two data types held there. There are only 40 entries at present and this will not rise significantly in the future.

The issue comes when mapping, I am trying to find a way of using the table within an existing mapping interface so the information in the "How To... Use ABAP-Mapping in XI 3.0" is not applicable.

I have searched through the forums and looked at the documentation I can find and still with no success, so if anyone can help with either advice or documentation I missed then I will be very grateful.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Right it would appear using <b>Value Mapping Replication</b> is the way forward.

For anyone interested I found this help topic, which does actually explain things quite easily: http://help.sap.com/saphelp_nw04/helpdata/en/2a/9d2891cc976549a9ad9f81e9b8db25/content.htm

Former Member
0 Kudos

Hi Colin,

If you are referring to the "How to..." guides that are produced by SAP then I have the ABAP mapping one and mentioned in my initial post that it did not help as the search of a table needs to be part of an existing map.

I was able to get the guides from the Marketplace, following the quicklink /xi and then looked for the link "How to".

The reason for this level of complication and not just doing the normal value mapping, which we have looked at, is the elements involved in the 1:1 mapping change.

Now instead of making a maintenance and testing overhead each time a new element is added it was realised that using a table would be easier and more flexible moving forwards.

Message was edited by: Mark Hutton

Former Member
0 Kudos

I wondered the same as well - use value mapping or fixvalues. We have used fixvalues for one-time needs in specific mappings to avoid mult "if" statements.

However - the value mapping has eluded us - we aren't sure how to use it. I'd appreciate the guide you guys created. Can you email to derringer_amanda_l@cat.com

thanks!

amy

Former Member
0 Kudos

Hi Amanda,

I will mail these to you tomorrow when I am back in the office.

The guides are SAP training guides so if you have been on the XI TBIT40 course you should get them automatically from the associated e-learning courses.

Cheers

Colin.

Former Member
0 Kudos

Sorry, I should have been clearer:

There is an internal table on the XI system that is holding the two values.

It is a simple client-dependent table with two fields, both of which are key fields.

We need the mapping to use ABAP code to do a select on the table and get the related number to be passed onto the other system.

The code was been written and tested the table is populated, I just can't see how to get the mapping to call ABAP code.

The reason for using the internal table is to avoid changes to the XI map in the future is additional numbers are added in the future.

cdumont69
Contributor
0 Kudos

Hello,

Perhaps you can create and use an RFC in XI !?

But in this case you must use synchronized RFC.

Regards,

Chris

Former Member
0 Kudos

Hi Mark,

I guess by you description you have one input value and one output value as you previously mentioned the values have a 1:1 relationship - is this correct ?

If this is the case then why are you going down the ABAP mapping route ? Do things have to be this complicated ?

Why do you need a select if it is a 1:1 relationship ?

Far easier it to use Value Mapping within XI 3.0. Is there a valid reason you are not using this ? Does it not give you the functionality you need ?

In any case, I have a guide to set up ABAP mapping to work and also a guide for Value Mapping.

Also, there are a couple of example ABAP mapping classes in the Integration Server you can look at but you need to make sure ABAP mapping is activated in the Exchange Profile. This is explained in the guide.

Let me know you e-mail address and I will forward both guides.

Cheers

Colin.

Former Member
0 Kudos

are you trying to map structures or values? ie convert an employee number to an employee name, or actually convert one matrix of values to another matrix of values of a different shape & size?

Former Member
0 Kudos

Amanda,

We are mapping values of different size and content, for example:

1234567890 -> abcd1-ef2gh-i3jkl-mn4op-qyrst-uvwxz

2345678901 -> 12ewq-322de-kfkw2-fjsjs-jjewb-xjsjq

The were going to be forty of these such maps, we have found out now that there are a few more. In fact a few more is defined as 120, so that means 160 in total.

The number set to rise again soon as well when some things are settled within the business.

Hopefully know you can see why we would rather no have fixed value mappings within the XI system and have a user maintained table in the ABAP stack with XI referring to it.

Message was edited by: Mark Hutton

Former Member
0 Kudos

Hi Mark -

Agreed you definitely want to use a table. The only way the value mapping is ok is if it's fairly static, and only that map ever needs to reference the data. Let me know how well the RFC in the middle of your interface path goes... We are also working on something similar, but have concerns over performance hits (we're doing more than a million messages a day once we get ramped up). So potentially, hundreds of interfaces whacking away at the same table, lots & lots of times... Since this isn't something standard with XI, we are worried that if it doesn't perform as well as we need it to, we aren't going to get a lot of technical help from SAP.

Good luck!