Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Rename accounts in SAP R/3

Former Member
0 Kudos

We need to rename several hundred accounts in R/3 Enterprise system to meet new naming conventions. We should be able to keep the history of transactional data in the system. What is the best way?

1 ACCEPTED SOLUTION

Frank_Buchholz
Advisor
Advisor
0 Kudos

SAP offers a customer specific service to perform mass renaming of users including re-assigning of all related data. It's a highly customer specific service, because of quite different requirements of the customers who are planning such a renaming task.

Please contact the "SAP System Landscape Optimization" group via mail <a href="mailto:slo.consulting@sap.com">slo.consulting@sap.com</a>.

The "SAP System Landscape Optimization" group has the quick link <a href="http://service.sap.com/slo">SLO</a> in the service market place describing the standard services of the group (but without any information about the very customer specific user renaming service.)

Kind regards

Frank Buchholz

3 REPLIES 3

Former Member
0 Kudos

Hi Veena,

ihave tried to dig out this data for some time butnot of much success. I wanted to check where ther OLD SAP data is available when a user name is Renamed.

Eg : MATT is renamed to R3_MATT in our system and this change had MATT removed from all tables being replaced by the new entry.

But when we try to create MATT again it pops up saying OLD SAP office data found for this user. want to create it again..?

Looking for inputs in this query as well...

After CUA is implemented we no more had the chance for a rename of USER. It would not be availabale any more...

Br,

Sri

Award points for helpful answers.

WolfgangJanzen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Well, you've identified a big problem:

the userID (SY-UNAME) is not just used for logon but also as part of DB keys for many tables storing transaction data. Some of that data might already be archived (due to legal requirements you might need to keep that data for several years ...).

As everybody familiar with RDBMS knows, it's not possible to change the value of a key field without deleting and recreating the record. If you need to do that a thousand (or even million) times, you'll suffer.

How about using the <b>alias username</b>? That data can be changed without impact on the DB keys. However, the alias username can only be used as "logon username" for <u>http</u> logon (see ICF options: logon data -> authentication: "internet user"). During logon the alias username will be mapped to the (static) userID; from that moment on everything continues to work (internally) with the userID (SY-UNAME).

Regards, Wolfgang

Frank_Buchholz
Advisor
Advisor
0 Kudos

SAP offers a customer specific service to perform mass renaming of users including re-assigning of all related data. It's a highly customer specific service, because of quite different requirements of the customers who are planning such a renaming task.

Please contact the "SAP System Landscape Optimization" group via mail <a href="mailto:slo.consulting@sap.com">slo.consulting@sap.com</a>.

The "SAP System Landscape Optimization" group has the quick link <a href="http://service.sap.com/slo">SLO</a> in the service market place describing the standard services of the group (but without any information about the very customer specific user renaming service.)

Kind regards

Frank Buchholz