Employee Central IBAN bank validation

[karenperez]

INTRODUCTION

As know, there is, in SAP HCM Infotype 0009, an IBAN validation where it checks the number against the Bank Account, Bank Key, and Bank Country.

In Employee Central there is also some standard validations that is defined under Manage Data > Country Specific Validation Configuration. There you define the Bank validation for each country (example below from Portugal).

Image from Demo

Taking the Portuguese example, the system will check if the IBAN format is correct, where it represents the following:

IBAN: PT50000700000004372104423

PT	2!n	4!n	4!n	11!n	2!n
PT	50	0007	0000	00043721044	23

The Portuguese IBAN consists of the 2-digit bank control key, the 8-digit bank number, the 11-digit account number, and the 2-control digit.

For other countries definitions, please refer to this KBA.

This blog will cover one validation that is done by the standard in SAP on-premise, but not in Employee Central, which is the check of the bank key against the Bank database.

SOLUTION

For customers that have Employee Central integrated with SAP on-premise, when replicating the employee's Iban and it contains a Bank key that does not exist in the Bank database, the integration generates an error, and the data does not replicate (example below).

Image from Demo

Because this validation exists in SAP on-premise, but not in Employee Central, some customers ask to build something to prevent sending an Iban with a bank that is not part of the Bank database and for this, the proposed solution is to use Business Rules as described below.

Pre Requisite:

• Bank data must be maintained in Employee Central (Bank Standard Object).

 

Step 1

Define Error Message that you want to display in Employee Central when an Iban with a non-database bank is added:

Go to Manager Data > Create Message Definition

Image from Demo

Step 2

Create the Business Rule

Go to Configure Object Definition > PaymentInformationDetailV3 click to edit the object and locate the Iban field. In this field click on Details

Image from Demo

 

Scrow down to the Rules section and click on the + icon:

Image from Demo

Define the business rule as per the example below (this example is for a Portuguese Iban, so please consider the dentitions/format for the countries that you are implementing).

Image from Demo

Step 3

Add the Business rule onChange in the Iban field.

Still in the PaymentInformationDetailV3 > Iban field, add the new rule and click Finished

Image from Demo

Finally, Save the Object changes

Now you are ready to test.

Below is the negative test where we get the error message:

Image from Demo

CONCLUSION

This blog post described how to validate the Iban bank against the bank database in Employee Central, like the SAP on-premise validation.

With the proposed solution we aim to prevent Employee Central and SAP on-premise integration from stopping because the bank does not exist in the database.

Looking forward to your comments and questions.