No database table exists for table

[former_member125931]

HI All,

We created a Ztable and used in two of reports these reports woking fine in PRD,few days back we assigned authorization group and functional group to these table now this table throwing eeror in QAS as well as PRD like No database table exists for table ZXXX,client dont want the data in this table so we deleted this table and created with same name to QAS still same error we are unbale to findout the problem.pls any on help me out..

[Former Member]

Hi Sree,

Did you transport the request to QAS and PRD on which you have deleted the ZTABLE.

You need to transport it to QAS and PRD.

Thanks,

Chidanand

[Former Member]

Hi,

Where r u getting this error?

Are u sure that this deleted table is not used anywhere?

Rhea.

[matt]

How did you delete the table and recreate it?

Go into SE14, and recreate the table.

matt

[former_member156446]

Hi Sree

As an when you make any small change to Ztable you need to adjust the database table.... which will trigger a sequence of step in back end SQL or Oracle.

se11 > ztable >utilities> database utilities> activate and adjust

[former_member125931]

Thanks alot I resolved my self.

[former_member273995]

I am getting the same error, please let me know how you resolved it?

[anil_neegineni]

Hi Srinivas,

I am also facing similar kind of issue, can you please let me know your approach towards resolving the issue without deleting the existing data from the table.

Thanks in advance.

Best Regards,

Anil Neegineni