Skip to Content
avatar image
Former Member

Deleting a Client Scc5

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 20, 2007 at 11:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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*...

  • Nov 20, 2007 at 09:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded