Client deleted...

[former_member327104]

Hi all

our company client 001 and 000 is deleted accidently , plz help me to recovery those . we guys r fail to login ,sap* and other administrator not login.Table T000 not shows client 000 or 001.

Thanks

RitZ.

[former_member190272 · Accepted solution]

Hi

if you are login client 000 you create a new client SCC4 and enter the number client new created client 001and save this .simply you add client in table T000.The entry was deleted in this table. It will be working good.Now you may be able to login in this client.

Thanks

Pankaj Kumar

[former_member327104]

Hi

Pankaj your solution is good for me its working fine .I have only add the client 001 and 000 in table T000.then login possible for all usrs

Thanks

Ritz

[Former Member]

mean you have not deleted the physical clients 001 and 000, you have just deleted the entries from your SCC4. You should always clearly tell the things what you have done if you want the answers form experts or else it will be in loop.

Cheers,

-Sunil

[Former Member]

Hi,

i think only solution you have is to restoe your backup( instance and the database).

regards.

[former_member327104]

Hi

I was login in this client when this delete.so my logon its worked fine but when another user is login in this its show 001 is not in system.and Client table T000 not show the client 000 and 001.i am also login in client 000 via user DDIC.But when i create new client and define source client 000 the system give message 000 is not in system.

Plz give me some idea!

Thanks

Ritz

[Former Member]

Hello Ritesh,

Since the entry is missing in table T000 the clients are deleted. Also since you were already logged in while deletion took place you will not face any affects unless you try to login again into client 000 and 001.

Also the erorr "000 is not in system" is self explanatory since source client 000 has been deleted already.

You need to restore the last backup which was taken when 000 and 001 were available.

Also in case you already have a production/development client in place <b>donot</b> create client 000/001 and do client copy from that production/development.

Regards.

Ruchit.

[Former Member]

If Client table T000 not show the client 000 and 001.then there is no way you to login client 000 via user DDIC/sap*. if there is no client called 000 the how you are going to define your source client as 000.

The only way is to recover your deleted clients is to restore from your latest backup. or if this is a test system then do a system copy fom your production systems.

Cheers,

-Sunil

[Former Member]

Hi Ritesh,

Also check the OSS note 31496. it gives hints that recovery may be possible afterall though I never have had any such experience.

Regards.

Ruchit.

Message was edited by:

Ruchit Khushu

[Former Member]

Hi Ritesh,

You definately need to restore your backup. Also how did the clients got deleted.

If it was done using SCC5, then full restoration is required, i mean the database also.

If you have done in scc4 then simply try creating one lient with the name 000 and 001. However the client dependent data wouls have been lost.

Anyways resotoration shuold help.

do reward if information is helpful to you.

[Former Member]

Hello Ritesh,

You need to restore backup in order to get the clients back. No other option is suitable in my opinion.

Regards.

Ruchit.