File Contenet Conversion in file receiver side for nested structure

[Former Member]

Hi All,

I am working on a sceanrio (Client Proxy to SFTP) where I need to generate a flat file in the target SFTP Server.

Record

   Batch_Header

     Header

          Line_Item

   Trailer

Below is the XML Structure:

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

<ns0:MT_PODataUpload xmlns:ns0="urn://XXXXX.com/YYY/POUpload">

   <Record>

      <Batch_Header>

         <Record_Type>1</Record_Type>

         <Mail_ID>4</Mail_ID>

         <Source_Mail_ID>5</Source_Mail_ID>

         <Header>

            <Record_Type>6</Record_Type>

            <Supplier_MailID>1</Supplier_MailID>

            <Receiver_MailID>1</Receiver_MailID>

            <With_Holding_Flag>1</With_Holding_Flag>

            <Line_Item>

               <Record_Type>1</Record_Type>

               <Item_Description>1</Item_Description>

               <Buyer>2</Buyer>

               <CC>2</CC>

               <Delivery_Date>2</Delivery_Date>

               <Last_Received_ID>2</Last_Received_ID>

            </Line_Item>

         </Header>

      </Batch_Header>

      <Trailer>

         <Record_Type>2</Record_Type>

         <To_Buc>1</To_Buc>

         <Batch_ID>2</Batch_ID>

         <Total_Records_Count>3</Total_Records_Count>

      </Trailer>

   </Record>

</ns0:MT_PODataUpload>

Could you please send me the FCC is configurations in file receiver communication channel.

Thanks,

Ramesh.D

[ambrish_mishra]

Hi Ramesh,

please check the below link

http://wiki.sdn.sap.com/wiki/display/XI/FCC+For+Hierarchical+Structure+in+Receiver+Channel

It should give you a head-start to solving this.

Ambrish