look up table with 4 colums in SAP PI

[Former Member]

Hi Friends,

I want to maintain lookup table in PI , need to store some data and need to perform lookup to retrieve data from looktable at the time of mapping.

BUYERNAME	DUNS	ID KEY	SNO

I knew i can achive this kind of requirement by creating ABAP table on top of PI ABAP stack and perform RFC lookup. but as per my client limitation it is not possible to do so.

Have two options, Fix value table or Value mapping .

is it possible to maintain value mapping table for 4 columns?

Many thanks in advance.

[former_member184789]

Also if you want to go for having such a lookup with Value Mapping groups inserted by utilizing the Value Mapping STandard webservice in NWA, please let me know I will provide you the details for the same.

[former_member184789]

Hi,

Do it as below:

1. Create a Value Mapping from one source schema to one target schema.

2. In target schema, store values meant for the other 3 columns separated by a delimiter say | eg

Field1 Values | Field2Values|Field3Values

3. In message mapping extract the single value containing the three fields separated with | and store it in a variable.

eg look how the value mapping will be done

SOurce Value        Target Value

Field1            Field2|Field3|Field4

4.Now you have in target the value Field2|Field3|Field4 in a variable.From this variable obtain the values by using a UDF which will split the field with |.

Please let me know if you need the UDF for this.

[smavachee]

1. PI Value Mapping doesn't sound good if you are dealing with large data sets.

2. You can store it in existing database tables and use JDBC look up.  It would be easy to maintain and If you are on PI 7.1, it supports graphical JDBC look up as well..

3. You can opt this one as well, check below link..

Value Mapping Replication for Mass Data in PI 7.0 or PI 7.1...

Regards,

Sunil

[gagandeep_batra]

Hi ,

i am not sure but you can look the following approach,

suppose you have to lookup based on some key column, eg. ID Key,

then you have two create 3 Fix value table like below:

IDKey:BayerName

IDKey:DUNS

IDKey:SNo

with this u can use java UDF also for more comlex logic.

Regards

Gagan