Skip to Content

File content converstion substructures

Hi
I have the following file structure from sorce(Sender) .
I need to do convert into xml

Batch                                                         1..1
  BatchHeader                                           1..1
           DocumentType_H1                       1..1
           RDate                                             1..1
           RTime                                             1..1
  Dataset                                                  1..Unbound
        Supplier                                            1..1
                  DocumentType_H2              1..1
                  SuppID                                  1..1
  GoodsReceipt                                   0..Unbound
              PORecord   1..1
                          DocumentType_D1  1..1
                          PO_No                        1..1

1) How do I create the Record structure in file content conversion
BatchHeader,1,Supplier,* or should I include Dataset.Supplier also

2)
In additional configuration of FCc for field names or fixedlengths  ,
Supplier.fieldNames or Dataset.Supplier,fieldNames

My input file

H1test_test20131211220238

H210000104102

D14200803213

H210000108295

D1LL00R12016
H210000108296
D1KL00R12016
 

Thanks for your help

Mahesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 17, 2014 at 09:33 AM

    Hi Mahesh

    The best way would be to change your target structure in the below format

    Batch                                                         1..1

      BatchHeader                                           1..1

               DocumentType_H1                       1..1

               RDate                                             1..1

               RTime                                             1..1

      Dataset                                                  1..Unbound

          

                      DocumentType_H2              1..1

                      SuppID                                  1..1

      GoodsReceipt                                   0..Unbound

                 

                              DocumentType_D1  1..1

                              PO_No                        1..1


    Remove the line supplier and PO.


    But if you have strict restriction that you need to use the above structure, then create an intermediate structure as below


    Batch                                                         1..1

      BatchHeader                                           1..1

               DocumentType_H1                       1..1

               RDate                                             1..1

               RTime                                             1..1

      Dataset                                                  1..Unbound

          

                      DocumentType_H2              1..1

                      SuppID                                  1..1

      GoodsReceipt                                   0..Unbound

                 

                              DocumentType_D1  1..1

                              PO_No                        1..1


    Then create an extra message mapping which will map this intermediate structure to the actual structure.




    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2014 at 11:06 PM

    Hi Mahesh - It's not clear but if batchheader(BH), dataset(DS), goodsreceipt(GR) are on the same level then please check the below blog.

    The same configuration mentioned here

    SAPTechnical.COM - File Content Conversion

    SAPTechnical.COM - File Content Conversion

    Recordset structure : BH,1,DS,*,GR,*

    If they are not on the same level - please attach a screenshot of your datatype

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mahesh,

      you can only achieve this with below option

      1. Modify structure and change to this structure in mapping
      2. Pick up the file as it is and use Java map
      3. Custom adapter module.

      The best option is to use intermediat option and convert this to your input structure in mapping.

      regards,

      Harish