2913427 - Unable to Update Street and House_Number Fields of Account Address Using Data Workbench

You have a requirement to update the Account Address to make the filed House_Number as Blank and add that House Number in the field Street in the beginning. When you execute the DWB task with above requirement you notice that after the successful execution the address has not updated and it is still the same old address.

SAP Hybris Cloud For Customer

Export the data using DWB:

1. Go to Data WorkBench workcenter
2. Select Export view
3. Select Account Address object
4. Filter the required Account ID and Export
5. Keep the required fields and update the Street and House_number as required

Import the above saved Template in DWB:

1. Go to Data Workbench workcenter
2. Select Import view
3. Select Update option
4. Select Account Address object
5. Import the above template

After importing the Street & House_Number have not updated.

The Address handling has a special logic in place that is executed under the following circumstances:

• On the database an address is stored with the Street and House_Number fields filled in
• This address is now modified such that the House_Number field is cleared and the Street is filled with the combined former Street and House_Number values

 The address will not update in below scenario when you are updating the House_Number & Street together as mentioned below:

• House_Number=>  XX   to  Blank
• Street=>  Test   to   XX Test

 ( Where XX represents House number and Test represents street name)

In this specific case the modification is ignored.

The reason for this is that in the past we had several scenarios where a customer had bi-directional replication with some non-SAP product that only had a single field for street and house number. In that case the Street and House Number values that were maintained correctly (i.e. in separate fields) in C4C were not determined correctly due to difference in format (i.e. both moved to the Street field) after a single round trip, even if they were not changed at all. To prevent this from happening the above logic was implemented.

 Note: The above logic only applies if the modification matches the former content of Street and House Number exactly.

If the former House_Number is different than the one which you are adding to Street, in this case the update will work fine.

For example you are updating the Street and House_Number as below, in this scenario the modification would be performed as requested.:

• Street=> Test  to YY Street
• House Number=> XX to Blank

 ( Where YY represents house number different than YY)

There is a workaround for the earlier scenario, which is to explicitly clear the House_Number field in the first step (without changing the content of the Street field) and then perform the actual update in a second step to update the Street using Data Workbench.

Note: You may use the option update Blank while importing, this option will clear the filed which is left blank in the template.

Account Address , Can't update Address, Street , House_number , House_number blank, Update address using DWB , KBA , LOD-LE-RC-ADR , Address , Problem