Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Clear Z table

Former Member
0 Likes
949

Hello,

I have a Z table which is already in production and contains some data. But now i need to change the table and when i transport it to production i need all the existing records in the table to be deleted.

How can i do this?

Thank you

Nuno Silva

1 ACCEPTED SOLUTION
Read only

valter_oliveira
Active Contributor
0 Likes
850

Hi Nuno.

You have several options here. For example, after transporting the changes, you can delete table entries in tcode SE14. Insert table name, and then press button "Activate and adjust database" with radiobutton "Delete Data" marked.

Another way would be creating a program to delete all the records in the table.

Regards,

Valter Oliveira.

3 REPLIES 3
Read only

valter_oliveira
Active Contributor
0 Likes
851

Hi Nuno.

You have several options here. For example, after transporting the changes, you can delete table entries in tcode SE14. Insert table name, and then press button "Activate and adjust database" with radiobutton "Delete Data" marked.

Another way would be creating a program to delete all the records in the table.

Regards,

Valter Oliveira.

Read only

Former Member
0 Likes
850

any table maintenance for Ztable .?

Read only

Former Member
0 Likes
850

hi,

No need to delete in production when u transport the table again to production,the new table changes are affected and u ll not find entries in production.