Skip to Content

Usage of SE14

Hello experts,

could you please give me some examples of usage the t-code SE14?

What is the difference between Runtime Object and Database Object in this transaction?

Thanks,

Radek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 04, 2010 at 04:37 PM

    Hi,

    SE14 is use to Convert Data Dictionary tables on Database Level, this transaction is used to activate and adjust the database table and delete database table.

    When you do some changes in database table, like added additional fields or removed fields for a table in se11, then you need to adjust using SE14.

    Analysis option is available for database views using: Extras->Database object->Check or Display and Extras->Runtime object-> Check or Display the definitions of the view in the database in runtime object and SE11 can be checked with one another or checked.

    There is a user-friendly option for tables to compare definitions in the database, in the runtime object and in the Dictionary maintenance with one another. These these analysis functions using Extras -> Database object -> Check or Display and Extras -> Runtime object -> Check or Display. In this way, the differences that have been found (Check) or the definitions themselves (Display) can be displayed.

    Regards,

    Moqeeth.

    Add comment
    10|10000 characters needed characters exceeded

    • deletion and update of records is not in the sense you understand .se14 have the ability to delete all the records in a table ( that is drop the table) and adjust the records which is applicable when you add a new field or change a field's type .

      So se14 is a transaction which is used by basis consultants whereas table maintenance (sm30) is a transaction which is used by end-users and work-analysts etc.

  • avatar image
    Former Member
    Feb 04, 2010 at 02:11 PM

    T code SE14 is used to delete the table entries and used to adjust the databased table when we try to add fields to the existing table

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2010 at 02:35 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2010 at 03:41 PM

    After you change the table structure in SE11, changes will not updated at database level, to do that you need to use SE14 so that both DD and DB will be in synch.

    Add comment
    10|10000 characters needed characters exceeded