FCC in SFTP adapter

[sahithi_moparthi]

Hi,

   My scenario is from SFTP to IDOC.We are using FCC in SFTP adapter.

We have a nested structure in the file.The input file is as below:

01ABC12345 - Header

04FCD34567 -Item1

05AMGDC34

06XXXXXXXX

04FCD34567 -Item2

05AMGDC34

06XXXXXXXX

99ABCDED

We have created the structure as below:

MT_Data

  Header

       <Record>

             Document -04

            Payemnt -05

           PaymentInstruments -06

      </Record>

  Trailer

Could you please let me know how we can acheive this using FCC.

i have refered the below links and tried the FCC,but didn't get the correct output as expected.

http://scn.sap.com/thread/3263334

http://scn.sap.com/thread/3187445

[former_member182412 · Accepted solution]

Hi Sahithi,

You can skip Record from xml.recordsetStructure and use it like below:

xml.recordsetStructure = Header, Document, Payment, PaymentInstruments, Trailer

Regards,

Praveen.

[sahithi_moparthi · Accepted solution]

Hi Praveen,

I have given the parameters as above but it is giving below error:

I have configured FCC as below:

My Message type str is as below

[sahithi_moparthi · Accepted solution]

Hi,

Anyone please help me on the above error ?

In the output file,i am getting the Recordset.How to ignore the <Recordset> in SFTP.I have given ignoreRecordsetName to true,but still it is getting populated.

[former_member182412 · Accepted solution]

Hi Sahithi,

Use below FCC:

Example File and Output XML below:

01,ABC,12345
04,FCD,34567
05,AMG,DC34
06,XXXX,XXXX
04,FCD,34567
05,AMG,DC34
06,XXXX,XXXX
99,ABC,DED

<?xml version="1.0" encoding="utf-8"?>
<ns:FileSenderData xmlns:ns="urn:ch:test:prototype">
<RecordSet>
  <FileHeader>
  <RecordType>01</RecordType>
  <Field1>ABC</Field1>
  <Field2>12345</Field2>
  </FileHeader>
  <Documents>
  <RecordType>04</RecordType>
  <Field1>FCD</Field1>
  <Field2>34567</Field2>
  </Documents>
  <Payments>
  <RecordType>05</RecordType>
  <Field1>AMG</Field1>
  <Field2>DC34</Field2>
  </Payments>
  <PaymentInstruments>
  <RecordType>06</RecordType>
  <Field1>XXXX</Field1>
  <Field2>XXXX</Field2>
  </PaymentInstruments>
</RecordSet>
<RecordSet>
  <Documents>
  <RecordType>04</RecordType>
  <Field1>FCD</Field1>
  <Field2>34567</Field2>
  </Documents>
  <Payments>
  <RecordType>05</RecordType>
  <Field1>AMG</Field1>
  <Field2>DC34</Field2>
  </Payments>
  <PaymentInstruments>
  <RecordType>06</RecordType>
  <Field1>XXXX</Field1>
  <Field2>XXXX</Field2>
  </PaymentInstruments>
  <FileTrailer>
  <RecordType>99</RecordType>
  <Field1>ABC</Field1>
  <Field2>DED</Field2>
  </FileTrailer>
</RecordSet>
</ns:FileSenderData>

Regards,

Praveen.

[sahithi_moparthi · Accepted solution]

Hi Praveen,

     With my configuration also,the output is same as mentioned by you.But i want to ignore the <Recordset> in my output.

How can we acheive that in FCC ?I tried xml.ignoreRecordsetName= true,but no luck

[former_member184720 · Accepted solution]

I don't think ignoreRecordsetName is supported by Message Transformation Bean but you can handle it in the mapping right?

Any issues with that?

[sahithi_moparthi · Accepted solution]

Hi,

Thanks for your inputs.It is working.I handled it in Mapping.