Problem to update BP-Addresses by DTW

[former_member656464]

Hello everyone

I tried to update our business partner database and was successfull with table OCRD. Unfortunately table CRD1 doesn't accept new data. I found out that column-name in database is Address, but DTW shoes AddressName. I only want to update the names of the companies, therefor my source-file has only 3 columns: linetype, recordkey and Addressname.

Thank you for your help!

Fritz Schwendemann

[former_member186095 · Accepted solution]

Hello,

Try to replicate this template :

RecordKey LineNum AddressName AddressType

RecordKey LineNum AddressName AddressType

1 A A SERVICE bo_BillTo

1 A A SERVICE bo_ShipTo

2 ABA MOTOR bo_BillTo

2 ABA MOTOR bo_ShipTo

LineNum is empty since you want to import but not to update.

Rgds,

[former_member656464 · Accepted solution]

Hi Jimmy and others with the same problem

Thank you very much for your help. I'm updating not importing. I just found out that I always have to enter '0' in column LineNum and I lacked column AddressType. Now it works fine, thank you!

Kind regards

Fritz Schwendemann