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
692

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
593

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
594

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
593

any table maintenance for Ztable .?

Read only

Former Member
0 Likes
593

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.