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

adress matching

69 Views

Hello

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