reference an EAI Value Map in an integration field map source expression

The requirement is to convert a field value from it’s external representation into it’s internal representation and visa versa by referencing a EAI Value Map in a Data Map.

According to the information included in eAI Volume IV: Business Processes and Rules, Data Mapping Using Scripts, EAI Value Maps, the functions EAIGetValueMap, EAILookupSiebel and EAILookupExternal work on the EAI data map tables.

The source expression in an integration field map can reference the EAI value maps.

You can use the EAILookupSiebel function for inbound value mapping which uses the following syntax:

EAILookupSiebel(“”,[Value],[])

You can use the EAILookupExternal function for outbound value mapping which uses the following syntax:

EAILookupExternal(“”,[Value],[])

The following is an example integration field map source expression:

EAILookupExternal(“SAP Country”, ifNULL(LookupName(‘COUNTRY’,[Bill To Country]), “USA”))

In this case, EAILookupExternal returns a value from the EAI data map table whereas LookupName returns a value from the LOV table.

Tags