Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 14, 2008 at 04:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2008 at 11:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2008 at 07:26 PM

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

    Add comment
    10|10000 characters needed characters exceeded