Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

PI mapping - group-by and sum

Hi,

In SAP PI, I have a Message Type with the following elements :

- PONum

- PODate

-Supplier

-Division

-EAN

-Quantity

-GrossPrice

I want to group by EAN and sum the field Quantity.

Can I do this by PI mapping ?

Can you help me ?

When I try to make mapping, I get the same number of rows in my target message type even if I have the same EAN in several rows.

My Message Type is sorted by EAN.

Thanks

Former Member
replied

Hello,

You have missed splitby value (Each value) function just after collapse context in EAN target field mapping. Ur mapping for EAN field should be:

EAN - Remove Context - SplitByValue(value change) - CC- SplitByValue(each value) - EAN

Thanks

Amit Srivastava

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question