Skip to Content

Aggregate the line items based on same values in message mapping in PI7.5

Hi All,

We are receiving accounting data over a text file and we need to aggregate the line items which are similar values on HKONT and AKONT for the same XBLNR.

Can you please help me to set up the logic in message mapping and provide the java code if we need to write udf.

I have attached source and expected target format for reference.(attached one context only) Source contains multiple context and we need to handle context change.

Source Format:

source.png

Target Format:

target.png

Also, 1. we need to do the sum (WRBTR & DMBTR) while merging the line items

2. YYLEGMARK value to be merged. (1|1/1/1/1)

Aggregation logic is not considered for when there is no value.(NULL)

Please let me know in case the requirement is not clear or need more inputs.

Regards,

Arun

source.png (7.5 kB)
target.png (5.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers