topic Re: modifying a database table from a dynamic internal table of same structure in Application Development and Automation Discussions

modifying a database table from a dynamic internal table of same structure

Former Member — Tue, 15 May 2007 14:29:36 GMT

hi experts,

i have created a dynamic internal table and got some values in it.

i want to modity the database table from this dynamic internal table which is of the same structure as the database table.

i am using the following syntax for which i am getting a dump.

please let me know how to fix this problem.

modify db_tablename from table <dynamic_int_table>.

also can we do something like this?

Re: modifying a database table from a dynamic internal table of same structure

Former Member — Tue, 15 May 2007 15:06:34 GMT

Hi there. I haven't found any examples where you can modify a database table directly from a dynamic table. But I think you could try defining another internal table, moving the dynamic values to that table, and then using that to modify the database table. So if the second internal table has the same structure as the dynamic table and the database table:

itab = <dynamic_itab>.

MODIFY db_table FROM TABLE itab.

I hope this helps.

- April King

Re: modifying a database table from a dynamic internal table of same structure

Former Member — Tue, 15 May 2007 15:17:10 GMT

HI.

<b> Your question : i want to modity the database table from this dynamic internal table which is of the same structure as the database table.</b>

Then, why is dynamic internal table required?

Regards

Sailaja.

Re: modifying a database table from a dynamic internal table of same structure

Former Member — Tue, 15 May 2007 15:22:27 GMT

i am sorry but the problem still remains. i cant define another internal table and then move the data from the dynamic internal table and then modify the data base table. the reason here is, i get the database table name at runtime only.

its more like

modify (db_table) from table <dyn_table>.

now what i have done here is after getting the data base table name at runtime i have created a dynamic table of this runtime data base table structure, and then after processing few records i want to modify the database table (which also i got at runtime) from this dynamic internal table.

now creating an internal table of structure which is known at runtime is the same as dynamic internal table.

please let me know in case of more clarifications required.

thanks in advance.

cheers

AKS

Re: modifying a database table from a dynamic internal table of same structure

Former Member — Tue, 15 May 2007 15:38:40 GMT

the database table name itself is known only at runtime. my requirement is like i need to modify one field of some 5-6 database tables. now i have two options:

1. create 5-6 internal tables of respective database structure types, fetch the records, modify the field, and then modify the database table from the respective internal tables.

2. i want to maintain a database table having only one field as tabname which will hold the names of all the database tables for which that field is to be modified. in my program i do a select query on this table and get all the database table names into an internal table for which that field should be modified.

i then loop at that this itnernal table containing the names of the database tables for which that field needs to be modified.

for every record (which is nothing but the name of a database table) i create a dynamic internal table of this database table type, then fetch the data into this dynamic internal table, modify the field, and now i need to modify the database table from this dynamic internal table.

i am using dynamic internal table because i dont want to code specifically for all the tables, this logic is a generalized one.

please let me know if any further information required.

thanks in advance.

Cheers,

AKS

Re: modifying a database table from a dynamic internal table of same structure

Former Member — Mon, 15 Oct 2007 15:16:17 GMT

Hi Buddy,

Any luck???

I am having the same problem..can u assit me?

Regards,

Raghu