Importing House Bank Details Through DTW

[Former Member]

Hi All,

Please explain how to import House bank details to vendor master data through DTW.

Kind Regards,

Silpa

[former_member708266 · Accepted solution]

Dear,

Please follow these instructions to import bank definitions and house bank accounts using the DTW.

In version 2004A it was only possible to import bank details for Business Partners.

In version 2005A it is now possible to import bank definitions and house

bank accounts.

1) The oBanks template is used to import Bank Definitions.

2) The oHouseBankAccount template is used to import House Bank accounts.

When importing Bank Definitions, the mandatory fields are the Bank Code

e.g. 123456 and the Country code e.g. FR.

Leave the absolute entry field blank.

When importing house bank accounts using the oHouseBankAccounts template, the 1st thing you need to specify (like in SBO) is the Bank

code. This is the Bankkey column.

This corresponds to the Absolute Entry from the ODSC table.

In SBO the banking function has changed.

Now in Administration - Setup - Banking you enter the codes for your House Banks and your Customer and Supplier banks.

In 2005A, to enter or create branches, accounts addresses etc go to

Administration, Setup, Banking, House Bank accounts.

Finally in Administration - Setup - Banking - Banks, in the Accounts column - You can select your default bank account by pressing Tab.

Wish it is useful for you

Regards

Apple

[Former Member · Accepted solution]

Hi Apple,

Thaks for giving the usefull information.Apple what i want exactly is i want to upload housebank details to perticular vendor through oBusinessPartners template.Apple,once you go and have a look at oBusineesPartners template you will find out the fields House Bank,House Bankcode,House Bankcountry ,House Bankbranch.I you know the solution please replay me.

Kind Regards

Silpa.N

[former_member708266 · Accepted solution]

Dear,

You can udpate the housebanks for the suppliers through the business partner file. You have to update the fields Housebank, houseaccount, housebankcountry and the housebankbranch if applicable. You will find these values in the defintions of the bank under administration.

I hope this helps

Regards

Apple

[Former Member]

House Bank detail is not upload with BP template but before it.

You need Bank template to DTW the detail bank info first.

Then upload BP with the code only for the Bank you already uploaded.

Finally DTW the oBPBankAccounts template for Bank acount if any.

Thanks,

Gordon

[Former Member]

Hello Gordon,

First i have uploaded the oBanks template after that a i hahe uploaded oHouseBankAccounts. i have uploaded oBusinessPartner template with house bank details and vendor.here error log shows like "Bank doesn't exist in the company application defined or objectdefined.can you please tell me the detailed steps how to do that?

Kind Regards

Silpa.N

[Former Member]

Hi Gordon,

Bank code field is not there in oBusinessPartner template.but Bank country field is available.

[Former Member]

use 'BPBankAccounts' template available in the BusinessPartner Folder.

[Former Member]

Use the following template;

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oBanks

[former_member217067]

Dear Silpa,

Please use the Bank Accounts template available in the folder: ...\Data Transfer Workbench\Templates\Templates\oBusinessPartners

Regards,

Pavol

Edited by: Pavol Hrasko on Sep 18, 2008 9:18 AM