Country Specific IBAN Update

[Former Member]

Country Specific- Qatar & Jordan IBAN Update Process

Back ground of the IBAN Process: -

International Bank Account Number is an internationally agreed system to identify bank accounts across borders to facilitate communication & processing of cross border transactions with reduced risk of transcription errors. In simple terms, it is a series of alphanumeric characters that uniquely identifies a customer’s account held at bank anywhere in the world.

For many countries IBAN has been a mandatory requirement and there are some countries to which IBAN has been recommended. Qatar & Jordan are one among to which IBAN has become effective from Jan 1^st 2014 & Feb 1^st 2014 respectively.

An international bank account number typically consists of two-character ISO country code;two check digits for validation purposes followed by the domestic bank code and account number. It is maintained as below:

Issue/Requirement Statement: -

SAP has standard size of 18 characters that are allowed for bank account number. Though Jordan complies with the standard functionality but for Qatar the standard norm followed in the banks are 21 digits.

Solution for the above Requirement: -

For Qatar, since the bank account digits does not comply with the standard, SAP has provided the OSS Note 1955708for the bank account number contained in IBAN, which is longer than 18 digits.

This OSS note has detailed out the configurations maintained in the customer product & business event transactions. They are as follows:

1. Transaction BF24, new entry (the values in the columns Product & Text are just examples)

Product	Text	RFC destination	A
IBAN_QA	Long account number Qatar		X

1. Transaction BF34, new entry (the value in column Ctr is the country code)

Event	Product	Ctr	Appl.	FM
00003070	IBAN_QA	QA		FBKK_3070_ACC_AND_REF
00003080	IBAN_QA	QA		FBKK_3080_ACC_AND_REF

With these settings the account numbers longer than 18 characters will be stored as follows:

• ü The first 18 characters into the field ‘Account Number’
• ü The remaining characters into the field ‘Reference’

The following BTE settings have been added via transaction BF31 for Qatar & Jordan specifically:

1. 1 New Entry

Event: 00003030

Ctr: JO

Function Module: CONVERT_BANK_ACCOUNT_2_IBAN_JO

1. 2 New Entry

Event: 00003030

Ctr: QA

Function Module: CONVERT_BANK_ACCOUNT_2_IBAN_QA

1. 3 New Entry

Event: 00003040

Ctr: JO

Function Module: CONVERT_IBAN_2_BANK_ACCOUNT_JO

1. 4  New Entry

Event: 00003040

Ctr: QA

Function Module: CONVERT_IBAN_2_BANK_ACCOUNT_QA

The validity, correction instructions &support packages & patches involved are:

Validity
Software Component	From Rel.	To Rel.	And subsequent
SAP_ABA	700	702
	710	711
	730	730
	731	731
	740	740

Correction Instructions
Software Component	Valid from	Valid to	Number
SAP_ABA	700	740	1673205

Support Packages
Software Component	Release	Support Package
SAP _ABA	700	SAPKA70031
	701	SAPKA70116
	702	SAPKA70216
	710	SAPKA71019
	711	SAPKA71114
	730	SAPKA73012
	731	SAPKA73112
	740	SAPKA74007

Solution Testing after OSS Note Implementation: -

1. 1.Below is the detailed out scenario for a vendor with bank country at Qatar & the bank account number that is more than 18 digits in IBAN

Bank Account: 001234567890ABCDEFG (more than 18 digits)

Country: QA

IBAN: QA58DOHB00001234567890ABCDEFG

The data in table LFKB:

The data in table TIBAN:

Execution of the payment run gives the following results

Payment posting Doc # 2014601391 posted

The XML file generated as follows:

The inbound Idoc, whichgot created as follows

1. 2. Below is the detailed out scenario for a vendor with bank country at Jordan & the bank account number that is equal to or less than 18 digits in IBAN

Bank Account: 2000007001 (less than or equal to 18 digits)

Country: JO

IBAN: JO82NBAD0020000000002000007001

The data in table LFBK

The data in table TIBAN

Execution of the payment run gives the following results

Payment posting Doc # 2014601393 posted

The XML file generated as follows:

The inbound Idoc, which got created as follows

Note: This OSS note refers to SAP note 1447761 (overview of IBAN converters) & 1012293 (IBAN & Maintenance of Bank Master data)

And this OSS note is referenced by SAP note 1958358 (Legal change: IBAN for Qatar)