SAP PI-ServiceChannel Mapping

[Former Member]

Hello SAP PI Experts,

I have a requirement in PI to map with Servicechannel Portal,

We need to send a CSV file with the subtotals of materials as explained below,

For instance Invoice has 2 line items for Labor,We need to subtotal the value of both the line items in a single field and send it as CSV to ServiceChannel, Similarly for Service material and Travel material too.

Product hierarchy is common field across all the materials,

So using Product hierarchy feild in PI ,Is it possible to calculate the subtotals in PI ?

Regards

Siva

[engswee]

Hi Siva

Yes, it is possible to calculate subtotals using the standard sum function in Statistics group.

Below is a Wiki which has quite extensive coverage of the main standard functions - check it out.

Standard Functions in PI 7.0 - Process Integration - SCN Wiki

I would suggest that you try it out. If you have any further issues, do provide further details like actual source, target structure, sample source input, expected output, current mapping logic, etc.

Rgds

Eng Swee