cancel
Showing results for 
Search instead for 
Did you mean: 

DTW BP address

Former Member
0 Kudos

Hello,

i am unable to migrate BP address with DTW. which template should i use?? and should i fill the details in the template??

Please do help me, correct guidance will be highly appreciated.

Thanks in advance

Poonam

Accepted Solutions (1)

Accepted Solutions (1)

former_member541807
Active Contributor
0 Kudos

hi Poonam,

use the templates from the path. C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\Business Partners\Business Partner Master Data

1. OCRD - BusinessPartners.xlt

2. CRD1 - BPAddresses.xlt

ex.

from the template OCRD - BusinessPartner
CardCode = C00012

from the template CRD1 - BPAddresses
ParentKey = C00012
LineNum = 0
AddressName - BP address

ParentKey = C00012
LineNum = 1
AddressName - BP address

ParentKey = C00012
LineNum = 2
AddressName - BP address

this example is 1 BP with 3 address

regards,

Fidel

Former Member
0 Kudos

for bill to address what would be the linenum?

for pay to address what would be the linenum?

can i tranfer both bill to address and pay to address form same csv file? or i need to create two different files?

Former Member
0 Kudos

Hi Punam......

You need to put linenum 0 for first address for Bill to Address and linenum 1 for second address for other bill to address under same CardCode and same thing for Shipto Address......

Regards,

Rahul

Former Member
0 Kudos

what should be the linenum for ship to adress????????

Former Member
0 Kudos

It is again 0 for first address and 1 for second Address under same CardCode but here address Type for Ship To Address would be 'S'

Regards,

Rahul

Answers (1)

Answers (1)

vasileiosfasolis
Active Contributor
0 Kudos

Hi

have you tried to use the template BusinessPartners.xlt?