cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting a Client Scc5

Former Member
0 Kudos

Dear all,

I need to delete a client (scc5), but i have no login credetials to tat client or even OS leve access..Is tere any way to do it frm other clent without resetting sap* of that cleint, means any report that can be run in other clients to reset the pwd or some thing like that

Regards

Umesh K

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Umesh,

Reseting sap* by deleting the entry in the table is not a clean solution.

The proper way to delete a SAP client is to log into the client you wish to delete (double check it is really the client you want to delete), then call transaction SCC5 and delete client (check "on" the "Delete Entry from T000" checkbox to also remove the client from the list of clients in transaction SCC4)

you can monitor with transaction SCC3

Please note that you will recover database space after Reorganizing the database.

However, if you do not have access to a client you wish to delete (avoid this on a regulated system or on QA, PRD systems), you can delete the client at the OS level with the tp command.

As an example, to delete client 100, you have to create a command file "delete100" with the following entries:

<i>Clientremove

Client = 100

Select * </i>

Place the command file in the /usr/sap/trans/bin directory

$ cd /usr/sap/trans/bin

$ R3trans –w <log file name> -u 1 <command file name >

in this case: $ R3trans -w delete100.log -u 1 delete100

To monitor, run in a different telnet session: $ tail -f delete100

This is also documented in SAP note 13391

Let me know if you need more details.

Best regards

Frank Markarian

f.markarian@sap.com

SAP America

Former Member
0 Kudos

Dear all,

thanks for the suggestions, i have no login credetials in OS level also because the servers are in datacenter..is ther a way to do this frm SAP level...

regards

Umesh K

former_member204746
Active Contributor
0 Kudos

you can do this through an ABAP program if you know the SAP* password from another client:

1. access a client you know a password or change it

2. Tcode SE30

3. Open tips and tricks

4. select any tip

press the "open Code" icon

Change the code to

Code:

Tables: USR02.

Select * from usr02 where bname = 'SAP*'.

usr02-mandt = '000'.

Modify usr02 client specified.

return one screen and execute the tip and trick

THe password and user settings are now the same as the client you are logged on to.

Former Member
0 Kudos

Hello Frank

>after Reorganizing the database.

After deletion of client using scc5, how can I reorganize the database?.

Can you please let me know the step by step process to reorganize the database.

former_member204746
Active Contributor
0 Kudos

Sahad, SAP note 646681 will help you.

markus_doehr2
Active Contributor
0 Kudos

You need to logon to the client to delete it.

If you have abap permissions you could create a report that would delete SAP* from the other client.

--

Markus

former_member204746
Active Contributor
0 Kudos

reset SAP, then login with SAP and run SCC5.

I do not see why resetting SAP* is an issue... because you will delete that client anyway deleting everything including SAP*...