IBAN to BIC and SWIFT code

[Former Member]

Hi Experts,

I have received a new IBAN number from payment lot. I need to configure this customer bank information in sap. I did it using FI01, I have found IBAN rechner through which I am able to interpret the IBAN information. I have also used the FM, CONVERT_IBAN_2_BANK_ACCOUNT. But I am unable to recieve SWIFT code with IBAN. Bank information like Bank name, city and SWIFT code etc. Is there any FM or any procedure in SAP to find all this information.

Thanks in advance for your help!

[raviahuja]

Lakshmi,

You asked a similar question few days back and marked answer as correct. Haven't this solution helped you?

http://scn.sap.com/message/14161810

Regards,

Ravi

[Former Member]

Hi Ravi,

Thank you for getting back to me. The thing is the FM output is Name of the country, Bank number, konto number. I am not getting info. like BIC,SWIFT codes.

Additional information like Bank details would be helpful for me. This is what I am looking for.

[AmlanBanerjee · Accepted solution]

Hi Lakshmi,

The export parameters E_BANK_COUNTRY and E_BANK_NUMBER of the FM CONVERT_IBAN_2_BANK_ACCOUNT contains the Country and bank/branch code respectively.

You can use these parameters to retrieve the bank information like bank name,city and SWIFT code by passing them in the FM ISU_DB_BNKA_SINGLE if the particular bank master exist in SAP.

Hope it helps

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanku for your reply and for ur time:-)

I have used this FM, CONVERT_IBAN_2_BANK_ACCOUNT which returns information about the country and bank code. But it does not give any specific information about branch.

If I input country code and bank code to FM, ISU_DB_BNKA_SINGLE, it is retrieving the SWIFT code of the bank and not the specific branch. For example the output from this FM always fill the last 3 digits of the swift code with XXX instead of specific branch details.

Actual result:- DABADKKKXXXX

Expected:- DABADKKK021 - Including specific branch information.

Actually I am posting bank information(Master data) from FI01. As the data of that particular country is missing in the table BUTOBK itself, I suspect that is the table called in the background of the FM. May be I need to advice them to upload the bank data through BAUP tcode.

BIC info is still missing.

[AmlanBanerjee]

Hi Lakshmi,

Bank Information are stored in table BNKA. BUT0BK contains the bank details that are mapped against the Business Partner in IS-U.

I don't think the Standard FM, ISU_DB_BNKA_SINGLE, behaves the way as you have told in your post.

I have checked in my system and can confirm that it is displaying all the digits of the SWIFT code.

Check the SWIFT code that is maintained in BNKA table against the particular country and bank code in your System.

Moreover, the best practice is to have the bank master data in SAP up to date to avoid any issues.

So, if its not done for quite a while, you can upload the bank master through BAUP.

Hope it helps..

Thanks,

Amlan

[Former Member]

Hi Amlan,

The same SWIFT code values(with XXX as last digits, instead of exact bank branch information) are being maintained in BNKA table. As you have suspected it, I think bank master data is not upto date. From where can I get this file to update the bank information of European countries.

What should be the format of the file?

Thanks in advance!

Lakshmi.

[AmlanBanerjee]

Hi Lakshmi,

I think you should get the bank information from the Client.

When you are uploading bank information in SAP through BAUP, it should be country specific.

SAP have given different sample FM's for uploading the bank information based on the country.

Some of them are-

Austria-FILL_BNKA_FIELDS_AT1, FILL_BNKA_FIELDS_AT2

Switzerland-FILL_BNKA_FIELDS_CH2,FILL_BNKA_FIELDS_CH3

Denmark-FILL_BNKA_FIELDS_DK1

Spain-FILL_BNKA_FIELDS_ES1,FILL_BNKA_FIELDS_ES2

United Kingdom-FILL_BNKA_FIELDS_GB1, FILL_BNKA_FIELDS_GB2

Italy-FILL_BNKA_FIELDS_IT1

Hope it helps...

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanks a lot for your time and reply.

Actally I work at client side:-) May be they except from me to upload the file for them. Can I get the file somewhere from Internet or any other source to get the file?

If you have any sample file that matches with the input format of the FM's that you have specified, pls send it over. Any sample file to upload from BAUP tcode?

Thanks,

Lakshmi.

[former_member213036]

Lakshmi,

In which country are you working?

For my country (Belgium) this file could be found on the site of the national bank. This file can be uploaded in transaction BAUP. We use the national number as bank key.

If your bank key is set to the BIC code, maybe you can look at note 1683837 and transaction BIC2.

I haven't used it myself, so I won't be able to help you further with it.

Kind regards

[Former Member]

Hallo Dieter,

Thanks for the detailed explaination. I am working in Germany but we allow online shopping for many european countries. We are using Bank number as Bank key. Therefore, normally with the help of IBAN number from the payment lot, I am adding bank details everytime from FI01 tcode. Inorder to avoid this I am looking for alternatives.

Generally I add the bank details of Denmark, Austria,Italy,Greece etc..I hope the bank details for Germany are upto date.

Where can I find the file for these countries. Do I need to take care of validations,Format matching during upload?

Thanks and Regards.

Lakshmi.

[Former Member]

Hi Amlan Banerjee,

Which format we will use to upload France swift codes by T-code BAUP. Because i am not finding the format for France in BAUP.

Thanks

Santhosh

[AmlanBanerjee]

Hi Santosh,

Couldn't find anything Specific for France.

However, you can use the sample FM FILL_BNKA_FIELDS_SAMPLE and based on the inputs that you get from the Business with regards to the creation of the bank master, you can update the records accordingly.

Thanks,

Amlan 

[former_member213036]

Hi Lakshmi,

Does the corresponding bank exist in FI03?

As Amlan said, the SWIFT code is stored in the bank details. The bank needs to be defined in order for the conversion from IBAN to national bank account and the other way around to work.

Also check transaction BAUP.

There should be a country specific file to upload all banks known in your country.

Best practice is to keep this list up to date on a regular basis.

[aparna_dige]

Hi Experts,

Could you please tell me the steps to change a BIC code in a SAP for FIDES and Kyriba and what its global impact?