Value mapping

[Former Member]

I know that in fix value mapping we relate the fix values which are identified differently at source and target side.

Q What is the difference between value mapping defined in ID and fixed value mapping defined in IR.

Q2 What are look up tables? Please explain with an example.

Q3 When to go with defining fix value mapping and value mapping?

[Former Member]

Hi !

1) Fixed value tables, are FIXED, that is, you need to enter IR to modify values for a already activated and working interface. You need to give modify access to the user, to the development tool. Value mapping in ID, allows you to add more specific data, to share the values mapping table among several interfaces, to fill that data manually in ID (allowing the user only to access this configuration environment), and also fill those values dinamically via Value Mapping Replication, using another data source as a excel file, database, etc.

2) look up tables is a technique to query external tables during mapping. Suppose you need to convert a customer ID from source to customer number to insert it in destination system. You could query an internal table of the destination system and search which customer number belongs to that customer ID. That query, in most cases could be started via JAVA inside a UDF, to connect to a R/3 system via RFC, or a database via JDBC. For this connections you could use the included LOOKUP API and put connection data in comm channels.

3) read item 1) fixed is FIXED, value mapping could be dynamic.

Regards,

Matias

ps: please award points if helpful.

[GabrielSagaya]

Value mapping - converting a value in the source to a another in target. Say in source it might me KM but in target u might need Kilometers

Converts source format into target format specified in the look up table.Suppose in source it might me IND but in target u might want India.

Fix Values

**********

The FixValues function provides a simple generic value mapping (key mapping) in IR.

1. Use the standard function -> Conversions -> FixValues to link source and target element

2. Double click to define properties

a) Each field mapping uses its own table of key-value pairs.

b) Filled tables can be copied to other mappings. But copied table is independent of origin

Value Mapping

*************

The Value mapping function provides a more specific value transformation.

1. Use the standard function Conversions -> Value mapping to link source and target element

2. Double click to define properties

3. Define access keys for table entries:

a)Value Mapping Context stores information on the origin of data. eg http://sap.com/xi/XI

b)Agency & Schema for sender and receiver messages. Any arbitrary string value can be used