updating database tables.

[Former Member]

hii,

i worked on it and got the selected data into internal table now could you tell me the exact code to update the datbase table with this data in this scenario : i have two fields in databse tabel one being primary key and against which every time i have to update second field from the value selected by user.

please tell me the exact code to update the database table from this internal table.

[Former Member]

Hi Vishdeep,

Supose u have got the data in internal table and u want to update those data into data dictionary use following syntax.

loop at itab into wa

modify ztable from wa.

endloop.

regards

PG

[Former Member]

hi PG,

No need to loop the table. check the statement

MODIFY <dbtab> [ CLIENT SPECIFIED ] FROM TABLE <itab>.

Yogesh N

[Former Member]

hi,

its abap coding only.

use insert, update or modify statement.

i.e

insert table ztable from itab.

but it is advisable do not use these statement directly,

You can create Perform on commit. and use FM in update task

Yogesh N

Edited by: Yogesh N on Aug 25, 2008 6:15 AM