How much time it will take for client deletion

[Former Member]

Hi All,

We have ECC 6.0 EHP4 system, where we created lot of clients in begining days. But we want to delete the unwanted clients, for that we have caluclated the client size using SPACE CHECK report. The client size comes around 80GB, we want to know how much it will take for deletion from SCC5(t-code)

Regards,

Pradeep J

[Former Member]

HI,

Deleting client at OS level using  R3trrans is faster as compared to deletion using SCC5.

To use R3trans you need to create ctl file., With proper commands .

We woul like to tell you that we have tried this successfully with almost 30% time saving.

Also deleting large table indivisually at DB level using table drop procedure will help to reduce time greatly.

EG.

Table : MSEG

CLIENT to be deleted 200 :

1. Create table yzmseg ( temp. table )

    create table yzmseg as select * from mseg where mandt != '200';

2. Drop original table

    drop table mseg;

3. Rename temp table to Original

    alter table yzmseg rename to mseg

* Check the for the syntax

Recreate index on table MSEG

Thanks,

Rushikesh

[former_member128291]

Dear Pradeep,

Calculating the exact runtime for Client Deletion from SCC5 would not be possible. However, you can refer the following SAP Notes which can help you out in reducing the deletion runtime considerably:

857973 - Deleting clients efficiently using Oracle

806554 - FAQ: I/O-intensive database operations

Thanks & Regards,

Abhishek

[Former Member]

Dear Pradeep

There is no fixed amount of time taken by the system to delete the client. It depends upon the amount data stored, number of users created, extent of customization done etc. Which of the transactions (SCC4 or SCC5) you are considering to run to delete the client?

SCC4: After deleting the client using SCC4 transaction you can no longer log on to the client or update it using change requests. The deletion process, however, does not eliminate the data belong to the client. This means the client-dependent data remains in your SAP System, occupying space in the database. It allows you to temporarily lock the client. It preserves the data for the client but prevents users from logging on to the client or accessing the data belonging to the client. If at later stage you want to restore the client and allow logon, you need to recreate the client entry using client maintenance.

SCC5: To eliminate an SAP client entirely, that is, to delete both the client and the client-dependent data.

The amount of time required for the deletion of a client can be reduced by performing the deletion using parallel processes.

I hope this information helps you.

Tapan

[Former Member]

Hi Pradeep,

I think there is no way you can calculate the time but you can refer the following note which help you in

deletion:

857973  Deleting clients efficiently using Oracle

Thanks and Regards,

Vipin