topic Re: database utility in Application Development and Automation Discussions

database utility

Former Member — Sat, 05 Jul 2008 15:16:55 GMT

hi,

what is Database utility?

when we use this.

Re: database utility

bpawanchand — Sat, 05 Jul 2008 17:14:13 GMT

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.

Check Out this

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21f0e3446011d189700000e8322d00/content.htm

Regards

Pavan

Re: database utility

Former Member — Sun, 06 Jul 2008 06:11:16 GMT

DB Utility to adjust ur DB table, in case you modify your table to include new fields, for ex.

Check txn SE14 for more info on this..

Rgds,

Raghu.

Re: database utility

Former Member — Sun, 06 Jul 2008 09:07:46 GMT

This message was moderated.

Re: database utility

Former Member — Sun, 06 Jul 2008 10:28:16 GMT

Hi Devi,

For information regarding what actually the Database Utility check the following link.

http://help.sap.com/saphelp_nw04/helpdata/EN/cf/21f0e3446011d189700000e8322d00/content.htm

Check below the simple use of Database UTILITY...



When you change a database table, adding or deleting fields for 
example, we always have to use the database utility to have DDL 
commands like ALTER TABLE executed on the underlying SAP 
database. This works well in a development environment, but 
normally it is (and has to be) prohibited for a normal developer in 
other systems. Things can get even more complex if we  do tests 
of, say, a new index in some u201Cotheru201D system and want to drop and 
recreate an index during tests. Looks for a help from guys guarding 
the system? Forget the tests then. But I always remember that 
many u201Cforbiddenu201D tasks can be done by running some standard 
report. There is always a great chance that all you need is an 
authorization for SE38 and the report you use doesnu2019t do any further
 checks.

This was exactly the case with the database utility. The screen that
 comes in SE14 is actually nothing else than a wrapper program 
that asks you for parameters (what has to be done) and then runs a
 report to do the job. If you request this to be done in background 
then of course you can see which program was run and what were 
the parameters passed. The possible parameter values of this 
program can be simply learnt by looking at its ABAP code. That 
was what we do and this saves some hassles during testing in any 
landscape.

Hope this information would help you to know the use of DATABASE UTILITY..

Regards

Narin Nandivada.

Re: database utility

Former Member — Mon, 07 Jul 2008 09:17:34 GMT

Hello,

Please check this out:-

[http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21f0e3446011d189700000e8322d00/content.htm]

[http://help.sap.com/saphelp_nw04/helpdata/EN/cf/21f1c5446011d189700000e8322d00/content.htm]

[http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0f0446011d189700000e8322d00/content.htm]

Best of luck,

Bhumika

Re: database utility

Former Member — Mon, 07 Jul 2008 09:20:32 GMT

Hii!

Check out these links

http://sap-abapinfo.blogspot.com/2008/04/what-is-database-utility-in-sap.html

http://www.sapbrainsonline.com/FAQs/TECHNICAL/SAP_ABAP_DATADICTIONARY_FAQ.html

Regards

Abhijeet Kulshreshtha

Re: database utility

Former Member — Mon, 07 Jul 2008 09:39:23 GMT

This message was moderated.

Re: database utility

Former Member — Mon, 07 Jul 2008 09:41:57 GMT

hi devi,

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System.

refer to the link below;

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21f0e3446011d189700000e8322d00/content.htm

With luck,

Pritam.