Skip to Content
0

How to Split GL line items in PI mapping

Nov 01, 2016 at 08:04 PM

36

avatar image
Former Member

Hello,

I need help for the following scenario :

PI will be receiving text files where the number of GL line items will be of the order say 3600 GL line per file.

Now we need to split the idoc in such that only 900 GL should come in one idoc.

Condition is, first 450 Debit GL account and their corresponding 450 Credit GL account with currency segment should come in one IDOC, and so on..

I have done the splitting logic, but first 900 Debit GL line item coming in one idoc and their corresponding Credit GL line item is coming in another IDOC. Which is not correct as per business requirement.

Can you please help me, How we can build this logic in PI mapping.

Thank You.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 02, 2016 at 03:08 AM
0

Hi Rohan,

You need to write a UDF and inside UDF you can read first 450 debit accounts and then read the corresponding credit accounts and create the target node. If you give me the example file so that we can able to help you.

Regards,

Praveen.

Share
10 |10000 characters needed characters left characters exceeded