Symptom
Bank Account Numbers exceeding 18 digits are not fully populated in the payment file XML node <CdtrAcct><Id><Othr><Id>. The system allows a maximum of 18 digits in the Bank Account field of the supplier bank data. Additional digits maintained in the Reference Details field in BP master are not included in the payment file generation. The payment file includes only the first 18 digits of the account number.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Maintain Bank Account Number and the Bank Reference Number in BP master General Data under Payment Transactions.
- Execute a payment run that creates payment media (for example, CGI XML).
- Observe that only the first 18 digits from the bank account field are populated; the digits stored in the Reference Details field are missing in node <CdtrAcct>.
Cause
The standard pre-settings for handling overly long account numbers for different countries/regions are described in SAP Note 1585003 - How to enter a long account number - SAP for Me . In most cases, the Reference field is used for the remaining digits of the account number. In other cases, the Control Key and/or Bank Number fields are used.
In Configuration Activity 102592 "Set Country-Specific Checks" the Checking Rule of Bank Account Number is the key that determines how the account number check is performed.
Resolution
Checking rule 0 is a special rule for excessively long account numbers. In some applications, the Account Number field has a length of only 18 characters. A longer account number is stored using an additional field, whereby no validation is possible for the entire account number using checking rules 1 to 8. The check using rule 0 behaves in the same way as with rule 1, except that the content of the additional field Reference is also taken into account. For applications with a sufficiently long Account Number field, rule 0 behaves like rule 1 without considering the Reference field.
Checking rule 0 can be used to override the default setting for the relevant country/region either by allowing use of the Reference field (for countries/regions without a default setting or with another default setting) or by forbidding use of the Reference field (for countries/regions for which there are no long account numbers in the system and where the Reference field is intended to be used for other purposes. In addition, checking rule 0 allows the Reference field to be used for a combination of purposes: The beginning of the field is used for the remaining digits of a long account number and the rest of the field is used for the reference details. When the Reference field is used in this way, the two entries in the field must be separated by a blank character.
Please check F1 Help of the Checking Rule field for more information.
Recommended settings for India:
The bank number is 11 characters long (IFSC) or 9 digits long (MICR). The account number is up to 20 characters long. In order to store the long account number correctly even in applications where the account number field is only 18 characters long, the Reference field can be used to store the remaining positions with the help of Checking Rule 0. The recommended settings are therefore:
Bank Account Number Length 20, Checking Rule 0
Bank Number Length 11, Checking Rule 1
See Also
Keywords
long bank account, more than 18 digits, reference details, bkref, bankn, zbnkn_ext, CdtrAcct, payment file, payment media, cgi xml, dmeex, country-specific checks, checking rule 0, sscui 102592, vendor bank account, OY17, Set Country-Specific Checks , KBA , FI-AP-AP-B-2CL , Payment Progam / Payment transfer (DE, JP, US) (Public Cld) , How To
SAP Knowledge Base Article - Public