Skip to Content
May 07, 2020 at 07:49 AM

adress matching



Following problem
We have an Excel file.
In this file are different values.
We need three of these values to replace an old address in SAP with a new address.
Is it possible to run the whole thing through a transaction, maybe write the data into a CSV and read it in?

The procedure for changing an address is currently as follows:
Excel file - customer number -> open SAP transaction - click on customer and open -> then click on a word and click on edit -> replace old address with new address from excel -> insert comment -> save.

As there are more than 9000 addresses involved, automation would be very good.

If not by a transaction, maybe someone has another idea how to automate it.

Your thanksfull