What's the function of t-code SE14?

[Former Member]

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!

[Former Member]

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. 

[FredericGirod]

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

[Former Member]

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'?

[FredericGirod]

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

[Former Member]

Hi ,

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

Regards
Ashok P

[Former Member]

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

[hemanth_kumar21]

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

[Former Member]

This message was moderated.

[former_member219162]

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.

[Former Member]

This message was moderated.

[SujeetMishra]

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

[Former Member]

  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.

[Former Member]

Se14

Help-->Application Help

Read.

[Former Member]

A digression! Why can't I mark answers?

[Former Member]

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.

[Former Member]

Oops...Thanks, Chandra!

[SuhaSaha]

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.

[Former Member]

Thanks, Suhas! I'll pay attention next time!

[Former Member]

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,

[Former Member]

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.

[Former Member]

hi shelwin,

If  you change something in database table 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.

then just go to SE14 enter the Table name in object name field and enter

the just click on Activate and Adjust database table.

your table is activated automatically with no errors.

Thanks,

Nilesh.