update the database table

[Former Member]

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

Cheers,

Reddy.

[Former Member]

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

Cheers,

Rakesh.

[Former Member]

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

[Former Member]

using update and modify we can update the database table