Data Transfer Workbench error

[#1]

Hello experts

When loading Business Partners Bank account information using BPBankAccounts template on Data Transfer Warehouse, I am getting following error:

"Data transfer warehouse transcation commit unsuccessfully "

The thing is that when DTW is loading the records it is counting all records as successfully updated, but when the load ends and I see the log result, all entries are displaying mentioned error. Also this is happening when I try to load over 1000 entries, I have tried to load 10 entries and they all were successfull.

Thanks in advance and regards

[kothandaraman_nagarajan · Accepted solution]

Hi Javier,

Try to follow sample template under,

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Samples\1. Add New Data\Business Partners\Business Partner Master Data

If you get error message, please post your updating template here.

Thanks & Regards,

Nagarajan

[javier_facessantos · Accepted solution]

Hi Nagarajan

Thanks for the reply. No, I am using template under:

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Templates\Business Partners\Business Partner Master Data

Is there any problem by using this template? I have checked the template you mention and I am not really sure about how to use it.

Anyway I am posting my updating template just in case you see anything. The only columns that are filled are "Parent Key", "BP Code" and "IBAN" as the template is intended to update IBAN codes due to the new SEPA legislation. IBAN codes have been deleted from template due to privacity reasons, but all IBAN codes are checked and they are all correct.

Thanks and regards

carga masiva IBAN (SCN).txt.zip

[Former Member · Accepted solution]

Hi Javier,

Nagarajan was asking you to check your template against the samples provided by SAP. Only one template exists and you're using it.

Besides this, when something doesn't work with DTW, the first thing to do is to try is creating the exact same data by hand (with the FAT client).

From what I understand of your process, you're not giving a bank account but only an IBAN, and... The bank account is mandatory. You should split the IBAN in the misc. fields (at list Bank Account) and do a new nest.

Regards,

Eric