cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver file not able to write the data as required...

Former Member
0 Kudos

Hi All,

The scenario is file to file.

I am reading the data from the file for example the input file is in the below.

JAN1000250000

JAN2000380000

JAN2000330000

FRA130000

I want to write the data in the file.

The above structure is Header and Trailer is their.

In the file content conversations of the receiver file adapter I have added like the below.

Header.endSeparator 'nl'

Header.fieldSeparator #

Trailer.endSeparator 'nl'

Trailer.fieldSeparator #

Header.addHeaderLine 0

This is how I am getting the output of my receiver file.

10002#50000

FRA#130000

In this case the first 3 letters are missing (JAN) and it is reading only the first row of the header line JAN1000250000. For trailer it is fine.

Remaining below rows is missing.

JAN2000380000

JAN2000330000

I need the output should be like this.

JAN#10002#50000

JAN#20003#80000

JAN#20003#30000

FRA#130000

Not able to see the next line of the header details.

Can you tell me what I have to add in the Content Conversion to print the above format?

Thanks,

Jane.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member206604
Active Contributor
0 Kudos

Hi,

Check your message in SXMB_MONI. See the incoming message how it is read. See if you are hacing the values. Also post the complete details of the sender and reciever adapter. I guess it is not read properlly or not mapped.

Thanks,

Prakash

Former Member
0 Kudos

Hi Prakash,

For the sender side the data is reading fine.

Here are the Content Conversion for the sender file adapter.

Header.fieldFixedLengths 3,5,6

Header.keyFieldValue JAN

Header.fieldNames Id,Ra_Id,Sal,

Trailer.fieldFixedLengths 3,7,3

Trailer.keyFieldValue FRA

Trailer.fieldNames Id,Sum,Count

ignoreRecordsetName true

Here are the SXMB_MONI payload message.

<?xml version="1.0" encoding="utf-8" ?>

- <ns:EMP_IN_MT xmlns:ns="http://smartsoft.com/GY/FiletoFile">

- <Recordset>

- <Header>

<Id>REC</Id>

<Ra_Id>10002</Ra_Id>

<Sal>50000</Sal>

</Header>

- <Header>

<Id>REC</Id>

<Ra_Id>20003</Ra_Id>

<Sal>80000</Sal>

</Header>

- <Header>

<Id>REC</Id>

<Ra_Id>20003</Ra_Id>

<Sal>30000</Sal>

</Header>

- <Trailer>

<Id>TRL</Id>

<Sum>130000</Sum>

<Count>2</Count>

</Trailer>

</Recordset>

</ns:EMP_IN_MT>

Thanks,

Jane.

former_member206604
Active Contributor
0 Kudos

Hi,

Check what have you given in your Record Structure field.

Refer this :

http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm

Thanks.

Prakash