Skip to Content
avatar image
Former Member

How to create receiver file in SAP PI for each record debit line with preceding "N" then credit line

Hello All,

I have a requirement file to file like below.

Sender file sending single row, in PI i am spiting the row(Copying the same row) into 2 Rows and adding D/C as last field .Then I am doing lookup and getting related GL fields for each.Receiver suture is YFI_Excel so i need to generate this file in such a way that each record debit line with preceding "N" and credit line with just "blank" then second record(here receiver structure is same for credit line and debit line)

How to achieve this can you please help on this..

Sender (SF1= Sender filed1)

line1: SF1 SF2 Sf3...

line2: SF1 SF2 Sf3...

Spilting in PI

line1: SF1 SF2 Sf3... C

line1: SF1 SF2 Sf3... D

line2: SF1 SF2 Sf3... C

line2: SF1 SF2 Sf3... D

Then Lookup for each above line

I am getting :

line1: N RF1 RF2 Rf3...

line2: N RF1 RF2 Rf3...

RF1 RF2 Rf3...

RF1 RF2 Rf3...

But Expected Receiver file: (RF1= Receiver filed1)

line1: N RF1 RF2 Rf3...

RF1 RF2 Rf3...

line2: N RF1 RF2 Rf3...

RF1 RF2 Rf3...

How to achieve this can please guide..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 28, 2017 at 03:33 PM

    Venkat,

    You may use the concept which is explained in this thread. This looks similar to your issue.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded