on 01-18-2008 1:17 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.