Problem in FILE to RFC scenerio

[Former Member]

Hi,

I am working on File to RFC Scenerio

I am getting a problime in Communication channel (Sender).

The problem is coming in File COntent Conversion

Parameters are like

Documenet name : MT_ROXY ( ->Header -> EMPNO

-> EMPNAME

-> DEPTNAME)

Recordset Name: Details

Recordset str : HEADER,*

Recordset Seq : Variable

" per message 😘

Conersion Params:

ignoreRecordsetName : True

HEADER.addHeaderLine : 0

HEADER.fieldSeperator: ,

HEADER.endSeperator: 'nl'

HEADER.fieldFixedLengths : 12,40,40

HEADER.fieldNames :EMPNO,EMPNAME,DEPARTMENTNAME

HEADER.lastFieldsOptional : YES

Problem:The message content i am getting is like

<ns:MT_ABAPPROXY>

&#8722;

<HEADER>

<EMPNO>IT,Munish,22</EMPNO>

</HEADER>

&#8722;

<HEADER>

<EMPNO>IP,Munish1,2</EMPNO>

</HEADER>

&#8722;

<HEADER>

<EMPNO>IS,Munish2,2</EMPNO>

</HEADER>

&#8722;

<HEADER>

<EMPNO>IQ,Munish3,2</EMPNO>

</HEADER>

&#8722;

<HEADER>

<EMPNO>IR,Munish4,2</EMPNO>

</HEADER>

</ns:MT_ABAPPROXY>

as it does not dividing the Fields by ,

as it shud come like

<EMPNO>IR,2</EMPNO>

<EMPNAME>Munish5</EMPNAME>?

<DEPARTMENTNAME>2</DEPARTMENTNAME>

but its not taking the other 2 filds and not separating by , sepreator,

Kindly guide me in solving this problem on urgent basis

Thanks in Advance

Munish SIngh

[Former Member · Accepted solution]

HI,

I have gone through ur FCC parameter.

You have used fieldseparator as well as fixed length as both can not be used at the same time.

HEADER.fieldSeperator: ,

HEADER.endSeperator: 'nl'

HEADER.fieldFixedLengths : 12,40,40

Can u pls tell me whether u r getting file in CSV format or with fixed length file.

Thnx

Chirag

[Former Member · Accepted solution]

hi chirag,

i am using text file and the data is like

IT,Munish,22

IP,Munish1,23

IS,Munish2,24

IQ,Munish3,25

IR,Munish4,26

[Former Member · Accepted solution]

HI,

Then use only fieldSeparator see the spelling it should be in proper case.

refer the below weblog for more information:

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Also refer the file FCC parameters.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

Thnx

Chirag

[Former Member · Accepted solution]

Hi chirag,

thanks a lot,

with your help the problem has been solved...

Cheers!!

[Former Member]

Hi,

Make the changes in the spelling "Seperator" to "Separator" and then try .

Regards,

Sarvesh