Issue with Two Different Bank Key for same House Bank

[Former Member]

Dear All,

I have one requirement in Bank accounting.. i.e. I have setup one  House Bank with Bank key and it is working fine. But when bank sending  it's statement to us, it is sending with some different bank key and due to that I am not able to upload bank statement through FF_5.

e.g. For Barclay's Bank i have set up House bank with  bank key 207767 but when bank send us bank statement it is sending with  different bank key i.e 203019.

:20:20121121
:25:203019/48749199
:28:32326/01
:60F:C121121USD45821,53

I tried using bank alternative account filed by updating combination of Bank key + account number but no success.

How to deal with this requirement. Highly appreciated you valuable advice.

Regards,

Deepak

[Former Member]

Hi Deepak,

You can define one housebank for every Branch. Normally the customers in US use the bank number or ABA number as a bank key, that's why the standard configuration is set up as '1' in transaction OY17. 

Please set up your config according to your business requirement so that you can define one housebank for every Branch. Also in general please note the following: Regarding the creation of more than one bank account with the same payment method in the same bank, I must tell you the following:

For the same House Bank, payment method an currency you can only assing a unique Bank Account. It is not possible to assign several bank accounts.

The key fields for the table T042I are:

  ZBUKR  Paying company code
HBKID  Short key for a house bank
ZLSCH  Payment method
WAERS  Currency Key

So, only one entry can be created which have these fields with the same values. As fields "Bank", "payment method" and "currency", form a key all together. This means that considering a bank account, the three fields identify it, so there cannot be two bank accounts with the same bank, payment method and currency, because this would mean that you create the same account twice.

In SAP A Bank is determined by 2 things,

1. Bank country
2. Bank Key

Country can be same for all banks, while Bank key stands for physical location of each bank i.e. if you have one bank ICICI in India, Key is IN. You have 2 accounts one in Mumbai, 1 in Bandra branch, and 1 in Kurla Branch, now as these branches are 2 different physically present entities you need to create 2 different.

As suggested above having multiple account id in one bank is feature SAP has provided for scenario.  If you have 3 banks accounts Savings, Current and Fixed deposit in one Branck lets say Bandra ICICI then you can maintain 3 account id in one house bank.

Its better to follow proper procedures as at later stage there are various functionalities related to this physical existance of Bank branches for clearing of cheques, RTGS,NEFT transactions. If you transfer money within accounts of same branch and transfer money b/w two branches of same bank the procedures are different.

Hope this info helps.

Regards,

Fernando Almeida