topic Re: Z-Table Deactivation at Database Table ? in Application Development and Automation Discussions

Z-Table Deactivation at Database Table ?

Former Member — Wed, 17 Sep 2014 10:35:21 GMT

Hi Experts,

Is there any way availabe to deactivate the Ztable at database level. Can we make a z-table inaccessible in Programs, FM's etc.

Eventhough we deactivate the Table in Data dictonery defination the Previous active version of table is accessible for all the application and they run successfully.This will not solve my purpose.

I wanted a way through which we will keep the Ztables in system but will make it in accessible for all the referring application. Is it possible?

Do we have any solution for this. Thanks for your help.

Regards,

Ravi Kasnale

Re: Z-Table Deactivation at Database Table ?

former_member202818 — Wed, 17 Sep 2014 10:41:57 GMT

Hi Ravi,

It may helpful...

Re: Z-Table Deactivation at Database Table ?

Former Member — Wed, 17 Sep 2014 10:55:51 GMT

Hi Ravi,

Why you want to keep the table in DB and not useful anymore in the system??

Better to delete the entries from the table. So that the table data can't be accessible.

BR,

Kiran

Re: Z-Table Deactivation at Database Table ?

Former Member — Wed, 17 Sep 2014 11:01:10 GMT

Hi Kiran,

Basically I would like to Identify the Ztables which are not in use. We wanted to deleted it.

My objective is to - Retain table and its content but the table will no longer be useful or cannot be used by programs/function modules/t.codes

The reason I am looking for something like this is to find a way to make Z-table inaccessible in to programs, function modules and t.codes in dev system and if there are no issues with those Z-tables, delete them 6 months later.

Let me know if this can be achived.

Re: Z-Table Deactivation at Database Table ?

Former Member — Wed, 17 Sep 2014 11:02:45 GMT

Hi Ravi,

Dont know whether it would serve the purpose.

But you could make the copy of the table, giving it a different name and delete the original table.

Basically you are renaming the table so the table still exists but it can no longer be accessed as the name has changed.

Re: Z-Table Deactivation at Database Table ?

Former Member — Wed, 17 Sep 2014 11:14:47 GMT

Hi Susmitha,

I do not want to have this approch since it will delete the table records as well.

Regards,

Ravi Kasnale

Re: Z-Table Deactivation at Database Table ?

former_member201275 — Wed, 17 Sep 2014 11:21:24 GMT

I would just leave the tables there as is. If they are not being used it won’t be consuming any resources. Have you done a where-used list? This should point you to the programs, functions, etc., where these tables are used. In which case you can then delete also all these objects as well if they aren’t being used?

Re: Z-Table Deactivation at Database Table ?

kiran_k8 — Wed, 17 Sep 2014 11:24:50 GMT

Ravi,

May be an authorisation concept at select query level based on table name is what you might be needing,if there is any.

K.Kiran

Re: Z-Table Deactivation at Database Table ?

RaymondGiuseppi — Wed, 17 Sep 2014 11:27:12 GMT

Why did you not just rename or change authorization for the table in the database manager ?

Regards,

Raymond

Re: Z-Table Deactivation at Database Table ?

sridinn — Wed, 17 Sep 2014 11:29:01 GMT

Hi Ravi,

Go to SE14 and Delete the DB table. which will delete the table on DB level.

Regards,

Srivijay