topic Re: Update database in Application Development and Automation Discussions

Update database

Former Member — Fri, 04 Jan 2008 11:45:41 GMT

Hi Abapers,

there are 20 fields in a ztable 'ymassn'. I have 4 fields in my internal table 'itab' from ztable. I have populated the internal table. now i want to update the ztable with one of my internal table field 'A'. How can i achieve this without effecting performance much.

I can do this using below logic. but if there are 100records in my internal table then it will db for 100 times.

loop at itab into wa.

update ymassn

set A = wa-A.

endloop.

please help me.

thanks.

Re: Update database

Former Member — Fri, 04 Jan 2008 11:56:46 GMT

UPDATE dbtab FROM TABLE itab

Try this

awrd points if useful

Bhupal

Re: Update database

Former Member — Fri, 04 Jan 2008 11:59:52 GMT

This will work only if the structure of db table and internal table is same.

Re: Update database

Former Member — Fri, 04 Jan 2008 12:00:07 GMT

the best thing is to declare ur internal table as Z table type and then use UPDATE ZTABLE FROM ITAB.

Re: Update database

Former Member — Fri, 04 Jan 2008 12:05:21 GMT

I dont require other fields.. in other cr, i have 100 fields in ztable. then how can i?

Re: Update database

Former Member — Fri, 04 Jan 2008 12:10:24 GMT

Get the data in ITAB1.

Declare an internal table ITAB2 as Z table type.

copy the data from ITAB1 to ITAB2.

UPDATE table from ITAB2.

This will avoid UPDATE inside a LOOP.

Re: Update database

Former Member — Fri, 04 Jan 2008 12:14:01 GMT

Hi Prem,

Then u can do one thing.

First Declare 2 itabs as type ur Ztable.

Assign the itab2 with the values selected from ZTable.

In First itab do the changes.

Modify the Second itab using first itab in which u have done changes.

Now update ztable using the second itab which is having the final data.

awrd points if useful

Bhupal