cancel
Showing results for 
Search instead for 
Did you mean: 

Table t000 deleted accidently in client 000

Former Member
0 Kudos

Hi,

i accidentally deleted table T000. now when i login its throughs  an error

Table T000 does not exist in the database with ID R/3.

Kindly advice.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

what to do if i dont have a latest  backup

former_member209924
Contributor
0 Kudos

What database are you using?  Copy the table from another SAP database or work with your DBA to create the table.

If you would like, I can provide a script to create this table.

Ravi

Former Member
0 Kudos

Thanks for the answer Ravi,

i am using SQL server 2008, i dont have a DBA. can you provide me the script

former_member209924
Contributor
0 Kudos

This will create the table but will not have any entries in the table for your client.  Once you create it, you need to update the table with your Client information.

----------------------------------------------------------------

Use this script on another database and see how T000 looks.

USE XXX

Go

select * from xxx.T000

---------------------------------------------------------------

------------------------------------------------------------------

Replace XXX and xxx with your DBSID.

USE [XXX]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [xxx].[T000](

    [MANDT] [nvarchar](3) NOT NULL,

    [MTEXT] [nvarchar](25) NOT NULL,

    [ORT01] [nvarchar](25) NOT NULL,

    [MWAER] [nvarchar](5) NOT NULL,

    [ADRNR] [nvarchar](10) NOT NULL,

    [CCCATEGORY] [nvarchar](1) NOT NULL,

    [CCCORACTIV] [nvarchar](1) NOT NULL,

    [CCNOCLIIND] [nvarchar](1) NOT NULL,

    [CCCOPYLOCK] [nvarchar](1) NOT NULL,

    [CCNOCASCAD] [nvarchar](1) NOT NULL,

    [CCSOFTLOCK] [nvarchar](1) NOT NULL,

    [CCORIGCONT] [nvarchar](1) NOT NULL,

    [CCIMAILDIS] [nvarchar](1) NOT NULL,

    [CCTEMPLOCK] [nvarchar](1) NOT NULL,

    [CHANGEUSER] [nvarchar](12) NOT NULL,

    [CHANGEDATE] [nvarchar](8) NOT NULL,

    [LOGSYS] [nvarchar](10) NOT NULL,

CONSTRAINT [T000~0] PRIMARY KEY CLUSTERED

(

    [MANDT] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

---------------------------

Good luck!!!

Ravi

JPReyes
Active Contributor
0 Kudos

Simple answer, restore from backup.

Regards

Juan