ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Bank key/Bank Account number/ control key/

Bank key/Bank Account number/ control key/

原创 Linux操作系统 作者:canc3r 时间:2012-02-17 15:16:25 0 删除 编辑

供应商所在的银行是西班牙的,发现到对于西班牙,系统会对Bank Key,Account Number还有Control Key进行检查。

SAP有一个Function可以根据Bank Key,Account Number算出Control Key:

BKK_CREATE_BANK_CHECK_DIG_ES

但是程式需要修改,参考下面的两个Notes

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.

Other terms

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

Reason and Prerequisites

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
Permitted length, characters and additional information for the country:

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.

Germany

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

Finland

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).

France

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.

Italy

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.

Japan

The control key always has 2 digits and is numeric.

New Zealand

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).

Netherlands

The bank key has up to 11 digits and is without gaps.
The bank account has 10 digits and is numeric and without gaps.

Norway

The bank account number has 11 digits and is numeric and without gaps.

Portugal

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.

Russia

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).

Spain

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.

Sweden

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.

Switzerland

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

Hungary

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.

Australia

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)

Solution
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11782589/viewspace-716675/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-12-06

  • 博文量
    120
  • 访问量
    234578