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.
