how to read MT940 file

[Former Member]

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

[former_member192295]

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

bypass with IR

[Former Member]

Hi,

To convert the MT940 into CSV file, Check this link.

http://mt940-to-csv.qarchive.org/

http://sap.ittoolbox.com/groups/technical-functional/sap-acct/convert-sap-mt940-into-multicash-forma...

Regards,

Phani

[Former Member]

Hi,

Refer this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a97fa590-0201-0010-04ba-beed13d6...

Regards,

surya

[prateek]

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

[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