topic Re: update the database table in Application Development and Automation Discussions

update the database table

Former Member — Sat, 23 Feb 2008 09:56:19 GMT

how can i update the database table from the internal table..

Cheers,

Reddy.

Re: update the database table

Former Member — Sat, 23 Feb 2008 09:57:31 GMT

for updating the records in ITAB we can use the MODIFY or UPDATE keyword .

Cheers,

Rakesh.

Re: update the database table

Former Member — Sat, 23 Feb 2008 10:28:07 GMT

Hi Haresha,

You can update a database table using Modify or update statement.

Modify: It inserts one or several lines specified in source in target or overwrites the existing lines.

MODIFY target FROM source.

Eg., modify z_employee from table it_employee[].

Where z_employee is the database (custom) table & it_employee is the internal table.

Update: The statement UPDATE changes the content of one or more lines of the database table specified in target. The entries in source determine which columns of which lines are changed, and how they are changed. If no records in the target system are found, a new record will be created.

Update target source.

Reward if useful.

Regards

Sayee

Re: update the database table

Former Member — Sat, 23 Feb 2008 14:35:33 GMT

using update and modify we can update the database table