topic saving data to database table using dynamic sql in Application Development and Automation Discussions

saving data to database table using dynamic sql

former_member232092 — Fri, 26 Nov 2010 07:23:01 GMT

hi all,

Is there a way to modify database table dynamically from work area using dynamic sql.

regards

ramesh

Moderator message: please search for available information/documentation before asking.

Edited by: Thomas Zloch on Nov 26, 2010 1:31 PM

Former Member — Fri, 26 Nov 2010 10:32:37 GMT

tables: mara.

data: tablename type tabname,

fname type fieldname,

fieldnames type fieldname occurs 0.

field-symbols : <fs_tableline> type any,

<fs_fieldval> type any.

initialization.

tablename = 'MARA'.

assign (tablename) to <fs_tableline> .

fname = 'MATNR'.

append fname to fieldnames.

fname = 'MTART'.

append fname to fieldnames.

select (fieldnames)

from (tablename)

up to 20 rows

into corresponding fields of <fs_tableline>.

loop at fieldnames into fname.

assign component fname of structure <fs_tableline> to <fs_fieldval>.

write : <fs_fieldval>.

endloop.

new-line.

endselect.

Edited by: Rahul Babukuttan on Nov 26, 2010 11:33 AM

kesavadas_thekkillath — Fri, 26 Nov 2010 10:34:55 GMT

Its possible . Try it once.

Former Member — Fri, 26 Nov 2010 11:34:41 GMT

I do hope it's not on standard SAP tables.

If it is: looking forward to your next threads...

kesavadas_thekkillath — Fri, 26 Nov 2010 11:40:04 GMT

Not standard ones .... Z and Y