供应商所在的银行是西班牙的,发现到对于西班牙,系统会对Bank Key,Account Number还有Control Key进行检查。
SAP有一个Function可以根据Bank Key,Account Number算出Control Key:
Note 1323541 - Bank control key for Spain is calculated incorrectly
Note 1445668 - Bank control key Spain/ES not correct
另外,Note 109589 - General information about bank account number checks,介绍了SAP系统关于银行信息的一些检查。
This note contains recommendation on how to enter the fields (bank
key, bank account number and bank control key) for vendors or
customers.
Bank account number, bank
key, bank number, bank control key, post office bank current account,
check digit, Belgium, Spain, Finland, France, Netherlands, Norway, New
Zealand, Japan, Portugal, Hungary, Italy, U.S.A., Sweden, Russia,
Switzerland, Germany, Australia, SSRV, BANK_ACCOUNT_CHECK,
BANK_NUMBER_CHECK
In
vendor or customer master data, you have the option of entering the
bank details. The entry of the fields for the bank key (BNo), bank
account and control key (CK) depends on the bank country.
The SAP system currently supports the following checks for the following countries:
Bank country Bank account number check Bank number check
------------------------------------------------------------------------
Belgium x -
Finland x -
France Bank no. and bank account no. are checked simultaneously
Italy Bank no. and bank account no. are checked simultaneously
New Zealand x x
Netherlands x -
Norway x -
Portugal Bank no. and bank account no. are checked simultaneously
Russia Bank no. and bank account no. are checked simultaneously
(as of Release 4.5A)
Spain Bank no. and bank account no. are checked simultaneously
Sweden x -
Hungary x x
Furthermore,
there is a check for the control key for Japan and checks for post
office bank current account numbers for Germany and Switzerland.
The
table T005 (transaction OY17, table T005, view maintenance, choose
V_005_B) contains information about the permitted length and also
additional information (for example, whether the number is without gaps
or is numeric). Here you also find the 'Bank data' checkbox, where you
can deactivate further checks for the bank key or bank account number.
Note that the formal check is always called.
The bank key or
the bank number is to be entered in the 'Bank key' field. The 'Bank
account number' field should contain a combination of the bank key, the
account number or the branch respectively. For more information for
each country see below.
The 'Control key' field can contain the following data:
- 1. A check digit the account is checked against
- 2. Additional information about the bank account if the bank account number has more than 18 digits (for example, Russia)
- 3. Suffix
Belgium
The bank key has 3 digits and is numeric and without gaps.
The bank account has 14 digits (the first 3 digits are the bank key) and there must be a hyphen at the 4th and 12th position.
The last 2 digits are the check digits.
The
post office bank current account number has up to 10 digits, is
without gaps and may only have one hyphen. Exactly 3 digits must follow
after the hyphen.
Examples: 777-301, 9-752
The bank key has 6 digits and is numeric and without gaps.
The
bank account has 14 digits (without a hyphen) or 15 digits (if there
is a hyphen at the 7th position). The first 6 positions contain the bank
key.
The last digit is the check digit.
There is no check for the numbers in interval 81.. to 89.. (see Note 109520).
The
bank key has 10 digits (5 positions stand for the bank number and 5
positions for the branch) and is numeric and without gaps.
The bank account has 11 digits, letters are allowed.
The bank key, the bank account number and the control key are checked simultaneously.
The control key always has 2 digits and is numeric.
The
bank key has 10 digits (5 positions stand for the bank number and 5
positions for the branch) and is numeric and without gaps.
The bank account number has up to 12 digits, letters and special characters (' ' , '-', '.') are allowed.
The bank key, the bank account number and the control key are checked simultaneously.
The control key is always alphabetical.
The control key always has 2 digits and is numeric.
The bank key has 2 digits, is numeric, and only the following values are allowed: 01-09, 11-25, 27, 29-30, 31, 33.
The bank account number has up to 16 digits and is without gaps.
For the bank account, there are different checks that depend on the length (the first 4 digits stand for the branch).
For
each bank number, there is an interval that is valid for the bank
account number; for example, only branches '0001' to '0999' are valid
for the bank number '01' (see Note 109921).
The bank key has up to 11 digits and is without gaps.
The bank account has 10 digits and is numeric and without gaps.
The bank account number has 11 digits and is numeric and without gaps.
The
bank key has 8 digits (4 positions stand for the bank number and 4
positions for the branch) and is numeric and without gaps.
The bank account number has up to 11 digits and is numeric and without gaps.
The control key has 2 digits and is numeric.
The bank key, the bank account number and the control key are checked simultaneously.
The bank key has up to 9 digits.
The
bank account number has 20 digits. Since the 'Bank account number'
only field has 18 digits, the first 2 positions of the bank account
number contain the control key (CK).
The
bank key has 8 digits (4 positions stand for the bank number and 4
positions for the branch) and is numeric and without gaps.
The bank account number has 10 digits and is numeric and without gaps.
The control key has 2 digits and is numeric.
The bank key, the bank account number and the control key are checked simultaneously.
The bank key has 4 digits and is numeric and without gaps.
The bank account number has up to 11 digits and is without gaps. The first 4 positions contain the bank key.
The
post office bank current account number has up to 11 digits, is
without gaps, and contains 2 hyphens. If the length of the post office
bank current account number is 6, the post office bank current account
cannot contain a hyphen.
Examples:
70-4152-8, 20-413-4, 10-123456-4
The bank key has 8 digits and is numeric and without gaps.
The bank account number has either 17 or 8 digits.
The bank account number must contain exactly one hyphen if the field has
a length of 17 digits.
The
bank number has up to 7 digits, is numeric and contains 1 hyphen at
the 4th position. The first 3 digits contain the branch bank.
The bank account number has up to 9 digits and is numeric.
Example: 083-361 (bank key)
117111990 (bank account number)
If the system issues an error message when you enter the bank data, check whether all data has been entered correctly.
The following table shows an example of what the fields should look like when entering bank data.
Country Bank key Bank account Control key
------------------------------------------------------------------------
Belgium 320 320-0347134-41 -
Finland 123456 12345600000785 -
France 2004101005 0500012M026 06
Italy 0345203202 2819 30 P
Japan - - 09
New Zealand 1) 01 0902068389-00 -
New Zealand 2) 09 0000-74712 -
Netherlands - 0502664959 -
Norway - 99994767484 -
Portugal 00350577 00006403900 30
Russia 044525202 70281080070013926 40
Spain 00120345 0000067890 03
Sweden 5028 50280000391 -
Hungary 1) 31364919 22013041-52006107 -
Hungary 2) 31364919 44735272 -
As of Release 4.5A, the SAP System provides the option to develop your own check routine and to link it to the SAP System.
To develop your own check routing, copy the sample module and refer to the more detailed information in the documentation.
Checks and sample modules
Check Sample module
------------------------------------------------------------------------
Bank account number check SAMPLE_INTERFACE_00003000
Bank number check SAMPLE_INTERFACE_00003010 post off. bank current acct no check SAMPLE_INTERFACE_00003020