Skip to Content
avatar image
Former Member

how to read MT940 file

Hi Experts,

I am trying to create a source data type in XI. I am receiving a file which is a bank statement MT940 format.

As there is no common separator in this format, how to slip the different contents in to fields and subfields.

I need to send this file to sap system but before that i need to do a simple lookup which will give me the destination.So please let me know how to create a structure in Xi which can read the MT 940 file, even if we use FCC there should be a common separator based on which we can split in to different fields.

Please help me in creating a DT which can receive the MT940 file .

I am giving the sample MT940 file here :

your inputs will be very helpful

Regards,,

Sri

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 13, 2008 at 12:08 PM

    U may transer the complete content as a single field in FCC. Now this way you will have a single field with complete data. Then use java mapping to break the structure into required target format based on specifications provided here

    http://martin.hinner.info/bankconvert/swift_mt940_942.pdf

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      As Mentioned in the comments above can we read entire content of the input txt file in a single element (Feild) in our source structure .

      I tried doing this but i am geting only the first line.

      Can anybody guide me regarding the appropritate steps to be written in FCC , so that entire file can be read in one feild.

      Regards,

      Sri

  • avatar image
    Former Member
    Oct 13, 2008 at 12:30 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 13, 2008 at 01:55 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 13, 2008 at 02:01 PM

    Hi,

    We can read easily with below statement. At source end take one string variable and write below statement at source end meanwhile receiver also.

    At source end:

    source.fieldNames a

    source.endSeparator nl

    ignoreRecordsetName true

    At Target end:

    Target.fieldNames b

    target.endSeparator nl

    ignoreRecordsetName true

    In MT 940 we can't recognized columns, each row is taken as string and read it and target side make same logic and past it. This format can understand SAP and we can upload data through standard transaction code FEBP.

    or

    Through bypass scenario also we can transfer data from source to SAP system specified folder, for bypass scenario find below link for configuration

    without IR

    How to send any data (even binary) through XI, without using the Integration Repository

    bypass with IR

    XI in the role of a FTP

    Add comment
    10|10000 characters needed characters exceeded