Skip to Content
author's profile photo Former Member
Former Member

Translation table in PI

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2010 at 01:51 PM

    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-adb5e89a6638

    Regards,

    TK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 26, 2010 at 04:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.