File Content conversion problem

[Former Member]

Hi Friends,

I am trying file content conversion.My requirement is , I am going to provide text file with four field as follows:

1000,04042004,04052004,MT940

I wan to convert this into XML file using FCC like,

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

- <ns0:MTSENT xmlns:ns0="http:/black.com">

- <PaymentInfoMessage>

- <PaymentInfoRequest>

<CompanyCode>1000</CompanyCode>

<StartDate>04042002</StartDate>

<EndDate>04052004</EndDate>

<TransactionType>MT940</TransactionType>

</PaymentInfoRequest>

</PaymentInfoMessage>

</ns0:MTSENT>

I am refering to link http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

1) I had configured, IR and in ID I am not getting what to give in file content conversion tab to have output like this.

2) Am not gettin clear , about what is recordset,and record here..

In this XML PaymentInfoMessage is Recordset? what will be document name here?

Thanks ,

Brijesh

[Former Member · Accepted solution]

For sender File content conversion, refer

http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

this will answer all your questions,

Refer below link for example of content conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

[Former Member]

Thanks all... now able to generate XML as I want.. cheers...

[Former Member]

Hi,

According to your flat file structure pass this parameters in FCC file content conversion.

DocumentName: MTSENT (It refers mesage type)

DocumentName: http:/black.com (It refers namespace)

Recordset Name: PaymentInfoMessage

Recordset Structure: PaymentInfoRequest,*

Addtional paramertes are;

PaymentInfoRequest.fieldNames: CompanyCode,EndDate,TransactionType

PaymentInfoRequest.fieldSeparator: ,

PaymentInfoRequest.endSeparator: 'nl'

Regards,

Sameer

Edited by: sameer Khanna on Apr 7, 2009 9:02 AM

[Former Member]

Hi,

Please see the below link.

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/basicFileAdapterContentConversion

Regards,

Shweta.

[Former Member]

MTSENT---- Document Name

PaymentInfoMessage -

---

recordset name

Recordset Structure--- PaymentInfoRequest,*

PaymentInfoRequest----structure name

PaymentInfoRequest.fieldSeparator: ,

PaymentInfoRequest.fieldNames: CompanyCode,EndDate,TransactionType

PaymentInfoRequest.endSeparator: 'nl'

so on...

hope this helps u

Edited by: ragu r on Apr 7, 2009 9:08 AM