topic Re: Need to pass database Table Name dynamically in Modify command in Application Development and Automation Discussions

Need to pass database Table Name dynamically in Modify command

Former Member — Tue, 27 Jul 2010 06:36:39 GMT

Hi,

I am having about 50 database tables. I want to update those tables according to certain criteria. For that I need to give the database table name dynamically. Because if I want to give statically means i need to give 50 modify commands. Please sugeest me. Thanks in advance.

Re: Need to pass database Table Name dynamically in Modify command

andreas_mann3 — Tue, 27 Jul 2010 07:03:25 GMT

try this:

1) put your tablenames into itab

2) loop itab and

create data dyn_tab type standard table of (itab-tabn).

assign dyn_tab->* to <dyn_tab>.

modify (itab-TABN) from <dyn_tab>.

hope that helps

Andreas

Re: Need to pass database Table Name dynamically in Modify command

Former Member — Tue, 27 Jul 2010 07:36:57 GMT

Hi,

Thank you. It is working.