SAP Customer Data migration to D365 FO - ADDRESSSTREET format

(0) Share

Report

Posted on by OM-04112205-0

We don’t know how to format the ADDRESSSTREET field in the D365 template so that our SAP address data stacks with carriage returns when importing. Our attempts have not worked.

Challenge: The SAP street address data is stored in separate fields (Street, Street2, etc). During migration, we must extract from SAP and bring multiple fields together into the ADDRESSSTREET field in D365 template. Thie issue is that we have to insert line separators in this ADDRESSSTREET to separate lines when importing into FO.

We need to extract from SAP and bring these fields together with some sort of 'carriage return' function that will cause separate lines in the ADDRESSSTREET field in D365 template. Our SAP ABAP developer tried a few things like '\n\r' but nothing has worked. Any tips are apprecicated.

The source data extracted from SAP will be imported into D365 using VerticalBarSeparated files.

Categories:

Dynamics 365 general

I have the same question (0)