Skip to Content
author's profile photo Former Member
Former Member

Runtime value mapping

hey ,

The requirement is like a record is being accessed from the database through a JDBC adapter into XI.In the record there are different fields concatenated as a string and these fields are to be mapped to the target side i.e Idoc which can be done by extracting the fields according to the length using substring function.Now, some src fields say "code" "sign" "cause "

are having some combination of values and these combinations are deciding the value of other fields Mv_TYP MV_REAS COSTCENTER GM_CODE MVT_ IND

in the Idoc .i.e runtime value of these three fields is deciding the value of other fields in the Idoc.

e.g

Source

Description Sign Cause Code

1PO/STO + 1 none

2rvrs PO/STO - 1 none

3returngoods + 1 none

4RevrsRtrnGoods - 1 none

5RvrsScrap + 1 none

6Qty2Qlty - 6 none

Corresponding target

Mv_TYP MV_REAS COSTCENTER GM_CODE MVT_ IND

101 none 01 B

102 none 01 B

202 1072 511100 03

201 1072 511100 03

552 03

322 none 06

How to do the value mapping so as to have the runtime value of src in the target fields in the Idoc

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2008 at 02:32 PM

    Hi Indu !

    If your mapping values are fixed, and a few, you can put them manually in the Integration Repository, using the standard FixValues function within graphical mapping.

    Otherwise, you can use the ValueMapping standard function of graphical mapping to access Value Mapping Groups (loaded by hand or dynamically) in Integration Directory.

    If this kind of value mapping doesn't fit your requirements, you can call an RFC or JDBC query via an UDF to query an external data source to map src values to target values.

    Regards,

    Matias.

    ps: please award points if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.