SAP Virtual/Onsite Trainings

Document Categories:

What's New?

Contribute?

Sample Specs

What's Hot?

Web Dynpro for ABAP Tutorials 


Join the Mailing List
Enter name and email address below:
Name:
Email:
Subscribe  Unsubscribe 

Database Utility

By Sailaja Tadikonda

Introduction:

The database utility is a tool to provide the interface between the ABAP Dictionary and the underlying database management system (DBMS).  

Uses:

a)     Convert Data (I.e. change field lengths  and data types etc)

b)    Activate Objects

c)     Create/Delete/Change of tables and indexes

Approach:

Go to Transaction SE14

The Initial screen of database utility is displayed. Enter Name of either table/view/Match code/Pool/Cluster tables

I given table name as “ZDATA_UTL”

Choose Edit button or Enter Key.

Next screen will be displayed as below.

Indexes: It will display the list of indexes that are created for this table

Processing Type:

The DB Utility can be run either online or in the background.

A)    Direct:  the create/delete/modify operations of the object will be performed in foreground.

B)    Background:  the create/delete/modify operations of the object will be performed in background

C)    Enter for Mass processing:

If you want to modify large no of objects, choose this option.

If you run DB Utility, a log file gets created which contains information on whether or not the conversion was successful and the point of failure during the conversion if it was not successful.

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image