About the IBAN (International Bank Account Number)

Former Member · ‎07-19-2005

Introduction

Since November 1996, the European Committee for Banking Standards (ECBS) developed a new standard, intended for cross-border banking transactions. SAP developed its modifications in order to adapt their products to this new requirement. This blog pretends to be a collector of all the steps that must be performed in order to have your system customized for the IBAN functionality. So I ask for your cooperation, folks!

Important: I'm working with SAP R/3 4.6C, so the following applies only to this release and further.

What is IBAN?

I strongly recommend you this brief explanation by ECBS about what IBAN is and how it's implemented. Of course you don't have to learn by heart every single step of the IBAN calculation and validation, but you may take this document as a functional/technical explanation of what function modules CHECK_IBAN, CONVERT_BANK_ACCOUNT_2_IBAN* and CONVERT_IBAN_2_BANK_ACCOUNT* actually do.

Let's go to work!

These are the notes I've collected till now:

392091 - IBAN: Use for vendors and customers
- Germany
- Belgium
- France
- Austria
- Switzerland
491546 - IBAN: Generation of the IBAN
748352 - IBAN for Hungary - additional information
795683 - IBAN generation: Country package 1
- Cyprus
- Czech Republic
- Estonia
- Greece
- Croatia
- Iceland
- Lituania
- Latvia
- Romania
- Slovenia
- Slovakia
459267 - IBAN: Incorrect IBANs generated
- Austria
- Germany
- Switzerland
- France
695118 - IBAN is not updated from MM or SD. Pre-requisites:
- 629668 - MIRO: Incorrect bank key with one-time vendors. Pre-requisites:
743172 - IBAN generation for Poland
852216 - IBAN not changed after you change the account number
722714 - No bank data generated from IBAN
671381 - IBAN: Incorrect display of change documents
...any more?
And of course search your SAP Support Portal with string "IBAN"

Non-SAP-standard implementations

Unfortunately, for a number of countries, SAP does not provide a standard functionality in order to generate the IBAN, nor to generate the national bank account. We have developed some customer-made function modules to convert from IBAN code to national bank account. These are:

AD - Andorra
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_AD.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(8). e_bank_account = i_iban+12(12).ENDFUNCTION.
BG - Bulgaria new!
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_BG.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(8). e_bank_account = i_iban+12(10).ENDFUNCTION.
CS - Serbia and Montenegro
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_CS.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(3). CONCATENATE: i_iban+7(13) '-' i_iban+20(2) INTO e_bank_account.ENDFUNCTION.
GI - Gibraltar
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_GI.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(4). e_bank_account = i_iban+8(15).ENDFUNCTION.
LI - Liechtenstein
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_LI.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(5). CONCATENATE: e_bank_number i_iban+9(12) INTO e_bank_account separated by space.ENDFUNCTION.
MK - Macedonia, FYR
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_MK.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(3). CONCATENATE: e_bank_number '-' i_iban+7(10) '-' i_iban+17(2) INTO e_bank_account.ENDFUNCTION.
MT - Malta
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_MT.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"----------------------------------------------------------------------e_bank_number = i_iban+4(9).e_bank_account = i_iban+13(18).ENDFUNCTION.
SE - Sweden
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_SE.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(3). e_bank_account = i_iban+12(11).ENDFUNCTION.
TN - Tunisia
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_TN.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(5). CONCATENATE: i_iban+9(13) ' ' i_iban+22(2) INTO e_bank_account.ENDFUNCTION.
TR - Turkey
FUNCTION Z_CONVERT_IBAN_BANK_ACCOUNT_TR.*"----------------------------------------------------------------------*"*"Interfase local*" IMPORTING*" VALUE(I_IBAN) TYPE IBAN*" EXPORTING*" VALUE(E_BANK_ACCOUNT) TYPE C*" VALUE(E_BANK_CONTROL_KEY) LIKE KNBK_BF-BKONT*" VALUE(E_BANK_NUMBER) LIKE BNKA-BNKLZ*" EXCEPTIONS*" NO_CONVERSION*"---------------------------------------------------------------------- e_bank_number = i_iban+4(5). e_bank_account = i_iban+10(16).ENDFUNCTION.

Any help/correction/comment on these function modules will be greatly appreciated and (why not!) rewarded with a coffee at our central offices at Barcelona

.

Last (but not least) words

Well, after all this list of countries (which could remind you of the Eurovision Song Contest) and notes and corrections, I only want to wish you "Good luck!". And please, any information you get about the IBAN issue, please reply to this blog and I'll update it ASAP.