Skip to Content
avatar image
Former Member

Picking values from table while mapping

Dear All,

I am working on Idoc-XI-IDoc scenario.

I am having one z-table maintained in XI which contains some values in it. Now I want to fill in the target Idoc fields from the values in the z-table based on the values maintained in the source Idoc.

It will be like if field A from source Idoc has value 123 then it will check that same value in Z-table and will bring in all corresponding values from the table and will fill the target idoc corresponding fields.

Please suggest how the mapping is to be done in this case.

Reards,

NJ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Mar 06, 2009 at 06:34 AM

    Hi,

    You have to use table look up for this.

    /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

    /people/william.li/blog/2007/03/30/using-jdbc-connection-pool-in-xi-message-mapping

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2009 at 06:39 AM

    Dear Nishu...

    RFC lookups are used precisely for this kind of scenarios...

    you can have a RFC which is calling that table and performing the logic that you need..

    You can then use that RFC in RFC look up....

    you can search with RFC lookup on forum and you will get many messgaes

    hope it helps

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2009 at 10:36 PM

    Hi

    check my last post in this thread, where similar issue/solution is discussed.

    XI map Message ID from Proxy

    Regards

    Vishnu

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2009 at 06:35 AM

    Hi,

    You can do it by two ways

    1. In Graphical Mapping you can do an RFC look up to the ztable.

    2. In ABAP mapping you can access this ztable from your ABAP mapping code.

    Thanks,

    SaNv...

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2009 at 06:36 AM

    If the total count of value is small then you can go for value mapping and maintain the entries in value mapping table and use conversion function in XI.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2009 at 10:17 AM

    Hi Nishu,

    as other said, if values are fixed and volume is less, u can go for for Fix Value mapping,

    But if volume is more , then you can for RFC look up,

    But the best option i can see is the Value Mapping Replication , where your values will be stored in runtime cache.

    Regards

    biplab

    Add comment
    10|10000 characters needed characters exceeded