While migrating Employee Data - Spain into the system, you get the error message: Bank account number not valid according to check digit calculation code.
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Go to the Overview view.
- Search for Migration of Employee Data - Spain activity and select it.
- Click open the same or click Change Immediately.
- Click on Migrate basic employee data using the migration tool.
- Select the File with Migration Status In Process.
- Click Execute Migration and select Execute Migration Step by Step.
- During Simulation Import you see the error message - Bank account number not valid according to check digit calculation code.
The issue is because of incorrect Bank Account Number maintained in the migration template. For country Spain, the IBAN format - ESAA-BBBB-CCCC-DD-XXXXXXXXXX
ES = Spain
AA = Check Digits
BBBB = Bank Code
CCCC = Branch Code
DD = National Check Digit
XXXXXXXXXX = 10 digits Bank Account Number
If you enter the Bank Account Number = XXXXXXXXXX, then you see the error message. The Bank Account Number field in the migration template should have 20 digits number and this number is called as BBAN - Basic Bank Account Number. This number can be generated from IBAN. For example, if the IBAN = ESAA-BBBB-CCCC-DD-XXXXXXXXXX, then the BBAN(Basic Bank Account Number) is BBBB-CCCC-DD-XXXXXXXXXX.
This is a standard system behavior.
Bank account number not valid according to check digit calculation code, Employee migration error, Check Digit Not Valid , KBA , employee migration error , bank account number not valid according , check digit not valid , SRD-FIN-CLM , Cash and Liquity Managment , Known Error