topic Re: Drop a Ztable in Application Development and Automation Discussions

Drop a Ztable

Former Member — Thu, 12 Jan 2006 20:10:23 GMT

what is meant by dropping a Ztable?

First i had created a table with some fields and then activated it,

then the next day i had changed one key field to non-key field and tried to activate,it displayed errors.

then my manager had dropped the table and asked to activate , this time activation was successful.

Re: Drop a Ztable

RichHeilman — Thu, 12 Jan 2006 20:13:33 GMT

I'm not really sure about "Dropping", but to do these types of adjustments, you need to run SE14, and do an "Adjust and Activate".

REgards,

Rich Heilman

Re: Drop a Ztable

juan_suros — Thu, 12 Jan 2006 20:16:49 GMT

I think this means that the R/3 application server told the underlying database server to delete "ZTable" from its data store, then told it to create a new table with the same name but using the changed field definitions.

If "ZTable" already had contents at the time of the change, some sort of SQL UPDATE command might have been sent instead of SQL DELETE/DROP and SQL CREATE commands.

These SQL commands are not always sent from R/3 to the database immediately upon saving changes in SE11. The drop/activate cycle gives you control over when these commands are sent.

Re: Drop a Ztable

Former Member — Thu, 12 Jan 2006 20:17:51 GMT

Hi,

go to T/Code se14: Edit: "Activate and adjust database:" .

this wil drop the data base link with contents and adjuct the table.

Lanka

Re: Drop a Ztable

Former Member — Thu, 12 Jan 2006 20:23:06 GMT

You can always do the same from SE11 also..

click Utilities-->Database Utilities.It takes you to the same thing.

This is just for your information.