topic Re: SQL Script in ABAP in Application Development and Automation Discussions

SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 17:53:47 GMT

Hi Everyone,

I have sql script which gives certain output from the data base files, is it possible to execute this script in ABAP, I want to embed this sql script in ABAP and get the output into an internal table how is it possible.

Can anyone suggest me on this, it will be of great use to me.

Thanks,

Prashant.

Re: SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 17:59:58 GMT

SAP uses Open SQL for accessing data from any of the databases.

Incase you want to find more details. Also look for Open SQL or Use Native SQL language in ABAP to accomplish the job.

<b> Open SQL

http://help.sap.com/saphelp_46c/helpdata/en/c9/5472f9787f11d194c90000e8353423/frameset.htm

Native SQL

http://help.sap.com/saphelp_46c/helpdata/en/c9/5472f9787f11d194c90000e8353423/frameset.htm</b>;

Hope this will help.

Please reward suitable points.

Regards

- Atul

Re: SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 18:10:05 GMT

Look at the below thread, this may help you ..

reward the points if it helpful

Regards

Sudheer

Re: SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 18:12:30 GMT

Hi Atul,

Thanks for the links, but my sql script reads the data from the data dictionary views and tables. All the information which is related to database size, like the tablespace size from database segments, extent size etc.

Thanks,

Prashant.

Re: SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 18:16:40 GMT

I guess without any changes it will work.

Try writing the queries as it is in SAP ABAP Editor.

Incase, there are any issue, then use Native SQL.

Hope this will help.

Please reward suitable points.

Regards

- Atul

Re: SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 18:23:51 GMT

Hi,

My main intention in that script is to get the overall database size and tablespace size, how do I achieve this in ABAP.

The flow is in my selection screen program I have checkbox for database size, if the user checks this box, it has to display the entire database size in MB of KB.

I know that we can get this information through DB02, but my task is to get this information in a program and display it as a list.

Please suggest me with some ideas.

Thanks,

Prashant.

Re: SQL Script in ABAP

Former Member — Tue, 20 Feb 2007 18:27:26 GMT

Hi,

To check the table space we have a program .....

RSORAT01 - Check Table Space

RSORATC5 - Check Table Extent

http://www.saptechies.com/sap-table-space-daily-check-list/

same like you will find the Program name for entire database also.. i do not know about the program, but Basis people will definetly helpyou out in this one

Regards

Sudheer