Pages

▼

Sunday, 5 July 2015

What is the use of database utility in SAP?

This article answers following queries:

  • How to remove entries from the tables in SAP?
  • What is the use of SE14 transaction in SAP?
  • What is the use of database utility in SAP?
  • How to invoke database utility in SAP?


------------------------------------------------------------------------

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System. This tools allows you to edit database objects derived from objects of the ABAP dictionary.

Using database utility, we can create, delete and adjust to changes to database objects definition in the ABAP dictionary.

SE14 transaction is used for invoking database utility.

As part of post system refresh activities, we need to remove entries from specific tables (mentioned below), activate and adjust the database.

Table List

ALCONSEG
ALSYSTEMS
DBSNP
MONI
OSMON
PAHI
SDBAD
SDBAH
SDBAP
SDBAR
TPFET
TPFHT
TLOCK
SWNCMONI
SAPWLSERV
SWNCMONIINDEX

Process for removing entries, activating and adjusting the database is mentioned below.

Go to transaction SE14. It will result in below screen.



Please provide table name in the object name text box and select “Tables” radio button and click on edit as shown above. It will result in below screen.








































In the above screen, make sure Processing type is selected as “Direct” and select “Delete data” radio button and click on “Activate and adjust database” button (as shown above).




The above message will appear at the bottom of the screen indicating success of the transaction.

In the above example, I have documented the process to be followed for deleting entries of ALCONSEG table. However, as part of post system refresh activities, this process to be carried out for each of the above mentioned tables.



at

6 comments:

  1. Anonymous10 July 2015 at 12:04

    Hi Sir,

    Are we deleting the entries because after system refresh, the data in these tables in the target system would've been replaced by the ones in the source system?

    We need to carry out this process in the target system right? I just wanted to know the reason behind doing this.


    Thanks,

    Aveek

    ReplyDelete
    Replies
    1. DurgaPrasad10 July 2015 at 13:03

      Hi Aveek,

      Yes, we need to delete these entries of target system because these tables contain details like monitoring information etc of source system. As we no longer need them, we will delete.

      One rule, never touch any source system entries as part of system refresh. Always, we delete/modify target system details.

      Delete
  2. Unknown24 November 2015 at 18:17

    Hi sir what is the effect of solution manger and i thought it was like RFC is this correct or any other functions by solution manager.

    ReplyDelete
  3. Unknown12 December 2015 at 09:59

    Hello there,

    This is amazing information which is helpful to most out there.
    I was wondering after going through this Article like how will we know that these are the tables that we have to remove entries from. What is the process that made you get this table list, an explanation on this will be greatly appreciated

    Thank you.

    ReplyDelete
  4. Unknown31 March 2016 at 12:52

    This comment has been removed by a blog administrator.

    ReplyDelete
  5. Anonymous14 September 2016 at 20:46

    Very Usefull Info Thankyou

    ReplyDelete

Please provide your valuable feedback: