Skip to Content
author's profile photo Former Member
Former Member

Importing House Bank Details Through DTW

Hi All,

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

Kind Regards,

Silpa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Sep 19, 2008 at 01:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Sep 18, 2008 at 07:17 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2008 at 07:21 AM

    Use the following template;

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2008 at 07:30 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.