topic Dynamic SQL in Application Development and Automation Discussions

Dynamic SQL

Former Member — Tue, 11 Mar 2008 04:57:32 GMT

Hi,

I am new to dynamic SQL. I want to know the concepts of Dynamic SQL. Can anyone explain me abt it in detail.

Please do the needful,

Regards,

Arunsri

Re: Dynamic SQL

Former Member — Tue, 11 Mar 2008 05:07:51 GMT

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=dynamic+sql&cat=sdn_all

Regards

Aditya

Re: Dynamic SQL

Former Member — Tue, 11 Mar 2008 05:08:50 GMT

try this link

http://help.sap.com/saphelp_nw04/helpdata/en/9d/05b8d660f77f4387d6d054d7655ecb/frameset.htm

regards

ramya

Re: Dynamic SQL

Former Member — Tue, 11 Mar 2008 05:09:34 GMT

Hi,


data:flds(30) value 'MATNR',
table(30) value 'MARA',
condition(90) value 'ERNAM = ''ABC'''.
data:value(30).
select single (flds) from (table) into value where (condition).
write:/ value.

for examples go through this link:

http://www.sap-img.com/abap/how-can-we-give-dynamic-table-name-in-select-statement.htm

rgds,

bharat.