Skip to Content
avatar image
Former Member

Client Deletion

Hi Gurus ,

I have one client (340) which is not used for a long time ,

I want to delete this client . I have the following queries.

1.) We have never loggin to this client or we have forgotten the user name and password. We also do not know the default SAP* and DDIC password.

2.) This client is on the same servers on which our production client (diffrent client no.)resides.Hence is there any connection between there client . What are the checks to be carried out before deletion of the 340 cleint . Will the production cleint has any effect by the deletion of 340 client.

3.) What is the process of deleting the client.

I have never done any client related activity , can your provided any documentation for the same.

Regards

Anthony

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 05:16 AM

    Hello Anthony ,

    To retrieve the default SAP* Password , delete user SAP* from client 340 using sql query :

    DELETE FROM SAPSR3.USR02 WHERE MANDT='<CLIENT>'

    AND BNAME='SAP*' ;

    After successfully execution of query login into client 340 using user SAP* with password PASS .

    2.) This client is on the same servers on which our production client (different client no.)resides.Hence is there any connection between there client . What are the checks to be carried out before deletion of the 340 cleint . Will the production cleint has any effect by the deletion of 340 client.

    Logically there is no connection with client 340 ( Still confirm with Functional / ABAP consultant if they have any dependency on 340 .

    Yes it will degrade the performance of system while deleting the client -> Schedule this activity weekend or night .

    3 ) To delete use Tcode : SCC5 in target client (340).

    Regards ,

    Santosh Karadkar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      No need to start the client deletion again. just go to SCC4 go to the change mode and then delete the entry for client 340. Your jobs done.

      -Madhu

  • avatar image
    Former Member
    Aug 22, 2007 at 05:16 AM

    Hi Anthony,

    we ll take your doubts one by one.

    1) to log into client, you will have to go at database level and delete SAP* user from <DB_SCHEMA>.USR02 table for client 340.

    Please make sure you delete SAP* from client 340.

    Then after you will be able to log into client with SAP* and "pass" password.

    2)There won't be any problem with production client if you will delete the client 340.

    Because it will delete client -specific data only.

    3) The procedure to delete client.

    go to SCC5-> Enter your client number (here 340)

    check on delete from T000.

    Execute it as "Delete as background"

    It will take some time.

    Regards,

    Payal Patel

    Add comment
    10|10000 characters needed characters exceeded