Skip to Content

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

PI mapping - group-by and sum


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

- PONum

- PODate






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.


Former Member


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


Amit Srivastava

0 View this answer in context

Helpful Answer

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