cancel
Showing results for 
Search instead for 
Did you mean: 

Japan Main Bank name & branch name and branch code

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi do you have a complete list of Japan Banks with its branch code?

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks

MarcusKo
Discoverer
0 Kudos

Dear Chelian, we ware also implementing SAP at our local plant in Japan. Do you have any link to get a directory of japanese bank code + branche codes (like for  Tokyo-Mitsubishi UFJ )?  Thanks, Marcus!

Former Member
0 Kudos

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

Former Member
0 Kudos

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.