Skip to Content
avatar image
Former Member

PI Add values from RFC and retain the context


Hello,

Can I know how do I achieve the below functionality in Graphical mapping?

Source structure has 4 segments as in below table with inputs (Input1, Input2, Input3 and Input4) which act as individual inputs to RFC. Values 10, 20, 30, and 35 in the last column of the table come as another field in the former structure. Target field should be a calculation of source and output from RFC as shown in the table.

Sample structure of source:

<Account>

<Item>

<site>Input1></site>

<tax>10</tax>

<check_field>X</check_field>

</Item>

</Account>

Calculation should only happen when the field the "check_field" in the structure is equal to "X".

Source RFC Output Expected Target Output Input1 Null 10 Input2 2 20 - (2 + 3 + 3) = 12 3 3 Input3 Null 30 Input44 35 - (4 + 2 + 1) = 28 2 1

Thank you in advance!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 18, 2015 at 10:01 AM

    Hi Ashish,

    Yes, this is possible. You can use this logic:

    RFCOut is the output from your RFC, I have simulated this by using a context UDF

    Sample test:

    Hope this helps,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Mark,

      RFC output in my mapping is creating new context for each row but I see rows are created as queue in yours. Anyways, I solved it myself using FormatByExample linking "item" node in the RFC output to the values that I have to sum.

      Thanks for the response!!