Fix Values Standard Function

[Former Member]

Hi

My question is regarding the standard function Fix Values :

There is a Table where a field from the Legacy File ,if has a value X then 123 has to be passed to ERP and so on .....

I want to use Fix Value (key-Value Pair) in the same , but the limitation is that there are 200 such combinations

Is it advisable to manually fill these or is there a way that it can be accomplished in SAP XI deriving it from an excel sheet or somewhere?

The same are not stored in SAP and thus can't be looked up !

Kindly advise if there is an alternate if the Key value pairs are of large number of the order say 500 etc

Thanks

Dev

[Former Member]

> I want to use Fix Value (key-Value Pair) in the same , but the limitation is that there are 200 such combinations

> Is it advisable to manually fill these or is there a way that it can be accomplished in SAP XI deriving it from an excel sheet or somewhere?

No, it is not advisable to go with Fix Value table for such a big combinations. In longer term it will difficult to manage if you want to add some more new entries because for that you have to do the changes in your mapping.

>

> The same are not stored in SAP and thus can't be looked up !

The best way is to create the Value Mapping in IR. In longer term it will allow you to add or delete entries without making any changes in IR.

Regards,

Sarvesh

[former_member183909]

Another way would be to just pass the "X" value in the IDOC and then have the SAP IDOC userexit convert it. that way a table can be maintained by the users too in a simple manner.

[Former Member]

Hi ,

You can use JDBC lookup in this case(as answered above) .

Read an excel sheet directly in ur database table and then as usual use the JDBC lookups. This blog may help u:

/people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-import-sql-tables-metadata

Thanks

Amit

[Shabarish_Nair]

>

> Hi 
> 
> My question is regarding the standard function Fix Values :
> There is a Table where a field from the Legacy File ,if has a value X then 123 has to be passed to ERP and so on .....
> 
> I want to use Fix Value (key-Value Pair) in the same , but the limitation is that there are 200 such combinations 
> Is it advisable to manually fill these or is there a way that it can be accomplished in SAP XI  deriving it from an excel sheet or somewhere? 
> 

the best is to go for a value mapping instead of fixed values when the count is high

> The same are not stored in SAP and thus can't be looked up  ! 
> 
> Kindly advise if there is an alternate if the Key value pairs are of large number of the order say 500 etc 
> 
> Thanks 
> Dev

For mass loading of values, value mapping replication can be used - /people/udo.martens/blog/2009/04/03/value-mapping-replication-scenario

[Former Member]

Hi,

Why cant you use Value Mapping in IR. Replicate the data in Runtime cache using an PI interface.(Need to create a PI interface just to post the data in Runtime cache).

This should work fine.

Thanks & Regards,

Karthick

[Former Member]

Hi,

There are multiple methods of such look up's:

1.) You can use a JDBC lookup where u can connect to a sql table and pick up the values.

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2219] [original link is broken] [original link is broken] [original link is broken];

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8661] [original link is broken] [original link is broken] [original link is broken];

2.) You can also use a csv look up for the same but u will need a 3rd party JDBC csv adapter to acieve this.

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2800] [original link is broken] [original link is broken] [original link is broken];

Warm Regards,

Anshul

Edited by: Anshul Chowdhary on Jan 19, 2010 3:02 PM

[former_member204873]

hi,

You can use JDBC lookup for this. Store key value combination in an DB table. And use JDBC lookup in PI

Thanks!!