cancel
Showing results for 
Search instead for 
Did you mean: 

File to IDOC ( need advise on how to map file fields )

Former Member
0 Kudos

Hello friends,

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

"GB,123456,11223344,GBP, London,.."
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.

Thanks

Shirin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Shrini,

First of all The CSV file has to be changed in to an XML file , To achieve this File Content Conversion has to be done.Once this is done, please make the following changes in R/3 and PI to push Idoc in to PI.

Configuration required at Xi side:

Go to IDX1: configure the port.

Go to IDX2: load the DOC metadata.

Go to SM59: Create RFC destination which points to R3 system this is require in the case where your IDOC is sent to R 3 system,

Configiration required at R3 side:

Maintain Logical System for PI (SALE transaction):

Maintain Partner Profile for XI system(WE20):

Thanks,

Kiran.

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanls for the answers. FCC is the key to convert file to XML data

Former Member
0 Kudos

Hi Shirin,

As I understand you want to transfer a flat file data in XML structure. For doing that you need to use FILE CONTENT CONVERSION in your Sender File Adapter.

See these blogs:

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

Regards,

Kamran Vakili