Translation table in PI

[Former Member]

Hi Guys,

I am working on IDOC to file sceanrio where in i am getting value for ORDER TYPE from SAP which they dont want to use directly at the target and hence they would generate a new ORDER TYPE by combining a REASON CODE value and thereby generates a new value for ORDER TYPE at target.

Ex: ZPTO(SAP ORDER TYPE) + ZS7( REASON CODE) == S99( TARGET ORDER TYPE).

i have been given a table with set of values like above.

How do i implement this in PI?.Need your valuable inputs.

Reply is very much appreciated.

Sahil

[former_member241146]

Hi Sahil.

You can use the FixValue Standard Function.

Follow a link about it:

(Function Category: Conversions)

http://help.sap.com/saphelp_nwpi71/helpdata/EN/ef/df564b6aa24fc9ab0d685460747de5/frameset.htm

Best Regards.

Bruno

[Former Member]

Hi Bruno,

Thanks for your reply but what you are talking about is fixed values.in my case it is like 2 inputs to 1 output.

Any other suggestion guys please??

Thanks

Sahil

[former_member241146]

Hi Sahil.

You can concatenate 2 inputs after you compare the result with the FixValue function. What do you think?

Ex.:

Concatenate ZPTO(SAP ORDER TYPE) + ZS7( REASON CODE) == ZPTOZS7

ZPTO(SAP ORDER TYPE) + ZS8( REASON CODE) == ZPTOZS8

After in the FixValue:

ZPTOZS7 -

---

> S99( TARGET ORDER TYPE).

ZPTOZS8 -

---

> S00( TARGET ORDER TYPE).

The result will be S99 .

I hope that this example helps you.

Best Regads.

Bruno

[Former Member]

Hi Sahil -

Use value mapping. Refer to the llink below -

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9202d890-0201-0010-1588-adb5e89a6...

Regards,

TK