on 07-06-2011 9:59 AM
Dear Team
We are creating vendor master record by LSMW for Japan company code. I have a issue in the vendor bank data
We have below bank details
Bank name : Tokyo-Mitsubishi UFJ , Bank code : 0005
Under this bank there are more than 20 branch name and branch code
For example
Branch name >West branch u2013 Osaka , branch code :545
Branch name > Kanda branch, branch code : 331
Like this we have more branches.
My question is should I need to create as much bank key with branch code in FI01.
Business needs to mention Main bank name in each of the branch
How to relate Bank name with branch name and code.
Plz help
Thanks for your support
Regards
M Raju
Hey MRaju
As per my understanding, there is no special link that can be created. It would have to be separate bank keys for separate branches. I would suggest you the below method to help you to link the main bank with the branch codes :
Bank Country Key : JP
Bank Key : 0005215
Bank Name : Tokyo-Mitsubishi UFJ
Bank Branch : 215 - Yokohama branch
Regards
MM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi below is the branch details for a main bank > Tokyo-Mitsubishi UFJ & its bank Code 0005
Branch
code Branch Name
215 Yokohama branch
450 Yokkaichi central branch
545 West branch - Osaka
041 Toranomon branch
036 Shinanobashi branch
195 Senju central branch
530 Osaka Chuo Branch
520 Osaka Chuo Branch
005 Osaka branch
333 Nihonbashi central
401 Nagoya central branch
010 Kanda Ekimae branch
331 Kanda branch
800 Iwakura branch
511 Hiroshima branch
001 Head office
313 Yaesu road
433 Bridge branch
062 Branch Kasugacho
580 Amagasaki Ekimae branch
Regards
MRaju
Hi MRaju
In FI01, SAP allows you to create a Bank Key with a single Bank Branch. Thus, you will have to create 20 different bank keys for your business to accomodate the 20 different branches. These can be assigned in the vendor master.
You will be allowed to enter the Main bank name in FI01.
What ideally should be done is, create the bank key in FI01. Here you will give the bank country key, bank key, main bank name, bank branch and additional bank address details.
When you do the lsmw for the vendor master, you can simply upload the bank country key, bank key, bank account number and account holder name. The rest of the bank data will get populated automatically.
Hope this information is helpful and is what you required.
Regards
MM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks MM for your immedicate response.
Now how to link the branch code with Main Bank.
For example
Main bank code is 0005 ( Tokyo-Mitsubishi UFJ )
Its Branch code are
215 > Yokohama branch
450 >Yokkaichi central branch
545 >West branch - Osaka
195 >Senju central branch
In the above example 4 branches are belongs to 0005 main bank.
If i create a bank key as 215 in FI01 , where do i link 0005 .
Regards
MRaju.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.