Skip to Content
author's profile photo
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • author's profile photo
    Former Member
    Posted on Feb 15, 2005 at 07:55 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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!

  • author's profile photo
    Former Member
    Posted on Feb 16, 2005 at 04:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • author's profile photo
    Former Member
    Posted on Feb 16, 2005 at 08:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • author's profile photo
    Former Member
    Posted on Feb 17, 2005 at 01:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 23, 2005 at 09:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded