topic Re: Scripts in ABAP in Application Development and Automation Discussions

Scripts in ABAP

Former Member — Fri, 29 Jan 2010 18:33:21 GMT

Hello gurus!

I have a question about scripts in ABAP. We have a program that requires a lot of queries to obtain info from oracle; we already have a functional version of it but we need to upgrade and this means we have to write a lot more of queries in ABAP. Is there a way to import a script to put in a variable an execute it in ABAP to avoid all this code writing?.

Regards IA

Re: Scripts in ABAP

MartinMaruskin — Fri, 29 Jan 2010 21:56:25 GMT

Hi Armando, what you mean by scripts? It is PL SQL scripts of DB? Or just SELECT statements that need to be executed in ABAP environment?

If it is 2nd case you can program SELECTs in ABAP dynamically. In this way you can dynamically create FROM value INTO value and WHERE conditions as well.

To see an example take a look into ABAP report: zbc402_demo_dyn_select

m./

Re: Scripts in ABAP

Former Member — Sat, 30 Jan 2010 14:16:34 GMT

You can create dynamic sql queries in abap.

Re: Scripts in ABAP

Former Member — Sun, 31 Jan 2010 20:03:47 GMT

Hi Armando,

if You want to use already programed Oracle SQL Queries in ABAP with no neccessity to recode them into Open SQL (SQL in ABAP), You can probably use [Native SQL|http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm]. This can be done using [EXEC SQL statement|http://help.sap.com/abapdocu_70/en/ABAPEXEC_CURSOR.htm].

Regards,

Adrian

Re: Scripts in ABAP

Former Member — Tue, 23 Feb 2010 09:50:21 GMT

Hi everyone,

As every1 know Medruck is a script for PO generation.The standard print program available for it is a subroutine pool. For our customization purposes we copy it to a zname and then use it. But being a subroutine pool you cannot execute it. So could you tell me how to debug that program? Also how to debug the script?