4 Replies Latest reply: Jun 17, 2009 7:20 AM by Dahlia Tan RSS

SAP MT940 bank statement interface to SAP

Dahlia Tan
Currently Being Moderated

Dear expert,

 

We plan to integrate the bank statement in SAP MT940 format to SAP. Can you please kindly share if you have any information on how to configure the SAP for uploading the SAP MT940 format?

 

The configuration guide that I have is : FI Electronic Bank Statement from SAP R/3; based on this guide the recommended bank statement format is in Multicash Format.

 

Thank you very much in advance for your kind assistance.

 

Best regards,

DTan

  • Re: SAP MT940 bank statement interface to SAP
    Srikanth Boddupalli
    Currently Being Moderated

    Hi Tan,

    EBS configuration part in SAP do not depend on the bank statement format. There wont be any difference in the configuration of posting rules. The only thing will be the external transaction type, you need to make sure what it is coming in the bank statement file. This you can see in field 61 starting for MT940 format. Based on the external transaction you need to assign your required posting rules.

     

    Hope you understood.

     

    Regards

    Srikanth

    • Re: SAP MT940 bank statement interface to SAP
      Dahlia Tan
      Currently Being Moderated

      Thanks Srikanth,

       

      I am still not very clear on the mapping.

      In SAP EBS following configuration is required:

      1. Create Accounts Symbol

      2. Assign GL accts to Accts Symbol

      3. Create Keys for posting rules

      4. Define posting rules

      5. Define External transaction type, link with Keys for posting rules.

       

      However in SWIFT MT940, there are many data with different tags.

      So tag 61 is mapped with SAP - External Transaction Type. There are many sub fields in Tag 61, to be more specific is it tag 61 - sub field 6 - "Entry Reason" field mapped to external transaction type?

       

      What about the rest of the tag in SWIFT MT940, how do I mapped it into SAP configuration?

       

      Again, thank you very much for your kind assistance.

       

      Rgds

      DTan

      • Re: SAP MT940 bank statement interface to SAP
        Srikanth Boddupalli
        Currently Being Moderated

        Hi Tan,

        Based on the external transaction type, you will link to the posting rules. Yes there are so many subfields, available if you see 61 fields, it tells you about the payment you have received/made, it gives the line item details of a particular transaction.

         

        My sincere request is dont look at the bank statement and do the configuration. Do the configuration first and then SAP provides one program RFEBKATX. Using this program you can create a bank statement file and customer line items. Once after bank statement file is created you can import it using FF_5 and if your configuration is not properly made, it will let you know where you are missing. But this program will generate bank statement file in multi cash. How ever if your configuration is correct and if you are able to import bank statement, then there will not be any difficulty in importing MT 940.

         

        Hope you understood.

         

        Regards

        Srikanth

Actions