File to IDOC ( need advise on how to map file fields )
I spent quite some time reading all the helpful blogs and threads regarding File to Idoc scenario. However I had a very basic question ( maybe its trivial as I am just new to XI).
In my scenario I have Bank Master data (in a CSV file) and it does not correspond exactly to Bank Master IDOC structure BANK_CREATE01.
I understand that I will need to use File adapter to get this file into XI and then use an IDOC adapter to send it to R/3. (Pl correct me if I am wrong)
Now when I use file adapter, how will I do the data mapping. I mean do I need to create a structure which corresponds to file fields and then XI will automatically load my file fields into this structure and then I can use this structure to map fields to IDOC.
My only issue seems to be how will I see the FLAT FILE data in XML FORM in XI.
To explain it further my CSV file looks like
where GB corresponds to country, 123456 corresponds to Bank key, 112233445566 corresponds to Bank account, GBP is currency and so on
So should I create a data type maintaining same sequence of fields above without using any hierarchy like in the IDOC.
If this is not possible then will I need to transform my input file exactly into IDOC structure and then use it.
Hope I have manged to explain it.
Appreciate your help on same.