BNKA bank codes for Spain

[robert_roedel]

Hey everyone,

the bank directory file which I'm using to update BNKA provides the 4-digit bank codes for Spanish banks only. Meaning, the file doesn't contain an entry for each combination of 4-digit bank code + 4-digit branch code. As the BIC can already be derived from the bank code the file contains one record for each bank code only.

But the Spanish bank accounts use the 8-digit bank key (4-digit bank code + 4-digit branch code). And by default function module CONVERT_IBAN_2_BANK_ACCOUNT_ES also converts an IBAN into an 8-digit bank key. But as BNKA only contains a record for the 4-digit bank code creating new bank accounts fails due to missing bank keys in BNKA.

Did anybody solve this problem already? The same problem should apply as well for Portugal or Greece for example.

Of course I can manually add all 8-digit combinations to BNKA. But then the bank directory file would be useless.

Happy to hear your thoughts.

Thanks,

Robert

[glavella]

Hello Robert, same problem… Did you solve it?

[robert_roedel · Accepted solution]

Hey, we are using the SAP specific BDE files in the meantime which are also provided by Swift. And these files contain all the 8-digit bank keys.

Best, Robert

[glavella · Accepted solution]

Hello Robert, thanks for your reply. Where could we get this file with 8 digit bank keys from? Many thanks

[robert_roedel · Accepted solution]

Hey, you need a corresponding contract with Swift and in your account you will then find a download area for the files (see https://www.swiftrefdata.com/new/en/download). With the new contract we have switched from the IBAN PLUS file to the Bank Directory SAP file. Best, Robert

[glavella · Accepted solution]

Hello Robert, unfortunately we do not have a Swift account. Would you be so kind to share this bank directory file for Spain? Thank you very much

[robert_roedel · Accepted solution]

It's one big file for all banks of the world which are registered at Swift. And this file is part of a paid service so I can't share it with you.

[glavella · Accepted solution]

Hello Robert, for the size there is no problem, we can exchange it to a shared folder. I know it is a paid service, but if you can do me this great favor I will be infinitely grateful if you can upload it to this folder: https://drive.google.com/drive/folders/1Gf7dnaoHgxMKWaOPg_Zzukv9ypCioeDl?usp=sharing Thank you so much!