topic Re: What's the function of t-code SE14? in Application Development and Automation Discussions

What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 07:31:07 GMT

Hello, experts! I'm new to SAP and I want to know the function of t-code SE14, especially for the button 'Activate and adjust database'.

Appreciate for your help!

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 07:35:28 GMT

Its useful when you have changed data type of some field in existing table and that table have some entry already. so to adjust data of that table according to new datatype we use this 'Activate and adjust database'.

Let a field with data type char2 now you have changed it by numc2. so i will give a error, something like Structure change at field level (convert table table_name)..

So for activate table and keeping the existing record we use this thing.

Re: What's the function of t-code SE14?

FredericGirod — Wed, 09 Oct 2013 07:35:56 GMT

Hi Shelwin,

what did you mean with function ?

(it's a dangerous transaction ! don't use it if you have several client on the same system)

regards

Fred

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 07:37:28 GMT

HI shelwin,,

Go through below link once you will get detail info reagrding tcode SE14 .

<link farm removed>

Regards,
Giri

Message was edited by: Suhas Saha

Re: What's the function of t-code SE14?

hemanth_kumar21 — Wed, 09 Oct 2013 07:38:19 GMT

Hi Shelwin,

Please go through below inforamtion:

Activate and adjust database: The revised version of the table is activated in the database table is adjusted to this modified table definition. You can select Keep data or Delete data. For Delete data, the table is deleted in the database and created again with the new definition. Data in the table is lost. With Keep data, there is an attempt to perform an adjustment with an ALTER TABLE. If this is not possible, a table conversion is triggered.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0f0446011d189700000e8322d00/content.htm

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 07:40:51 GMT

This message was moderated.

Re: What's the function of t-code SE14?

former_member219162 — Wed, 09 Oct 2013 07:43:39 GMT

Hi Shelwin,

You could use SE14 for database utility OR you could go to SE11, give your database table name, go inside SE11 and then Utility->Database Object->Database Utility.

This is used for the following reasons;

1) When you have changed some database definition. For example you have created a Database table with 4 fields and maintained data. But later on you decide you need to add some more fields. In that case, you add the fields in data base and then "Activate and adjust" with 'Save data"

2) Similarly, you want to delete the data after adjustment of database, then "Activate and adjust" and "delete data".

This button is typically use to adjust database, Table space in the database layer.

So, ideally we use this button, whenever there is a change in database table definition.

Hope this helps you.

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 07:44:32 GMT

This message was moderated.

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 08:12:20 GMT

Thank you, Fred!

Here my using word 'function' is to mean what this t-code can do. Could you tell me why 'don't use it if you have several client on the same system'?

Re: What's the function of t-code SE14?

SujeetMishra — Wed, 09 Oct 2013 08:16:43 GMT

Shelwin..

You posted one new thread with same doubt you were having in your previous thread..

About SE14:

"Usually when you change something and active the table then if there is some problem a pop-up will show all the all the errors and messages and at the bottom it will ask you to Run SE14 and adjust the table.
But care must be taken will doing this adjustment since there are two radio buttons in SE14
1. Save Data
2. Delete Data
If you just want to adjust the table then radio button 'Save Data' must be used.
Secondly if you want to delete data from the table use must use the appropriate options in SE14."

Regards,

Sujeet

Re: What's the function of t-code SE14?

FredericGirod — Wed, 09 Oct 2013 08:35:28 GMT

You have to use this transaction when you modify a structure of a table and you have already data inside. Select the radio button "Save data".

If you select the radio button "delete data", that will delete the data of the table in ALL the client !! (it's like a DROP table CREATE table)

I see several times, people doing mistake with this transaction.

regards

Fred

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 08:58:34 GMT

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System. The database utility allows you to
edit (create, delete and adjust to changes to their definition in the ABAP
Dictionary) database objects derived from objects of the ABAP Dictionary.

You can call the
database utility from the initial screen of the ABAP Dictionary with Utilities
-> Database utility (Transaction SE14). The initial screen for the
database utility appears.

SE14 is used to
activate and adjust the database table and delete database table. Tcode SE14 is
used to maintain the changes to the custom table that you had created. When you
do some changes in database table, like adding additional fields or removing
fields for a table in se11, then you need to adjust using SE14.

Assume : You are
creating a ztable with 5 fields and activate and maintan the table with some
new entries in it. Now if you got a requirement to add a new filed or remove
the existing field from the ztable then you will use the option called Database
Utility.
For this we go to SE14 and there is one button 'Activate and Adjust Table'. On
clicking this Button the changes of key fields are reflected successfully.

This option will adjust
the new structure that you had changed/added into the database so that it can
place the data in the appropriate fields.

Normally when you
change something and activate the table then if there is some problem a pop-up
will show all the errors and messages and at the bottom it will ask you to Run
SE14 and adjust the table. For doing the adjustment there are two radio buttons
in SE14.

Save Data : If you just want to adjust the table then radio button 'Save Data' must be
used.

Delete Data : If you want to delete data from the table use must use the Delete Data
options in SE14.

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 09:04:56 GMT

Se14

Help-->Application Help

Read.

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 09:42:43 GMT

A digression! Why can't I mark answers?

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 10:25:49 GMT

Hi Shelwin,

Please go threw the links -

http://scn.sap.com/thread/1598942

http://www.saptechies.org/transaction-code-se-14/

https://scn.sap.com/thread/1247146

Hope this helps.

Regards,

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 10:32:48 GMT

I think you didn't mark your thread as a question. When ever you are creating new thread, it will ask you for Mark your thread as a Question otherwise it will be consider as a discussion.

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 11:19:39 GMT

Oops...Thanks, Chandra!

Re: What's the function of t-code SE14?

SuhaSaha — Wed, 09 Oct 2013 11:25:45 GMT

Shelwin Wei wrote:
A digression! Why can't I mark answers?

Because of the basic nature of the question, it has been marked as a discussion & not a question.

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 11:37:32 GMT

Hi ,

Yes its cross client transaction.So its delete data from all clients!!!!

Regards
Ashok P

Re: What's the function of t-code SE14?

Former Member — Wed, 09 Oct 2013 11:58:06 GMT

Hello Shelwin ,

SE14 is used activate adjust and delete database table. It is used to maintain changes to custom table that u have created. The transaction is need to be maintained whenever u do any changes in the database table that u have created.