topic Re: help with modify table. in Application Development and Automation Discussions

help with modify table.

Former Member — Mon, 27 Nov 2006 05:34:03 GMT

hi all,

i have a Table control (TC) and internal table (it) so when i modify the TC in a dynpro and i put save the code is:

loop at it_zhola.

move-corresponding it_zhola to zhola.

modify zhola.

endloop.

when this code is execute in the table are 3 fiels with 0 in the date field so insert 3 new rows. how can i insert this modification in the transparent table?

Re: help with modify table.

Former Member — Mon, 27 Nov 2006 05:35:13 GMT

You can use the

UPDATE <table>

SET <field> = <value

where <cond>

Re: help with modify table.

jayanthi_jayaraman — Mon, 27 Nov 2006 05:35:52 GMT

Hi,

Check this for sample code.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/abap/abap-code-samples/table%20control%20in%20abap.pdf

Re: help with modify table.

Former Member — Mon, 27 Nov 2006 05:40:48 GMT

loop at it_zhola.

update zhola set f1 = it_zhola-f1...

endloop.

commitwork.

please make the above mentioned changes.

Unless you commit work your data will not be updated in Database

BR,

Ravi

Re: help with modify table.

Former Member — Mon, 27 Nov 2006 05:41:54 GMT

Hi ,

you can use this update statement

UPDATE <databasetable>

SET <field> = <value

where ><cond>

loop at it_zhola to wa_zhola.

modify zhola(database table) from wa_zhola.

endloop.

reward pts if helpful.

Rgds,

Ajith