Skip to Content
0

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

Jul 28, 2017 at 03:20 PM

64

avatar image
Former Member

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..

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

1 Answer

Manoj K Jul 28, 2017 at 03:33 PM
0

Venkat,

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

Br,

Manoj

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thanks Monoj for help

0