cancel
Showing results for 
Search instead for 
Did you mean: 

value calculation

former_member223432
Participant
0 Kudos

Hi Experts,

I am working on IDOC to JDBC scenario....there is a segment which populates the amount field in ECC and the same is getting populated in JDBC table.

means, 5 times segment repeats in IDOC generates 5 detail table records in JDBC.

Sometime, it so happen that the same amount value repeats in ECC..in that case, we need to aggregate and populate in ONE detail.

ex: in 5 segments, 2 segments have 20 value each...then in JDBC, we should have 4 segments with 1 segment having (20+20).

Is this kind aggregation possible in PI or it is recommended to be done at the ECC side..please advise.

Smith.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184720
Active Contributor
0 Kudos

It's very much possible to handle in PI.

make use of the functions to aggregate.

former_member223432
Participant
0 Kudos

thanks...

can you please let me know the functions to use in this case.

thx

former_member184720
Active Contributor
0 Kudos

Hi Smith - It depends on your strcture.

If your are creating the node then you might have to use split by value(value changed-node functions) and sum(statistic).

May be you can share IDOC segment and relavent JDBC structure