Skip to Content
avatar image
Former Member

How to Split GL line items in PI mapping

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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.

    Add comment
    10|10000 characters needed characters exceeded