Delete Customize Z table

[Former Member]

Hi,

We want to delete the following Z table from DEV to QA and PRD system. But there are records exist in the table at QA and PRD system. If we need first delete the records at QA and PRD system. Then delete the Z tables via Change Request from DEV to QA and PRD system.Pls advise.Thanks.

Tables:

ZV016

ZV017

ZDASHBWEEKLY

ZDASHBMONTHLY

ZV014

ZS912

ZS912_M

Best Regards

Park Han

[Former Member]

Dear Han,

You can delete the Z table directly eventhough it has records.

Once Ztable is moved to PROD, deleting that Ztable is not recommonded.

If u want to delete, then mannuvally u have to delete in QA and PROD with special permission.

Rgds,

Kiran

[Sandeep_Kumar]

You can directly delete the tables even though these tables have records and then move your transports .

The only worry here can be if these tables are used within some programs then these programs will end up in r untime errors.

[Former Member]

Hello Sandeep!

The customize tables and records are deleted in QA and PRD. We have another question. If the Oracle tablespace are released. If it is released, it can reuse by other objects(Table). If it can't reuse, Could you pls let us know how to reduce the tablespace? Pls advise.Thanks.

Best Regards

Park Han

Edited by: Han Park on Jul 31, 2009 4:57 AM

[Former Member]

Hi Han,

please close the post and your new query in a new post. As per SDN forum rules you cannot raise two questions in a single post.

Thanks&Regards,

Pavan.

[Former Member]

Hello,

If you actually plan to delete the table, than the content gets deleted automatically. But you'l have to delete the table manually.

No table, no entries..

[former_member555112]

Hi,

Incase you want to delete entries from the table then do it via SE14.

Before deleting the table from your system you need to remove it from all the program where you have used it.

Regards,

Ankur Parab

[former_member206439]

Hi

You can delete the table in Development system and transport the same request to QA and production it won't have any problem

if you want to delete the data first then do these steps

go to T-CODE se16n

give the tablename

give the command &sap_edit and enter u will get a message code activated

execute select the records which u want to delete and delete it with delete minus button in the tool

after this delete the table in development and store in a transport request

Thanks & Regards

Naresh

[Former Member]

Hi HAn PArk,

What i Feel is simply write a z Program in that

Use table : DD02L

with Delete syntax simply delete the entries by passing those reuire tables to be deleted in the select options:

Ur problem will get solved by running this program in all the three servers once.

OK

Hope it works,

warm Regards,

Raj S