Delete old Clients

[Former Member]

Hi there,

In Our ECC Dev system we have some old clients e.g. 020, 070, 330 etc

I know I can delete these in transaction SCC5. However, you need to be logged into

that client first in order to delete it. These are very old clients and I have no record

of any user accounts for each client.

So I am unable to login to each client in order to delete!

Is there a back door method I can use?

Thanks

Andy

[Former Member · Accepted solution]

Hallo,

login into the database and delete user sap* from table usr02, e.g. for Oracle

SQL> delete from sapr3.usr02 where bname='SAP*' and mandt='<CLIENT NUMBER>';

SQL> COMMIT;

Set profile parameter in the instance profile

login/no_automatic_user_sapstar = 0

Restart SAP

Login to the client as user SAP* with password PASS.

Create yourself a proper user and perform the work, e.g. delete the client.

Regards

Thomas.

[Former Member · Accepted solution]

Good man.

I will try that first thing in the morning and hopefully it will work.

Many thanks for replying

Cheers

Andy

[Former Member · Accepted solution]

Yep just done that and it works a treat.

Again many thanks Thomas

[Reagan]

You can delete a client from the OS level using R3trans

13391 - CC-INFO: Deleting/resetting a client

[Former Member]

Many Thanks Regan that is also useful to know.

Cheers

[hemanth2]

Just one point here. Use R3Trans when there is no other way cause we have seen several issues with this process.

I am not sure whether this is supported, but I will check:

R3trans and Clients - Technical Operations Manual for mySAP Technology - SAP Library

Kind regards,
Hemanth

SAP AGS