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 1st 2014 & Feb 1st 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

  1. 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)

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply