SAP Knowledge Base Article - Public

2561159 - Payment Information: Configuring the Country Specific Bank Validation Object

Symptom

In the 1711 release (ECT-70874), it is possible to configure a new MDF object "Country Specific Validation Configuration" to define the Bank Data validations per country for Accounting Number, Routing Number, IBAN, and BIC.

A Country Specific Validation Configuration object contains Bank data validations for a particular country that are applied when an employee enters their bank data using the Payment Information Portlet. This ensures the personal account entries are in compliance with the country requirements. You can also change existing country validations as needed (e.g., for a legal change).

The options are Accounting Number, Routing Number, IBAN and BIC.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors Employee Central
  • Payment Information
  • Enable Bank Account Validation

Reproducing the Issue

  1. Navigate to Payment Information
  2. Create a new Payment Information record, and enter the Bank Country as Iraq
  3. Fill in the BIC, IBAN, Accounting Number, Routing Number > click Save
  4. You get the below error

ppp3 payinfo warning.jpg

Note the above warning may be slightly different and may show "Please ensure valid Routing number..." or "Please ensure valid IBAN number...".

Cause

This new feature allows customers to manually maintain their Bank Validation configuration on a Country Specific level, allowing more flexibility on data entry into Payment Information.

Some countries (such as Iraq) do not have any validations delivered, so they must be configured manually.

Resolution

In the 1711 release, it is possible to configure a new MDF object "Country Specific Bank Validation" to define the Bank Account validations used for each Country.

Index

 

 

Editing an existing Country Specific Bank Validation Object

  1. Navigate to Admin Center > Manage Data
  2. Click "Search", and select "Country Specific Validation Configuration"
  3. In the 2nd drop-down menu, choose the Country you wish to edit

Example.jpg

 

In the above example, we add an IBAN format validation for Austria. The format can be found here (note this will redirect to a PDF file on www.swift.com).

The format = AT2!n5!n11!n

Example :

AT 2!n 5!n 11!n
AT 61 19043 00234573201

 

  • ! = will enforce the exact length equal to the number on the left-hand side next to it. Example = 2!n = must be 2 numbers
  • n = Number
  • c = Character 

 

Creating a Country Specific Bank Validation Object

  1. Navigate to Admin Center > Manage Data
  2. In the "Create New" drop-down menu, select "Country Specific Validation Configuration"
  3. Select the Country you wish to create a Country Specific Validation Configuration
  4. Select the Object to be Validated. This field is used to select the field to be validated: Accounting Number, Routing Number, IBAN, and BIC
  5. Use the + symbol to add more validations

 

Object to be Validated breakdown:

 

IBAN

  • IBAN Length Without Spaces - You could define this as a flat number such as "20" (so exactly 20 characters), a range such as "5-20" where it must be between 5 and 20 characters in length, or even "5-20,22" where it must be between 5 and 20 characters in length or a maximum of 22.
  • IBAN Format - You can express a special format, such as "IQ2!n4!c5!n10!n", which would make the number be validated like "IQ 87 BYBA 12345 0123456789".
  • Is Validation Performed - Set to "Yes" to enable the validation or "No" to disable the validation.

 

BIC

  • Bank Country For BIC - You select the Bank Country used for BIC validation if different from the configured/delivered one.
  • Is Validation Performed - Set to "Yes" to enable the validation or "No" to disable the validation.

 

Account Number / Routing Number

  • Validation Type - You can choose between ISO SWIFT Format Based, Character Set Based, or Algorthm Based.
    • ISO Swift Format
      • ISO SWIFT Format Based - You have to give the ISO Swift Format, such as "AT" for Austria.
    • Character Set Based - This you could define as a flat number such as "10" (so 10 characters), a range such as "5-10" so it must be between 5 and 10 characters in length, or even "5-10,13" where it must be between 5 and 10 characters in length or a maximum of 13.
      • Numbers Allowed - Yes or No
      • Letters Allowed - Yes or No
      • Other Allowed Characters - If you need to include a hyphen or multiple characters (comma separates each charater) = -,+,%,?
    • Algorithm Based - Allow the hard-coded algorithm to decide on the format to be used for some supported countries
  • Is Validation Performed - Set to "Yes" to enable the validation or "No" to disable the validation

 

Error: Code Already Exists

You will receive this error message if you try to create a new "Country Specific Validation Configuration" for a country where a Country Specific Validation Configuration already exists:

code_exists.jpg

 

Additional Information

Please note that this configuration will be added to the Implementing and Configuring Payment Information in Employee Central handbook in the 1802 release cycle.

 

See Also

  • 2318830 - Employee Central - Payment Information
  • 2462005 - Remove validation for Payment Information
  • 2477238 - How to add new Country Specific configuration to Payment Information Detail object
  • 2305691 - Configuration for Country Specific Field in Payment Information UI
  • 2587647 - How to Import Country Specific Validation Configuration

Keywords

iraq, bank account validation, Invalid International Bank Account Number, IBAN, BIC, Account Number, Routing Number, payment information, validations, paymentInformationV3, Country Specific Validation Configuration, code already exists, SEPA, bank validation, ECT-70874, Please ensure valid Routing number, Please ensure valid account number , KBA , LOD-SF-EC-PAY , Payment Information (Bank Information) , LOD-SF-EC , Employee Central , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions